Oracle Fusion Financials Tables


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.

Demo Day 1 Video:

You can find more information about Oracle Fusion Financials Cloud in this Oracle Fusion Financials Cloud



Unogeeks is the No.1 IT Training Institute for Oracle Fusion Financials Training. Anyone Disagree? Please drop in a comment

You can check out our other latest blogs on  Oracle Fusion Financials Cloud here – Oracle Fusion Financials Blogs

You can check out our Best In Class Oracle Fusion Financials Training Details here – Oracle Fusion Financials Training

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *