O2C FLOW IN ORACLE APPS R12 BACKEND PROCESS

DATA FLOW Diagram - Order to Cash

 YouTube Videos


https://www.youtube.com/channel/UCWFJCCCLUY0sgLrBsJQtjiw?view_as=subscriber

ORDER 2 CASH

CREATE ITEM IN MASTER ORG-V1

select * from  MTL_SYSTEM_ITEMS_B where  SEGMENT1='CDMO2C'

-- INVENTORY_ITEM_ID=244205

select * from  MTL_ONHAND_QUANTITIES_DETAIL where  INVENTORY_ITEM_ID=244205

select * from  MTL_MATERIAL_TRANSACTIONS where  INVENTORY_ITEM_ID=244205

CREATE THE ORDER

----------------

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_HEADERS_ALL A where  ORDER_NUMBER='69341'

--STATUS ENTERED

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_LINES_ALL A where  HEADER_ID=362781

-- STATUS ENTERED

--BOOKED THE ORDER

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_HEADERS_ALL A where  ORDER_NUMBER='69341'

--STATUS BOOKED

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_LINES_ALL A where  HEADER_ID=362781

-- STATUS AWAITING_SHIPPING

select A.RELEASED_STATUS,A.* from  WSH_DELIVERY_DETAILS A   where  SOURCE_HEADER_ID=362781

-- R --> Ready to Release

select * from  WSH_DELIVERY_ASSIGNMENTS where  DELIVERY_DETAIL_ID=6219051 -- UNTIL RELEASE THE ITEM, DELIVERY ID IS NOT POPULATED

-- RELEASE THE ORDER

------------------------

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_HEADERS_ALL A where  ORDER_NUMBER='69341'

--STATUS ENTERED

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_LINES_ALL A where  HEADER_ID=362781

-- STATUS ENTERED

select A.RELEASED_STATUS,A.* from  WSH_DELIVERY_DETAILS A   where  SOURCE_HEADER_ID=362781

-- Y --> Pick Confirmed

-- S --> Pick released

Staged/Pick Confirmed

select * from  WSH_DELIVERY_ASSIGNMENTS where  DELIVERY_DETAIL_ID=6219051 -- DELIVERY ID IS  POPULATED

select * from  wsh_new_deliveries where  delivery_id=6242831

--status OP OPEN

--Ship Confirm/Close Trip Stop

--MOVE ORDER

6391343

select * from  mtl_reservations where  INVENTORY_ITEM_ID=244205

select * from  mtl_txn_request_headers where  request_number='6391343'

select * from  mtl_txn_request_lines where  header_id=6391344

select * from  MTL_MATERIAL_TRANSACTIONS where  INVENTORY_ITEM_ID=244205

---

SHIP CONFIRMATION

----------------

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_HEADERS_ALL A where  ORDER_NUMBER='69341'

--STATUS ENTERED

select A.FLOW_STATUS_CODE,A.* from  OE_ORDER_LINES_ALL A where  HEADER_ID=362781

-- STATUS SHIPPED

select A.RELEASED_STATUS,A.* from  WSH_DELIVERY_DETAILS A   where  SOURCE_HEADER_ID=362781

-- C --> Shihp Confirmed

select * from  WSH_DELIVERY_ASSIGNMENTS where  DELIVERY_DETAIL_ID=6219051 -- DELIVERY ID IS  POPULATED

select * from  wsh_new_deliveries where  delivery_id=6242831

--status CL CLOSED

select * from  mtl_reservations where  INVENTORY_ITEM_ID=244205-- DELTED ONCE SHIP CONFIRMED

select * from  mtl_txn_request_headers where  request_number='6391343'

select * from  mtl_txn_request_lines where  header_id=6391344

select * from  MTL_MATERIAL_TRANSACTIONS where  INVENTORY_ITEM_ID=244205

-- DECREASED THE ONHAND QUANTITIES

select * from  MTL_ONHAND_QUANTITIES where  INVENTORY_ITEM_ID=244205

---- CREATE AR INVOICE

 RUN WORKFLOW BACKGROUND PROCESS FROM OM RESP

 -- INTERFACE THE INV RECORDS

 -- AUTOMATICALLY CALL AUTOINVOICE PROGRAM

-- AR INVOICE IS IMPORTED IN EBS

select * from  RA_INTERFACE_LINES_ALL where  INTERFACE_LINE_ATTRIBUTE1='69341'

