Oracle E Business Suite Dataflow for Order to Cash

These are the following Data-flow for Order to Cash Cycle:

  1. This is the first stage when the order is entered in the system ,it creates order header and order header lines

Enter Header Details: OE_ORDERS_HEADERS_ALL_FLOW_STATUS_CODE=ENTERED BOOKED_FLAG=N

               Enter Line Details for the Order: Order Header_ID , OE_ORDER_LINES_ALL(FLOW_ STATUS_CODE=ENTERED,BOOKED_FLAG=N,OPEN_FLAG=Y) PRIMARY KEY= LINE ID

 

  1. Order Booking:

This is next stage, when Order then the flow status is changed from Entered to Booked. At this stage these below table will get effected.

  • OE_ORDERS_ALL (FLOW_ STATUS_ CODE as BOOKED, BOOKED_FLAG UPDATED TO Y)
  • OE_ORDERS_LINES_ALL(FLOW_STATUS_CODE as AWAITING_ SHIPPING,BOOKED_FLAG UPDATED Y
  • WSH_DELIVERY_DETAILS (DELIVERY_DETAILS_ID is ASSIGNED HERE,RELEASED_STATUS ‘R’ ready to release ,LINE_ID Comes as Source_ Line_ ID
  • WSH_DELIVERY_ASSIGNMENTS (DELIVERY_ASSIGNMENT_ID is Assigned For DELIVERY_DETAIL_ID PRESENT IN WSH_DELIVERY_DETAILS, DELIVERY_ID.

 

  1. Reservation: This step is required for doing reservations SCHDEULE ORDER PROGRAM Which runs in the background and quantities are reserved.

MTL_DEMAND and MTL_RESERVATIONS tables get updated

  1. Pick Release: It is the process of putting on hand reservations for on hand quantity available in the inventory and pick them for particular sales order.

WSH_NEW_DELIVERIES (One Record gets inserted with SOURCE_HEADER_ID= Order Header ID,

  1. Pick Confirm: Items are transferred from source sub-inventory to staging sub-inventory.

MTL_MATERIAL_TRANSACTION_TEMP This step can be eliminated at the time if we set pick confirm=YES at the time of pick release.

 

  1. Ship Confirm: Here Ship Confirm Program is runs in the background. The items gets shipped to the customer at this stage.
  • OE_ORDERS_LINES_ALL(FLOW_STATUS_CODE “SHIPPED”
  1. ENTER INVOICE: After the shipping lines get eligible to get transferred to RA_INTERFACE_LINES_ALL Workflow background process picks those records and post it to RA_INTERFACE_LINE_ALL.
  2. COMPLETE LINE: In this stage order line level table get updated with flow status and open flag.

OE_ORDERS_LINE_ALL (FLOW_STATUS_CODE ‘SHIPPED’, OPEN_FLAG_”N”)

9     CLOSE ORDER: This is the last step of Order Processing:

In this stage OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘CLOSED’, OPEN FLAG “N”)

These are the tables that get effected in this step.

OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘CLOSED’ OPEN_FLAG “N”)

OE_ORDER_HEADERS_ALL

 

 

If you have questions, please ask below

Leave a Reply

If you have any questions headover to our forums

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <blockquote cite=""> <code> <em> <strong>