Oracle APPS Important Tables

ONT- Order Management

Table Name DescriptionOE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.OE_ORDER_LINES_ALL OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.OE_ORDER_SOURCES Feeder System Names that create orders in Order Management tables.OE_ORDER_HOLDS_ALL This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.OE_SALES_CREDITS This table stores information about sales credits.OE_TRANSACTION_TYPES_ALL This table stores information about the order and line transaction typesWSH_DELIVERY_ASSIGNMENTS Delivery AssignmentsWSH_DELIVERY_DETAILS Delivery DetailsWSH_NEW_DELIVERIES DeliveriesWSH_TRIPS TripsWSH_TRIP_STOPS Trip Stops

PO - Purchasing

Table Name DescriptionPO_ACTION_HISTORY Document approval and control action history tablePO_AGENTS Buyers tablePO_DISTRIBUTIONS_ALL Purchase order distributionsPO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)PO_RELEASES_ALL Purchase order releasesPO_LINES_ARCHIVE_ALL Archived purchase order linesPO_LINE_LOCATIONS_ARCHIVE_ALL Archived purchase order shipmentsPO_HEADERS_ARCHIVE_ALL Archived purchase ordersPO_LINE_TYPES_B Line typesPO_RELEASES_ARCHIVE_ALL Archived releasesPO_REQUISITION_HEADERS_ALL Requisition headersPO_REQUISITION_LINES_ALL Requisition linesPO_REQ_DISTRIBUTIONS_ALL Requisition distributionsRCV_TRANSACTIONS Receiving transactionsRCV_SHIPMENT_HEADERS Shipment and receipt header informationRCV_SHIPMENT_LINES Receiving shipment line information

Oracle APPS Important Tables

ONT- Order Management

Table Name DescriptionOE_ORDER_HEADERS_ALL OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.OE_ORDER_LINES_ALL OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.OE_ORDER_SOURCES Feeder System Names that create orders in Order Management tables.OE_ORDER_HOLDS_ALL This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.OE_SALES_CREDITS This table stores information about sales credits.OE_TRANSACTION_TYPES_ALL This table stores information about the order and line transaction typesWSH_DELIVERY_ASSIGNMENTS Delivery AssignmentsWSH_DELIVERY_DETAILS Delivery DetailsWSH_NEW_DELIVERIES DeliveriesWSH_TRIPS TripsWSH_TRIP_STOPS Trip Stops

PO - Purchasing

Table Name DescriptionPO_ACTION_HISTORY Document approval and control action history tablePO_AGENTS Buyers tablePO_DISTRIBUTIONS_ALL Purchase order distributionsPO_HEADERS_ALL Document headers (for purchase orders, purchase agreements, quotations, RFQs)PO_LINES_ALL Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)PO_LINE_LOCATIONS_ALL Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)PO_RELEASES_ALL Purchase order releasesPO_LINES_ARCHIVE_ALL Archived purchase order linesPO_LINE_LOCATIONS_ARCHIVE_ALL Archived purchase order shipmentsPO_HEADERS_ARCHIVE_ALL Archived purchase ordersPO_LINE_TYPES_B Line typesPO_RELEASES_ARCHIVE_ALL Archived releasesPO_REQUISITION_HEADERS_ALL Requisition headersPO_REQUISITION_LINES_ALL Requisition linesPO_REQ_DISTRIBUTIONS_ALL Requisition distributionsRCV_TRANSACTIONS Receiving transactionsRCV_SHIPMENT_HEADERS Shipment and receipt header informationRCV_SHIPMENT_LINES Receiving shipment line information

INV Inventory

Table Name DescriptionMTL_CATEGORIES_B Code combinations table for Item CategoryMTL_CATEGORY_SETS_B Category SetsMTL_CUSTOMER_ITEMS Customer item InformationMTL_CUSTOMER_ITEM_XREFS Relationships between customer items and inventory itemsMTL_DEMAND Sales order demand and reservationsMTL_DEMAND_HISTORIES Sales order demand and reservationsMTL_ITEM_LOCATIONS Definitions for stock locatorsMTL_ITEM_REVISIONS_B Item revisionsMTL_ITEM_TEMPLATES_B Item template definitionsMTL_ITEM_TEMPL_ATTRIBUTES Item attributes and attribute values for a templateMTL_LOT_NUMBERS Lot number definitionsMTL_MATERIAL_TRANSACTIONS Material transaction tableMTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for processing material transactionsMTL_ONHAND_QUANTITIES_DETAIL FIFO quantities by control level and receiptMTL_PARAMETERS Inventory control options and defaultsMTL_RESERVATIONS ReservationsMTL_SECONDARY_INVENTORIES Subinventory definitionsMTL_SECONDARY_LOCATORS Item-subinventory-locator assignmentsMTL_SERIAL_NUMBERS Serial number definitionsMTL_SYSTEM_ITEMS_B Inventory item definitionsMTL_TRANSACTION_ACCOUNTS Material transaction distributionsMTL_TRANSACTION_TYPES Inventory Transaction Types TableMTL_TXN_REQUEST_HEADERS Move Order headers tableMTL_TXN_REQUEST_LINES Move order lines tableMTL_UNIT_TRANSACTIONS Serial number transactions