select * from  RA_INTERFACE_SALESCREDITS_ALL where  INTERFACE_LINE_ID=1952381

select * from  RA_INTERFACE_DISTRIBUTIONS_ALL where  INTERFACE_LINE_ID=1952381

select * from  RA_INTERFACE_ERRORS_ALL

select * from  RA_CUSTOMER_TRX_ALL where  CUSTOMER_TRX_ID=1205195

--TRX NUMBER 10047340

select * from  RA_CUSTOMER_TRX_LINES_ALL where  INTERFACE_LINE_ATTRIBUTE1='69341'

select * from  RA_CUST_TRX_LINE_GL_DIST_ALL  where  CUSTOMER_TRX_LINE_ID=1952381

select * from  RA_CUST_TRX_LINE_SALESREPS_ALL where  SALESREP_ID=1006 AND CUSTOMER_TRX_ID=1205195

select * from  JTF_RS_SALESREPS where  SALESREP_ID=1006

select * from  AR_PAYMENT_SCHEDULES_ALL where  CUSTOMER_TRX_ID=1205195

-- AMOUNT_DUE_REMAINIG 795.01

SLA TABLES

----------

select * from  XLA_EVENTS where  EVENT_ID=6198573

select * from  XLA.XLA_TRANSACTION_ENTITIES where  TRANSACTION_NUMBER='10047340'

-- CREATE ACOUNTNG PROGRAM

select * from  XLA_AE_HEADERS where  EVENT_ID=6198573

select * from  XLA_AE_LINES where  AE_HEADER_ID=8110572

select * from  GL_IMPORT_REFERENCES where  (GL_SL_LINK_ID,GL_SL_LINK_TABLE) IN (

select GL_SL_LINK_ID,GL_SL_LINK_TABLE from  XLA_AE_LINES where  AE_HEADER_ID=8110572)

GL TABLES

select * from  GL_INTERFACE where  REFERENCE26=6198573

select * from  GL_JE_BATCHES where  je_batch_id=5351742

-- Receivables A 3825428 7481722

select * from  GL_JE_HEADERS where  je_header_id=7105885

select * from  GL_JE_LINES where  je_header_id=7105885

----

CREATE RECEIPTS

select * from  AR_CASH_RECEIPTS_ALL where  RECEIPT_NUMBER='10047340_REC'

select * from  AR_PAYMENT_SCHEDULES_ALL where  CUSTOMER_TRX_ID=1205195

-- AMOUNT_DUE_REMAINIG 795.01

select * from  AR_RECEIVABLE_APPLICATIONS_ALL where  CASH_RECEIPT_ID=211297

select * from  AR_CASH_RECEIPT_HISTORY_ALL where  CASH_RECEIPT_ID=211297

---

select * from  XLA_EVENTS where  EVENT_ID=6198574

select * from  XLA.XLA_TRANSACTION_ENTITIES where  TRANSACTION_NUMBER='10047340_REC'

-- CREATE ACOUNTNG PROGRAM

select * from  XLA_AE_HEADERS where  EVENT_ID=6198574

select * from  XLA_AE_LINES where  AE_HEADER_ID=8110573

select * from  GL_IMPORT_REFERENCES where  (GL_SL_LINK_ID,GL_SL_LINK_TABLE) IN (

select GL_SL_LINK_ID,GL_SL_LINK_TABLE from  XLA_AE_LINES where  AE_HEADER_ID=8110573)

GL TABLES

select * from  GL_INTERFACE where  REFERENCE26=6198574

select * from  GL_JE_BATCHES where  je_batch_id=5351744

-- Receivables A 3825429 7481727

select * from  GL_JE_HEADERS where  je_header_id=7105887

select * from  GL_JE_LINES where  je_header_id=7105887

-----------------------

SETUP DETAILS

select * from  RA_CUSTOMER_TRX_ALL where  CUSTOMER_TRX_ID=1205195

--TRX NUMBER 10047340

select * from  RA_CUSTOMER_TRX_LINES_ALL where  INTERFACE_LINE_ATTRIBUTE1='69341'

select * from  RA_BATCH_SOURCES_ALL where  BATCH_SOURCE_ID=1001

select * from  RA_CUST_TRX_TYPES_ALL where  CUST_TRX_TYPE_ID=1361

select * from  RA_TERMS where  TERM_ID=4

select * from  RA_GROUPING_RULES