Order Management Interview Questions in Oracle Fusion

Q1: What is the relationship between DOO_LINES_ALL and DOO_FULFILL_LINES_ALL

 in Oracle Fusion Order Management?

Answer:

DOO_LINES_ALL represents the order line definition (what customer ordered), while DOO_FULFILL_LINES_ALL represents the execution of that order line (how it is fulfilled). 

The key difference is that one order line can split into multiple fulfillment lines depending on shipping, backorders, or partial deliveries.

Q2: Could you outline the core database tables involved across the Order-to-Cash (O2C) cycle in Oracle Fusion (OM, Inventory, Shipping, and Receivables) and how they link together?

Answer:

Order-to-Cash (O2C) back-end tables are: 

OM

DOO_HEADERS_ALL

DOO_LINES_ALL

DOO_FULFILL_LINES_ALL

INV&WSH

WSH_DELIVERY_DETAILS

WSH_NEW_DELIVERIES

WSH_DELIVERY_ASSIGNMENTS

INV_MATERIAL_TXNS

AR Invoice 

RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_LINES_ALL

RA_CUST_TRX_LINE_GL_DIST_ALL

Cash Application & Receipts (AR)

AR_CASH_RECEIPTS_ALL

AR_CUSH_RECEIPT_HISTORY_ALL

AR_RECEIVABLE_APPLICATIONS_ALL

Sub-Ledger Accounting

XLA

XLA_TRANSACTION_ENTITIES

XLA_EVENTS

XLA_AE_HEADERS

XLA_AE_LINES

XLA_DISTRIBUTION_LINKS

General Ledger

GL 

GL_JE_BATCHES

GL_JE_HEADERS

GL_JE_LINES

GL_CODE_COMBINATIONS

GL_BALANCES