GL- General Ledger

Table Name DescriptionGL_CODE_COMBINATIONS Stores valid account combinationsGL_SETS_OF_BOOKS Stores information about the sets of booksGL_IMPORT_REFERENCES Stores individual transactions from subledgersGL_DAILY_RATES Stores the daily conversion rates for foreign currency

TransactionsGL_PERIODS Stores information about the accounting periodsGL_JE_HEADERS Stores journal entriesGL_JE_LINES Stores the journal entry lines that you enter in the Enter Journals formGL_JE_BATCHES Stores journal entry batchesGL_BALANCES Stores actual, budget, and encumbrance balances for detail and summary accountsGL_BUDGETS Stores Budget definitionsGL_INTERFACE Import journal entry batchesGL_BUDGET_INTERFACE Upload budget data from external sourcesGL_DAILY_RATES_INTERFACE Import daily conversion rates

AR- Accounts Receivables

Table Name DescriptionRA_CUST_TRX_TYPES_ALL Transaction type for invoices, commitments and credit memosRA_CUSTOMER_TRX_ALL Header-level information about invoices, debit memos, chargebacks, commitments and credit memosRA_CUSTOMER_TRX_LINES_ALL Invoice, debit memo, chargeback, credit memo and commitment linesRA_CUST_TRX_LINE_GL_DIST_ALL Accounting records for revenue, unearned revenue and unbilled receivablesRA_CUST_TRX_LINE_SALESREPS_ALL Sales credit assignments for transactionsAR_ADJUSTMENTS_ALL Pending and approved invoice adjustmentsRA_BATCHES_ALLAR_CASH_RECEIPTS_ALL Detailed receipt informationAR_CASH_RECEIPT_HISTORY_ALL History of actions and status changes in the life cycle of a receiptAR_PAYMENT_SCHEDULES_ALL All transactions except adjustments and miscellaneous cash receiptsAR_RECEIVABLE_APPLICATIONS_ALL Accounting information for cash and credit memo applicationsAR_TRANSACTION_HISTORY_ALL Life cycle of a transactionHZ_CUST_ACCOUNTS Stores information about customer accounts.HZ_CUSTOMER_PROFILES Credit information for customer accounts and customer account sitesHZ_CUST_ACCT_SITES_ALL Stores all customer account sites across all operating unitsHZ_CUST_ACCT_RELATE_ALL Relationships between customer accountsHZ_CUST_CONTACT_POINTS This table is no longer usedHZ_CUST_PROF_CLASS_AMTS Customer profile class amount limits for each currencyHZ_CUST_SITE_USES_ALL Stores business purposes assigned to customer account sites.HZ_LOCATIONS Physical addressesHZ_ORG_CONTACTS People as contacts for partiesHZ_ORG_CONTACT_ROLES Roles played by organization contactsHZ_PARTIES Information about parties such as organizations, people, and groupsHZ_PARTY_SITES Links party to physical locationsHZ_PARTY_SITE_USES The way that a party uses a particular site or addressHZ_RELATIONSHIPS Relationships between entitiesHZ_RELATIONSHIP_TYPES Relationship types

CE- Cash Management

Table Name DescriptionCE_BANK_ACCOUNTS This table contains bank account information. Each bank account must be affiliated with one bank branch.CE_BANK_ACCT_BALANCES This table stores the internal bank account balancesCE_BANK_ACCT_USES_ALL This table stores information about your bank account uses.CE_STATEMENT_HEADERS Bank statementsCE_STATEMENT_LINES Bank statement linesCE_STATEMENT_HEADERS_INT Open interface for bank statementsCE_STATEMENT_LINES_INTERFACE Open interface for bank statement linesCE_TRANSACTION_CODES Bank transaction codes

AP- Accounts Payables

