Oracle to Cash in Oracle Fusion

 Order to Cash (O2C) functional flow and the underlying Fusion tables

1. Order Entry and Booking

Functional Flow: 

A customer places an order. 

The order is entered into the system, validated, and booked. 

Booking action triggers the orchestration process to fulfill the order.

Key Technical Tables:

DOO_HEADERS_ALL (Order Header details)

DOO_LINES_ALL (Order Line details)

DOO_FULFILL_LINES_ALL (Orchestration/Fulfillment details)

2. Pick Release

Functional Flow: The system checks inventory for the item and reserves it. Pick slips are generated for the warehouse staff to pick the items from the shelves and move them to the staging area.

Key Technical Tables:

WSH_DELIVERY_DETAILS (Delivery line information, status changes to 'Released to Warehouse')

WSH_NEW_DELIVERIES (Delivery grouping)

INV_RESERVATIONS (Inventory reservation details)

3.Ship Confirm 

Functional Flow: The warehouse confirms the delivery is loaded and shipped. The delivery is closed, inventory is decremented, and the system prepares the data to be sent to Receivables for invoicing and Costing for COGS.

Key Technical Tables:

WSH_DELIVERY_DETAILS: The delivery lines (Status changes to 'Shipped').

WSH_DELIVERY_ASSIGNMENTS: The crucial mapping table that links the delivery lines (DELIVERY_DETAIL_ID) to the actual delivery header (DELIVERY_ID).

WSH_NEW_DELIVERIES: The delivery header itself (Status updates to 'Closed' or 'In-Transit').

INV_MATERIAL_TXNS: Records the actual deduction of inventory (the material issue transaction).

4. Invoicing (AutoInvoice)

Functional Flow: The fulfillment system sends data to Accounts Receivable (AR). 

The "Import AutoInvoice" scheduled process runs, converting the shipment data into a finalized customer invoice.

Key Technical Tables:

RA_INTERFACE_LINES_ALL (Staging table for AutoInvoice)

RA_CUSTOMER_TRX_ALL (Invoice Header)

RA_CUSTOMER_TRX_LINES_ALL (Invoice Lines)

AR_PAYMENT_SCHEDULES_ALL (Tracks what is due and when)

5. Receipt Creation and Application

Functional Flow: The customer pays the invoice. The payment (receipt) is entered into AR and applied against the open invoice, closing the customer's balance.

Key Technical Tables:

AR_CASH_RECEIPTS_ALL (Receipt header information)

AR_RECEIVABLE_APPLICATIONS_ALL (Links the receipt to the specific invoice)

6.Transfer to General Ledger (GL)

Functional Flow: The subledger accounting (SLA) entries generated from shipping (COGS), invoicing (Revenue/Receivables), and receipts (Cash/Receivables) are transferred and posted to the General Ledger.

Key Technical Tables:

XLA_AE_HEADERS & XLA_AE_LINES (Subledger Accounting entries)

GL_JE_HEADERS & GL_JE_LINES (Final General Ledger journal entries)