The Oracle Fusion Cloud Order-to-Cash architecture involves several key database tables categorized by their respective modules. These tables facilitate the flow of data from initial order entry through shipping, billing, and final accounting.
1. Order Management (OM) & Shipping
These tables handle the initial sales order and its physical fulfillment:
DOO_ORDER_HEADERS_ALL: Stores sales order header details like customer, currency, and status.
DOO_ORDER_LINES_ALL: Contains specific order line information such as items, quantities, and prices.
DOO_FULFILL_LINES_ALL: Links order lines to their specific orchestration steps and fulfillment statuses.
WSH_DELIVERY_DETAILS: Tracks shipping detail lines, including the quantity shipped and carrier information.
WSH_NEW_DELIVERIES: Holds delivery header information like ship-to locations and Bill of Lading (BOL).
2. AutoInvoice Interface (The Bridge)
These tables serve as a staging area for data moving from Order Management to Receivables. Notably, these four tables retain the same names they had in Oracle EBS.
RA_INTERFACE_LINES_ALL: The primary staging table populated by the "Create Invoice from Ship Confirm" job.
RA_INTERFACE_ERRORS_ALL: Stores validation errors encountered during the AutoInvoice import process.
RA_INTERFACE_DISTRIBUTIONS_ALL: Used for revenue distribution overrides.
RA_INTERFACE_SALESCREDITS_ALL: Manages sales representative credit allocations.
3. Receivables (AR) Core Tables
Once AutoInvoice successfully processes the staged data, it creates records in these core tables:
RA_CUSTOMER_TRX_ALL: The transaction header table for invoices, containing the invoice number and payment terms.
RA_CUSTOMER_TRX_LINES_ALL: Contains individual invoice lines, including unit prices and revenue accounts.
RA_CUST_TRX_LINE_GL_DIST_ALL: Stores accounting distributions for AR, revenue, tax, and freight.
AR_PAYMENT_SCHEDULES_ALL: Tracks payment due dates, installment amounts, and remaining balances.
AR_RECEIVABLE_APPLICATIONS_ALL: Records the application of cash and credit against open invoices.
4. Tax & Subledger Accounting (SLA)
Final tax calculations and accounting entries are stored in these tables:
ZX_LINES: Contains calculated tax lines for each invoice line.
XLA_AE_HEADERS & XLA_AE_LINES: Store subledger accounting journal headers and detailed debit/credit lines.
GL_JE_HEADERS & GL_JE_LINES: Hold the final journal entries after the data is transferred to the General Ledger.