Table Name DescriptionAP_ACCOUNTING_EVENTS_ALL Accounting events tableAP_AE_HEADERS_ALL Accounting entry headers tableAP_AE_LINES_ALL Accounting entry lines tableAP_BANK_ACCOUNTS_ALL Bank Account DetailsAP_BANK_ACCOUNT_USES_ALL Bank Account Uses InformationAP_BANK_BRANCHES Bank BranchesAP_BATCHES_ALL Summary invoice batch informationAP_CHECKS_ALL Supplier payment dataAP_HOLDS_ALL Invoice hold informationAP_INVOICES_ALL Detailed invoice recordsAP_INVOICE_LINES_ALL AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.AP_INVOICE_DISTRIBUTIONS_ALL Invoice distribution line informationAP.AP_INVOICE_PAYMENTS_ALL Invoice payment recordsAP_PAYMENT_DISTRIBUTIONS_ALL Payment distribution informationAP_PAYMENT_HISTORY_ALL Maturity and reconciliation history for paymentsAP_PAYMENT_SCHEDULES_ALL Scheduled payment information on invoicesAP_INTERFACE_REJECTIONS Information about data that could not be loaded by Payables Open Interface ImportAP_INVOICES_INTERFACE Information used to create an invoice using Payables Open Interface ImportAP_INVOICE_LINES_INTERFACE Information used to create one or more invoice distributionsAP_SUPPLIERS AP_SUPPLIERS stores information about your supplier level attributes.AP_SUPPLIER_SITES_ALL AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.AP_SUPPLIER_CONTACTS Stores Supplier Contacts

FA Fixed Assets

Table Name DescriptionFA_ADDITIONS_B Descriptive information about assetsFA_ADJUSTMENTS Information used by the posting program to generate journal entry lines in the general ledgerFA_ASSET_HISTORY Historical information about asset reclassifications and unit adjustmentsFA_ASSET_INVOICES Accounts payable and purchasing information for each assetFA_BOOKS Financial information of each assetFA_BOOK_CONTROLS Control information that affects all assets in a depreciation bookFA_CALENDAR_PERIODS Detailed calendar informationFA_CALENDAR_TYPES General calendar informationFA_CATEGORIES_B Default financial information for asset categoriesFA_CATEGORY_BOOKS Default financial information for an asset category and depreciation book combinationFA_DEPRN_DETAIL Depreciation amounts charged to the depreciation expense account in each distribution lineFA_DEPRN_PERIODS Information about each depreciation periodFA_DEPRN_EVENTS Information about depreciation accounting events.FA_DEPRN_SUMMARY Depreciation information at the asset levelFA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all distributions for a bookFA_DISTRIBUTION_DEFAULTS Distribution set informationFA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield values assigned to each assetFA_DISTRIBUTION_SETS Header information for distribution setsFA_FORMULAS Depreciation rates for formula-based methodsFA_LOCATIONS Location flexfield segment value combinationsFA_MASS_ADDITIONS Information about assets that you want to automatically add to Oracle Assets from another systemFA_METHODS Depreciation method informationFA_RETIREMENTS Information about asset retirements and reinstatements

HRMS- Human Resource Management System

Table Name DescriptionHR_ALL_ORGANIZATION_UNITS Organization unit definitions.HR_ALL_POSITIONS_F Position definition information.HR_LOCATIONS_ALL Work location definitions.PER_ADDRESSES Address information for peoplePER_ALL_PEOPLE_F DateTracked table holding personal information for employees, applicants and other people.PER_ALL_ASSIGNMENTS_F Allocated TasksPER_ANALYSIS_CRITERIA Flexfield combination table for the personal analysis key flexfield.PER_ASSIGNMENT_EXTRA_INFO Extra information for an assignment.PER_ASSIGNMENT_STATUS_TYPES Predefined and user defined assignment status types.PER_CONTRACTS_F The details of a persons contract of employmentPER_CONTACT_RELATIONSHIPS Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.PER_GRADES Grade definitions for a business group.PER_JOBS Jobs defined for a Business GroupPER_PAY_BASES Definitions of specific salary basesPER_PAY_PROPOSALS Salary proposals and performance review information for employee assignmentsPER_PEOPLE_EXTRA_INFO Extra information for a personPER_PERIODS_OF_PLACEMENT Periods of placement details for a non-payrolled workerPER_PERIODS_OF_SERVICE Period of service details for an employee.PER_PERSON_ANALYSES Special information types for a personPER_PERSON_TYPES Person types visible to specific Business Groups.PER_PERSON_TYPE_USAGES_F Identifies the types a person may be.PER_PHONES PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.PER_SECURITY_PROFILES Security profile definitions to restrict user access to specific HRMS records

PAY- Payroll

Table Name DescriptionPAY_ACTION_INFORMATION Archived data stored by legislationPAY_ALL_PAYROLLS_F Payroll group definitions.PAY_ASSIGNMENT_ACTIONS Action or process results, showing which assignments have been processed by a specific payroll action, or process.PAY_ELEMENT_CLASSIFICATIONS Element classifications for legislation and information needs.PAY_ELEMENT_ENTRIES_F Element entry list for each assignment.PAY_ELEMENT_ENTRY_VALUES_F Actual input values for specific element entries.PAY_ELEMENT_LINKS_F Eligibility rules for an element type.PAY_ELEMENT_TYPES_F Element definitions.PAY_ELEMENT_TYPE_USAGES_F Used to store elements included or excluded from a defined run type.PAY_ORG_PAYMENT_METHODS_F Payment methods used by a Business Group.PAY_PAYMENT_TYPES Types of payment that can be processed by the system.PAY_PAYROLL_ACTIONS Holds information about a payroll process.PAY_PEOPLE_GROUPS People group flexfield information.PAY_PERSONAL_PAYMENT_METHODS_F Personal payment method details for an employee.PAY_RUN_RESULTS Result of processing a single element entry.PAY_RUN_RESULT_VALUES Result values from processing a single element entry.PAY_SECURITY_PAYROLLS List of payrolls and security profile access rules.PAY_INPUT_VALUES_F Input value definitions for specific elements.

