Oracle Fusion Financials Tables

Oracle Fusion Financials encompasses a vast number of tables that store financial data and support various business processes. Here is a list of some commonly used tables in Oracle Fusion Financials across different modules:

1. General Ledger:

   • GL_LEDGERS: Stores information about the ledgers defined in the system.
   • GL_CODE_COMBINATIONS: Contains the chart of accounts and segment values.
   • GL_JE_HEADERS: Stores journal entry header information.
   • GL_JE_LINES: Contains journal entry line information.

2. Accounts Payable:

   • AP_INVOICES_ALL: Stores information about supplier invoices.
   • AP_SUPPLIERS: Contains supplier details and contact information.
   • AP_PAYMENTS_ALL: Stores payment information made to suppliers.
   • AP_PAYMENT_SCHEDULES_ALL: Contains payment schedule information.

3. Accounts Receivable:

   • AR_INVOICES_ALL: Stores information about customer invoices.
   • AR_CUSTOMERS: Contains customer details and contact information.
   • AR_PAYMENTS_ALL: Stores payment information received from customers.
   • AR_PAYMENT_SCHEDULES_ALL: Contains payment schedule information.

4. Cash Management:

   • CE_BANK_ACCOUNTS: Stores bank account information.
   • CE_STATEMENT_HEADERS: Contains details of bank statements.
   • CE_CASH_FLOW: Stores cash flow information.
   • CE_TRANSACTIONS: Contains transaction details for cash management.

5. Fixed Assets:

   • FA_ASSET_HISTORY: Stores asset transaction history.
   • FA_ADDITIONS_B: Contains information about newly added assets.
   • FA_BOOKS: Stores asset book information.
   • FA_DEPRN_DETAIL: Contains asset depreciation details.

6. Expense Management:

   • AP_EXPENSE_REPORT_HEADERS_ALL: Stores header information for expense reports.
   • AP_EXPENSE_REPORT_LINES_ALL: Contains line-level details of expense reports.
   • AP_EXPENSE_REPORT_PAYMENTS_ALL: Stores payment information for expense reports.

Please note that this is not an exhaustive list, and there are many more tables available in Oracle Fusion Financials, depending on the specific modules and features implemented in your organization. Oracle provides comprehensive documentation, including the Oracle Fusion Financials Application Documentation Library, which offers detailed information on the tables and their structures for each module.