Integrations

Below are the some of integrations in oracle application's modules.

Order To Customer Integration:

     OE_ORDER_HEADERS_ALL OOH
     OE_ORDER_LINES_ALL OOL   
     HZ_CUST_ACCOUNTS_ALL HCAA
     HZ_CUST_SITE_USES_ALL HCSUA
OOH.SOLD_TO_ORG_ID                  = HCAA.CUST_ACCOUNT
OOH.SHIP_TO_ORG_ID                    = HCSUA.SITE_USE_ID
 AND HCSUA.SITE_USE_CODE      = 'SHIP_TO'
OOH.INVOICE_TO_ORG_ID            = HCSUA.SITE_USE_ID
 AND HCSUA.SITE_USE_CODE      = 'BILL_TO'

Order To Inventory Reservations:

     OE_ORDER_HEADERS_ALL OOH
     OE_ORDER_LINES_ALL OOL
     MTL_RESERVATIONS MR
     MTL_DEMAND MD

OOH.HEADER_ID        = MR.DEMAND_SOURCE_HEADER_ID
OOL.LINE_ID               = MR.DEMAND_SOURCE_LINE_ID
OOH.HEADER_ID       = MD.DEMAND_SOURCE_HEADER_ID

Order to Shipping Execution Integration:

OE_ORDER_HEADERS_ALL OOH
OE_ORDER_LINES_ALL OOL
WSH_DELIVERY_DETAILS WDD
WSH_DELIVERY_ASSIGNMENTS WDA
WSH_NEW_DELIVERIES  WND

OOH.HEADER_ID                       = WDD.SOURCE_HEADER_ID
OOL.LINE_ID                              = WDD.SOURCE_LINE_ID
WDD.DELIVERY_DETAIL_ID  = WDA.DELIVERY_DETAIL_ID
WDA.DELIVERY_ID                 = WND.DELIVERY_ID

Note: WDA.DELIVERY_ID will be not null after pick release till before ship confirm.

Order to Move Order Integration:

OE_ORDER_HEADERS_ALL OOH
OE_ORDER_LINES_ALL OOL
MTL_TXN_REQUEST_HEADERS MTRH
MTL_TXN_REQUEST_LINES MTRL

OOH.HEADER_ID = MTRL.TXN_SOURCE_ID
OOL.LINE_ID        = MTRLTXN_SOURCE_LINE_ID

Order to Material Transactions Integration

OE_ORDER_HEADERS_ALL OOH
OE_ORDER_LINES_ALL OOL
MTL_MATERIAL_TRANSACTIONS MMT

OOL.LINE_ID = MMT.TRX_SOURCE_LINE_ID

AR Transaction,SLA and GL Integration:

AP Invoices, SLA and GL Integration:

PO,Receiving, and AP Integration:

AP Invoices to CE
AP_INVOICES_ALL AIA
AP_INVOICE_LINES_ALL AILA
AP_INVOICE_DISTRIBUTIONS_ALL AIDA
AP_INVOICE_PAYMENTS_ALL AIPA
AP_CHECKS_ALL ACL
CE_BANK_ACCOUNTS CBA

AIA.INVOICE_ID = AILA.INVOICE_ID
AIA.INVOICE_ID = AIDA.INVOICE_ID
AIA.INVLICE_ID = AIPA.INVOICE_ID
AIPA.CHECK_ID = ACL.CHECK_ID
AIDA.DIST_CODE_COMBINATION_ID = CBA.ASSET_CODE_COMBINATION_ID

AP Payments TO CE
AP_INVOICES_ALL AIA
AP_INVOICE_PAYMENTS_ALL AIPA
AP_CHECKS_ALL ACA
CE_BANK_ACCOUNTS CBA
CE_BANK_ACCT_USES_ALL CBAUA

AIA.INVOICE_ID = AIPA.INVOICE_ID
AIPA.CHECK_ID = ACA.CHECK_ID
ACA.CE_BANK_ACCT_USE_ID = CBAUA.BANK_ACCT_USE_ID
CBAUA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID

AR Cash Receipts to CE Integration:
AR_CASH_RECEIPTS_ALL ACRA
CE_BANK_ACCOUNTS CBC
CE_BANK_ACCT_USES_ALL CBAUA

ACRA.REMIT_BANK_ACCT_USE_ID = CBAUA.BANK_ACCT_USE_ID
CBAUA.BANK_ACCOUNT_ID = CBC.BANK_ACCOUT_ID

CE to GL Integration:
CE_BANK_ACCOUNTS CBA
CE_BANK_ACCT_USES_ALL CBAUA
GL_JE_LINES GJL

CBA.BANK_ACCOUNT_ID                        = CBAUA.BANK_ACCOUNT_ID
CBA.ASSET_CODE_COMBINATION_ID = GJL.CODE_COMBINATION_ID

AR Invoices to Customer Balances
AR_CUSTOMER_TRX_ALL                     CT
AR_CUST_TRX_LINE_GL_DIST_ALL   CTD
AR_PAYMENT_SCHEDULES_ALL        PS ( AMOUNT_DUE_REMAINING)

CT.CUSTOMER_TRX_ID   = CTD.CUSTOMER_TRX_ID
CT.CUSTOMER_TRX_ID  = PS.CUSTOMER_TRX_ID