BOM Bills Of Material

Table Name DescriptionBOM_DEPARTMENTS DepartmentsBOM_DEPARTMENT_CLASSES Department classesBOM_DEPARTMENT_RESOURCES Resources associated with departmentsBOM_OPERATIONAL_ROUTINGS RoutingsBOM_OPERATION_NETWORKS Routing operation networksBOM_OPERATION_RESOURCES Resources on operationsBOM_OPERATION_SEQUENCES Routing operationsBOM_OPERATION_SKILLSBOM_RESOURCES Resources, overheads, material cost codes, and material overheadsBOM_STANDARD_OPERATIONS Standard operationsBOM_ALTERNATE_DESIGNATORS Alternate designatorsBOM_COMPONENTS_B Bill of material componentsBOM_STRUCTURES_B Bills of materialBOM_STRUCTURE_TYPES_B Structure Type master table

WIP Work in Process

Table Name DescriptionWIP_DISCRETE_JOBS Discrete jobsWIP_ENTITIES Information common to jobs and schedulesWIP_LINES Production linesWIP_MOVE_TRANSACTIONS Shop floor move transactionsWIP_MOVE_TXN_ALLOCATIONS Move transaction allocations for repetitive schedulesWIP_OPERATIONS Operations necessary for jobs and schedulesWIP_OPERATION_NETWORKS Operation dependencyWIP_OPERATION_OVERHEADS Overheads for operations in an average costing organizationWIP_OPERATION_RESOURCES Resources necessary for operationsWIP_OPERATION_YIELDS This table keeps all costing information for operation yield costing.WIP_TRANSACTIONS WIP resource transactionsWIP_TRANSACTION_ACCOUNTS Debits and credits due to resource transactions

FND Appication Object Library

Table Name DescriptionFND_APPLICATION Applications registered with Oracle Application Object LibraryFND_CONCURRENT_PROGRAMS Concurrent programsFND_CONCURRENT_REQUESTS Concurrent requests informationFND_CURRENCIES Currencies enabled for use at your siteFND_DATA_GROUPS Data groups registered with Oracle Application Object LibraryFND_FLEX_VALUES Valid values for flexfield segmentsFND_FLEX_VALUE_HIERARCHIES Child value ranges for key flexfield segment valuesFND_FLEX_VALUE_SETS Value sets used by both key and descriptive flexfieldsFND_FORM Application forms registered with Oracle Application Object LibraryFND_FORM_FUNCTIONS Functionality groupingsFND_ID_FLEXS Registration information about key flexfieldsFND_ID_FLEX_SEGMENTS Key flexfield segments setup information and correspondences between table columns and key flexfield segmentsFND_ID_FLEX_STRUCTURES Key flexfield structure informationFND_LOOKUP_TYPES Oracle Application Object Library QuickCodesFND_LOOKUP_VALUES QuickCode valuesFND_MENUS New menu tabl for Release 10SCFND_PROFILE_OPTIONS User profile optionsFND_PROFILE_OPTION_VALUES Values of user profile options defined at different profile levelsFND_REQUEST_SETS Reports setsFND_REQUEST_SET_PROGRAMS Reports within report setsFND_REQUEST_SET_STAGES Stores request set stagesFND_RESPONSIBILITY ResponsibilitiesFND_RESP_FUNCTIONS Function SecurityFND_USER Application users

JA - Asia/Pacific Localizations

Table Name DescriptionJAI_CMN_BOE_HDRS Stores BOE header info when a BOE Invoice is created through ILJAI_CMN_BOE_DTLS Detail table for BOE InvoicesJAI_CMN_TAXES_ALL Master table for Localization TaxesJAI_CMN_TAX_CTGS_ALL Stores tax categories and their link to excise ITEM classes.JAI_CMN_TAX_CTG_LINES Stores the tax lines for defined tax categoriesJAI_CMN_VENDOR_SITES Stores excise account related information about vendors.JAI_RGM_DEFINITIONS Stores regime information.JAI_RGM_TAXES This table stores tax details for transactions having TCS tax type.JAI_CMN_RG_23AC_I_TRXS Stores Information of RG23A/C records and known as Quantity Register.JAI_CMN_RG_23AC_II_TRXS Stores Information of RG23A/C Part II Details. Also known as Amount RegisterJAI_CMN_RG_23D_TRXS Quantity register for Trading OrganizationsJAI_CMN_RG_BALANCES Store the current balances of RG23A, RG23C and PLA RegistersJAI_CMN_RG_PLA_TRXS Stores the Transaction Information of PLA Register.JAI_CMN_RG_PLA_HDRS Stores PLA header Infomation when a PLA invoice is created in AP moduleJAI_CMN_RG_PLA_DTLS Stores PLA Detail Information when a PLA Invoice is created in AP Module

