Key Oracle Tables in O2C (Order-to-Cash) Flow
Step Table Name Description Primary Key Important
Columns / Joins
1. Sales Order OE_ORDER_HE Sales order HEADER_ID Join to
Entry ADERS_ALL header OE_ORDER_LIN
ES_ALL.HEADE
R_ID
OE_ORDER_LIN Sales order LINE_ID HEADER_ID,
ES_ALL lines INVENTORY_IT
EM_ID,
FLOW_STATUS_
CODE
2. Customer HZ_PARTIES Party master PARTY_ID Join to
Info HZ_CUST_ACCO
UNTS_ALL.PAR
TY_ID
HZ_CUST_ACCO Customer CUST_ACCOUN Join to
UNTS_ALL account T_ID OE_ORDER_HE
ADERS_ALL.SO
LD_TO_ORG_ID
HZ_CUST_SITE_ Site uses (ship- SITE_USE_ID Join to
USES_ALL to, bill-to) OE_ORDER_HE
ADERS_ALL.SHI
P_TO_ORG_ID /
BILL_TO_ORG_I
D
3. Inventory MTL_RESERVA Reservation of RESERVATION_ INVENTORY_IT
Reservation TIONS item ID EM_ID,
DEMAND_SOUR
CE_LINE_ID →
OE_ORDER_LIN
ES_ALL.LINE_ID
4. Pick WSH_DELIVER Shipping line DELIVERY_DET SOURCE_LINE_I
Release / Y_DETAILS details AIL_ID D=
Shipping OE_ORDER_LIN
ES_ALL.LINE_ID
WSH_NEW_DEL Delivery header DELIVERY_ID Join via
IVERIES WSH_DELIVER
Y_ASSIGNMENT
S.DELIVERY_ID
WSH_DELIVER Line–delivery DELIVERY_ASSI Links
Y_ASSIGNMENT link GNMENT_ID WSH_DELIVER
S Y_DETAILS ↔
WSH_NEW_DEL
IVERIES
5. Interface to RA_INTERFACE Interface table INTERFACE_LI INTERFACE_LI
AR _LINES_ALL for AR NE_ID NE_ATTRIBUTE
(AutoInvoice) 1=
OE_ORDER_HE
ADERS_ALL.OR
DER_NUMBER
RA_INTERFACE Interface INTERFACE_DI Joins to
_DISTRIBUTIO accounting STRIBUTION_I RA_INTERFACE
NS_ALL D _LINES_ALL.INT
ERFACE_LINE_I
D
6. AR Invoice RA_CUSTOMER AR transaction CUSTOMER_TR TRX_NUMBER,
_TRX_ALL header X_ID BILL_TO_CUST
OMER_ID
RA_CUSTOMER AR transaction CUSTOMER_TR CUSTOMER_TR
_TRX_LINES_AL lines X_LINE_ID X_ID,
L INTERFACE_LI
NE_ATTRIBUTE
1
7. Receipts AR_CASH_RECE Receipt header CASH_RECEIPT RECEIPT_NUM
IPTS_ALL _ID BER,
PAY_FROM_CUS
TOMER
AR_RECEIVABL Application of RECEIVABLE_A CASH_RECEIPT
E_APPLICATIO receipts PPLICATION_ID _ID,
NS_ALL CUSTOMER_TR
X_ID
8. Accounting GL_JE_HEADER Journal header JE_HEADER_ID JE_BATCH_ID
(GL) S
GL_JE_LINES Journal lines JE_LINE_NUM JE_HEADER_ID
GL_IMPORT_RE Source GL_SL_LINK_ID Links Subledger
FERENCES references to GL