QP Advanced Pricing

Table Name DescriptionQP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.

XLA - Subledger Accounting

Table Name DescriptionXLA_EVENTS The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.XLA_TRANSACTION_ENTITIES The table XLA_ENTITIES contains information about sub-ledger document or transactions.XLA_AE_HEADERS The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.XLA_AE_LINES The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.XLA_DISTRIBUTION_LINKS The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.XLA_ACCOUNTING_ERRORS The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.XLA_ACCTG_METHODS_B The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.XLA_EVENT_TYPES_B The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.XLA_GL_LEDGERS This table contains ledger information used by subledger accounting.

Table Name DescriptionMTL_CATEGORIES_B Code combinations table for Item CategoryMTL_CATEGORY_SETS_B Category SetsMTL_CUSTOMER_ITEMS Customer item InformationMTL_CUSTOMER_ITEM_XREFS Relationships between customer items and inventory itemsMTL_DEMAND Sales order demand and reservationsMTL_DEMAND_HISTORIES Sales order demand and reservationsMTL_ITEM_LOCATIONS Definitions for stock locatorsMTL_ITEM_REVISIONS_B Item revisionsMTL_ITEM_TEMPLATES_B Item template definitionsMTL_ITEM_TEMPL_ATTRIBUTES Item attributes and attribute values for a templateMTL_LOT_NUMBERS Lot number definitionsMTL_MATERIAL_TRANSACTIONS Material transaction tableMTL_MATERIAL_TRANSACTIONS_TEMP Temporary table for processing material transactionsMTL_ONHAND_QUANTITIES_DETAIL FIFO quantities by control level and receiptMTL_PARAMETERS Inventory control options and defaultsMTL_RESERVATIONS ReservationsMTL_SECONDARY_INVENTORIES Subinventory definitionsMTL_SECONDARY_LOCATORS Item-subinventory-locator assignmentsMTL_SERIAL_NUMBERS Serial number definitionsMTL_SYSTEM_ITEMS_B Inventory item definitionsMTL_TRANSACTION_ACCOUNTS Material transaction distributionsMTL_TRANSACTION_TYPES Inventory Transaction Types TableMTL_TXN_REQUEST_HEADERS Move Order headers tableMTL_TXN_REQUEST_LINES Move order lines tableMTL_UNIT_TRANSACTIONS Serial number transactions

GL- General Ledger

Table Name DescriptionGL_CODE_COMBINATIONS Stores valid account combinationsGL_SETS_OF_BOOKS Stores information about the sets of booksGL_IMPORT_REFERENCES Stores individual transactions from subledgersGL_DAILY_RATES Stores the daily conversion rates for foreign currency

TransactionsGL_PERIODS Stores information about the accounting periodsGL_JE_HEADERS Stores journal entriesGL_JE_LINES Stores the journal entry lines that you enter in the Enter Journals formGL_JE_BATCHES Stores journal entry batchesGL_BALANCES Stores actual, budget, and encumbrance balances for detail and summary accountsGL_BUDGETS Stores Budget definitionsGL_INTERFACE Import journal entry batchesGL_BUDGET_INTERFACE Upload budget data from external sourcesGL_DAILY_RATES_INTERFACE Import daily conversion rates

AR- Accounts Receivables

Table Name DescriptionRA_CUST_TRX_TYPES_ALL Transaction type for invoices, commitments and credit memosRA_CUSTOMER_TRX_ALL Header-level information about invoices, debit memos, chargebacks, commitments and credit memosRA_CUSTOMER_TRX_LINES_ALL Invoice, debit memo, chargeback, credit memo and commitment linesRA_CUST_TRX_LINE_GL_DIST_ALL Accounting records for revenue, unearned revenue and unbilled receivablesRA_CUST_TRX_LINE_SALESREPS_ALL Sales credit assignments for transactionsAR_ADJUSTMENTS_ALL Pending and approved invoice adjustmentsRA_BATCHES_ALLAR_CASH_RECEIPTS_ALL Detailed receipt informationAR_CASH_RECEIPT_HISTORY_ALL History of actions and status changes in the life cycle of a receiptAR_PAYMENT_SCHEDULES_ALL All transactions except adjustments and miscellaneous cash receiptsAR_RECEIVABLE_APPLICATIONS_ALL Accounting information for cash and credit memo applicationsAR_TRANSACTION_HISTORY_ALL Life cycle of a transactionHZ_CUST_ACCOUNTS Stores information about customer accounts.HZ_CUSTOMER_PROFILES Credit information for customer accounts and customer account sitesHZ_CUST_ACCT_SITES_ALL Stores all customer account sites across all operating unitsHZ_CUST_ACCT_RELATE_ALL Relationships between customer accountsHZ_CUST_CONTACT_POINTS This table is no longer usedHZ_CUST_PROF_CLASS_AMTS Customer profile class amount limits for each currencyHZ_CUST_SITE_USES_ALL Stores business purposes assigned to customer account sites.HZ_LOCATIONS Physical addressesHZ_ORG_CONTACTS People as contacts for partiesHZ_ORG_CONTACT_ROLES Roles played by organization contactsHZ_PARTIES Information about parties such as organizations, people, and groupsHZ_PARTY_SITES Links party to physical locationsHZ_PARTY_SITE_USES The way that a party uses a particular site or addressHZ_RELATIONSHIPS Relationships between entitiesHZ_RELATIONSHIP_TYPES Relationship types

CE- Cash Management

Table Name DescriptionCE_BANK_ACCOUNTS This table contains bank account information. Each bank account must be affiliated with one bank branch.CE_BANK_ACCT_BALANCES This table stores the internal bank account balancesCE_BANK_ACCT_USES_ALL This table stores information about your bank account uses.CE_STATEMENT_HEADERS Bank statementsCE_STATEMENT_LINES Bank statement linesCE_STATEMENT_HEADERS_INT Open interface for bank statementsCE_STATEMENT_LINES_INTERFACE Open interface for bank statement linesCE_TRANSACTION_CODES Bank transaction codes

AP- Accounts Payables

Table Name DescriptionAP_ACCOUNTING_EVENTS_ALL Accounting events tableAP_AE_HEADERS_ALL Accounting entry headers tableAP_AE_LINES_ALL Accounting entry lines tableAP_BANK_ACCOUNTS_ALL Bank Account DetailsAP_BANK_ACCOUNT_USES_ALL Bank Account Uses InformationAP_BANK_BRANCHES Bank BranchesAP_BATCHES_ALL Summary invoice batch informationAP_CHECKS_ALL Supplier payment dataAP_HOLDS_ALL Invoice hold informationAP_INVOICES_ALL Detailed invoice recordsAP_INVOICE_LINES_ALL AP_INVOICE_LINES_ALL contains records for invoice lines entered manually, generated automatically or imported from the Open Interface.AP_INVOICE_DISTRIBUTIONS_ALL Invoice distribution line informationAP.AP_INVOICE_PAYMENTS_ALL Invoice payment recordsAP_PAYMENT_DISTRIBUTIONS_ALL Payment distribution informationAP_PAYMENT_HISTORY_ALL Maturity and reconciliation history for paymentsAP_PAYMENT_SCHEDULES_ALL Scheduled payment information on invoicesAP_INTERFACE_REJECTIONS Information about data that could not be loaded by Payables Open Interface ImportAP_INVOICES_INTERFACE Information used to create an invoice using Payables Open Interface ImportAP_INVOICE_LINES_INTERFACE Information used to create one or more invoice distributionsAP_SUPPLIERS AP_SUPPLIERS stores information about your supplier level attributes.AP_SUPPLIER_SITES_ALL AP_SUPPLIER_SITES_ALL stores information about your supplier site level attributes.AP_SUPPLIER_CONTACTS Stores Supplier Contacts

FA Fixed Assets

Table Name DescriptionFA_ADDITIONS_B Descriptive information about assetsFA_ADJUSTMENTS Information used by the posting program to generate journal entry lines in the general ledgerFA_ASSET_HISTORY Historical information about asset reclassifications and unit adjustmentsFA_ASSET_INVOICES Accounts payable and purchasing information for each assetFA_BOOKS Financial information of each assetFA_BOOK_CONTROLS Control information that affects all assets in a depreciation bookFA_CALENDAR_PERIODS Detailed calendar informationFA_CALENDAR_TYPES General calendar informationFA_CATEGORIES_B Default financial information for asset categoriesFA_CATEGORY_BOOKS Default financial information for an asset category and depreciation book combinationFA_DEPRN_DETAIL Depreciation amounts charged to the depreciation expense account in each distribution lineFA_DEPRN_PERIODS Information about each depreciation periodFA_DEPRN_EVENTS Information about depreciation accounting events.FA_DEPRN_SUMMARY Depreciation information at the asset levelFA_DISTRIBUTION_ACCOUNTS Table to store account ccids for all distributions for a bookFA_DISTRIBUTION_DEFAULTS Distribution set informationFA_DISTRIBUTION_HISTORY Employee, location, and Accounting Flexfield values assigned to each assetFA_DISTRIBUTION_SETS Header information for distribution setsFA_FORMULAS Depreciation rates for formula-based methodsFA_LOCATIONS Location flexfield segment value combinationsFA_MASS_ADDITIONS Information about assets that you want to automatically add to Oracle Assets from another systemFA_METHODS Depreciation method informationFA_RETIREMENTS Information about asset retirements and reinstatements

HRMS- Human Resource Management System

Table Name DescriptionHR_ALL_ORGANIZATION_UNITS Organization unit definitions.HR_ALL_POSITIONS_F Position definition information.HR_LOCATIONS_ALL Work location definitions.PER_ADDRESSES Address information for peoplePER_ALL_PEOPLE_F DateTracked table holding personal information for employees, applicants and other people.PER_ALL_ASSIGNMENTS_F Allocated TasksPER_ANALYSIS_CRITERIA Flexfield combination table for the personal analysis key flexfield.PER_ASSIGNMENT_EXTRA_INFO Extra information for an assignment.PER_ASSIGNMENT_STATUS_TYPES Predefined and user defined assignment status types.PER_CONTRACTS_F The details of a persons contract of employmentPER_CONTACT_RELATIONSHIPS Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.PER_GRADES Grade definitions for a business group.PER_JOBS Jobs defined for a Business GroupPER_PAY_BASES Definitions of specific salary basesPER_PAY_PROPOSALS Salary proposals and performance review information for employee assignmentsPER_PEOPLE_EXTRA_INFO Extra information for a personPER_PERIODS_OF_PLACEMENT Periods of placement details for a non-payrolled workerPER_PERIODS_OF_SERVICE Period of service details for an employee.PER_PERSON_ANALYSES Special information types for a personPER_PERSON_TYPES Person types visible to specific Business Groups.PER_PERSON_TYPE_USAGES_F Identifies the types a person may be.PER_PHONES PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.PER_SECURITY_PROFILES Security profile definitions to restrict user access to specific HRMS records

PAY- Payroll

Table Name DescriptionPAY_ACTION_INFORMATION Archived data stored by legislationPAY_ALL_PAYROLLS_F Payroll group definitions.PAY_ASSIGNMENT_ACTIONS Action or process results, showing which assignments have been processed by a specific payroll action, or process.PAY_ELEMENT_CLASSIFICATIONS Element classifications for legislation and information needs.PAY_ELEMENT_ENTRIES_F Element entry list for each assignment.PAY_ELEMENT_ENTRY_VALUES_F Actual input values for specific element entries.PAY_ELEMENT_LINKS_F Eligibility rules for an element type.PAY_ELEMENT_TYPES_F Element definitions.PAY_ELEMENT_TYPE_USAGES_F Used to store elements included or excluded from a defined run type.PAY_ORG_PAYMENT_METHODS_F Payment methods used by a Business Group.PAY_PAYMENT_TYPES Types of payment that can be processed by the system.PAY_PAYROLL_ACTIONS Holds information about a payroll process.PAY_PEOPLE_GROUPS People group flexfield information.PAY_PERSONAL_PAYMENT_METHODS_F Personal payment method details for an employee.PAY_RUN_RESULTS Result of processing a single element entry.PAY_RUN_RESULT_VALUES Result values from processing a single element entry.PAY_SECURITY_PAYROLLS List of payrolls and security profile access rules.PAY_INPUT_VALUES_F Input value definitions for specific elements.

BOM Bills Of Material

Table Name DescriptionBOM_DEPARTMENTS DepartmentsBOM_DEPARTMENT_CLASSES Department classesBOM_DEPARTMENT_RESOURCES Resources associated with departmentsBOM_OPERATIONAL_ROUTINGS RoutingsBOM_OPERATION_NETWORKS Routing operation networksBOM_OPERATION_RESOURCES Resources on operationsBOM_OPERATION_SEQUENCES Routing operationsBOM_OPERATION_SKILLSBOM_RESOURCES Resources, overheads, material cost codes, and material overheadsBOM_STANDARD_OPERATIONS Standard operationsBOM_ALTERNATE_DESIGNATORS Alternate designatorsBOM_COMPONENTS_B Bill of material componentsBOM_STRUCTURES_B Bills of materialBOM_STRUCTURE_TYPES_B Structure Type master table

WIP Work in Process

Table Name DescriptionWIP_DISCRETE_JOBS Discrete jobsWIP_ENTITIES Information common to jobs and schedulesWIP_LINES Production linesWIP_MOVE_TRANSACTIONS Shop floor move transactionsWIP_MOVE_TXN_ALLOCATIONS Move transaction allocations for repetitive schedulesWIP_OPERATIONS Operations necessary for jobs and schedulesWIP_OPERATION_NETWORKS Operation dependencyWIP_OPERATION_OVERHEADS Overheads for operations in an average costing organizationWIP_OPERATION_RESOURCES Resources necessary for operationsWIP_OPERATION_YIELDS This table keeps all costing information for operation yield costing.WIP_TRANSACTIONS WIP resource transactionsWIP_TRANSACTION_ACCOUNTS Debits and credits due to resource transactions

FND Appication Object Library

Table Name DescriptionFND_APPLICATION Applications registered with Oracle Application Object LibraryFND_CONCURRENT_PROGRAMS Concurrent programsFND_CONCURRENT_REQUESTS Concurrent requests informationFND_CURRENCIES Currencies enabled for use at your siteFND_DATA_GROUPS Data groups registered with Oracle Application Object LibraryFND_FLEX_VALUES Valid values for flexfield segmentsFND_FLEX_VALUE_HIERARCHIES Child value ranges for key flexfield segment valuesFND_FLEX_VALUE_SETS Value sets used by both key and descriptive flexfieldsFND_FORM Application forms registered with Oracle Application Object LibraryFND_FORM_FUNCTIONS Functionality groupingsFND_ID_FLEXS Registration information about key flexfieldsFND_ID_FLEX_SEGMENTS Key flexfield segments setup information and correspondences between table columns and key flexfield segmentsFND_ID_FLEX_STRUCTURES Key flexfield structure informationFND_LOOKUP_TYPES Oracle Application Object Library QuickCodesFND_LOOKUP_VALUES QuickCode valuesFND_MENUS New menu tabl for Release 10SCFND_PROFILE_OPTIONS User profile optionsFND_PROFILE_OPTION_VALUES Values of user profile options defined at different profile levelsFND_REQUEST_SETS Reports setsFND_REQUEST_SET_PROGRAMS Reports within report setsFND_REQUEST_SET_STAGES Stores request set stagesFND_RESPONSIBILITY ResponsibilitiesFND_RESP_FUNCTIONS Function SecurityFND_USER Application users

JA - Asia/Pacific Localizations

Table Name DescriptionJAI_CMN_BOE_HDRS Stores BOE header info when a BOE Invoice is created through ILJAI_CMN_BOE_DTLS Detail table for BOE InvoicesJAI_CMN_TAXES_ALL Master table for Localization TaxesJAI_CMN_TAX_CTGS_ALL Stores tax categories and their link to excise ITEM classes.JAI_CMN_TAX_CTG_LINES Stores the tax lines for defined tax categoriesJAI_CMN_VENDOR_SITES Stores excise account related information about vendors.JAI_RGM_DEFINITIONS Stores regime information.JAI_RGM_TAXES This table stores tax details for transactions having TCS tax type.JAI_CMN_RG_23AC_I_TRXS Stores Information of RG23A/C records and known as Quantity Register.JAI_CMN_RG_23AC_II_TRXS Stores Information of RG23A/C Part II Details. Also known as Amount RegisterJAI_CMN_RG_23D_TRXS Quantity register for Trading OrganizationsJAI_CMN_RG_BALANCES Store the current balances of RG23A, RG23C and PLA RegistersJAI_CMN_RG_PLA_TRXS Stores the Transaction Information of PLA Register.JAI_CMN_RG_PLA_HDRS Stores PLA header Infomation when a PLA invoice is created in AP moduleJAI_CMN_RG_PLA_DTLS Stores PLA Detail Information when a PLA Invoice is created in AP Module

QP Advanced Pricing

Table Name DescriptionQP_LIST_HEADERS_B QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINES QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B.QP_PRICE_FORMULAS_B QP_PRICE_FORMULAS_B stores the pricing formula header information.QP_PRICE_FORMULA_LINES QP_PRICE_FORMULA_LINES stores each component that makes up the formula.QP_PRICING_ATTRIBUTES QP_PRICING_ATTRIBUTES stores product information and pricing attributes.QP_QUALIFIERS QP_QUALIFIERS stores qualifier attribute information.

XLA - Subledger Accounting

Table Name DescriptionXLA_EVENTS The XLA_EVENTS table record all information related to a specific event. This table is created as a type XLA_ARRAY_EVENT_TYPE.XLA_TRANSACTION_ENTITIES The table XLA_ENTITIES contains information about sub-ledger document or transactions.XLA_AE_HEADERS The XLA_AE_HEADERS table stores subledger journal entries. There is a one-to-many relationship between accounting events and journal entry headers.XLA_AE_LINES The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.XLA_DISTRIBUTION_LINKS The XLA_DISTRIBUTION_LINKS table stores the link between transactions and subledger journal entry lines.XLA_ACCOUNTING_ERRORS The XLA_ACCOUNTING_ERRORS table stores the errors encountered during execution of the Accounting Program.XLA_ACCTG_METHODS_B The XLA_ACCTG_METHODS_B table stores Subledger Accounting Methods (SLAM) across products. SLAMs provided by development are not chart of accounts specific. Enabled SLAMs are assigned to ledgers.XLA_EVENT_TYPES_B The XLA_EVENT_TYPES_B table stores all event types that belong to an event class.XLA_GL_LEDGERS This table contains ledger information used by subledger accounting