Order to Cash O2C

 

 

Last week, got a mail from one of reader who requested for providing data flow of standard orders and Return Orders. So,here are the information for data flow. Normally standard sales order can be split into nine sub steps , which jointly carried out by some module like INV,OM, Pricing, Shipping and AR. Lets take each sub steps with data flow conditions. These are based out of the flow which is available in 11.5.10.2.

1. Order Entry

This is first stage when Order in enter in system.When the order is entered it basically create a record in order headers and Order Lines table.

·         oe_order_headers_all (Here the flow_status_code as entered)

·         oe_order_lines_all (flow_status_code as entered) ( order number is generated)

2.Order Booking

This is next stage , when Order which is entered in step 1 is booked and Flow status changed from Entered toBooked.At this stage , these table get affected.

·         oe_order_headers_all (flow_status_code asbooked ,booked_flag updated)

·         oe_order_lines_all (flow_status_code as awaiting shipping, booked_flag updated)

·         wsh_new_deliveries (status_code OP open)

·         wsh_delivery_details (released_status “R” ready to release)

Same time, Demand interface program runs in background And insert into inventory tables mtl_demand

3. Reservation

This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved.Once this program get successfully get completed , the mtl_reservations table get updated.

4. Pick Release

Ideally pick release is the process which is defined in which the items on the sales order are taken out from inventory.

Normally pick release SRS program runs in background . Once the program get completed these are the table get affected:

·         oe_order_lines_all (flow_status_code “PICKED” )

·         wsh_delivery_details (released_status “S”, “submitted for release” )

·         mtl_txn_request_headers

·         mtl_txn_request_lines
(move order tables.Here request is generated to move item from saleble to staging sub inventory)

·         Mtl_material_transactions_temp (link to above tables through move_order_header_id/line_id

5.Pick Confirm

Items are transferred from saleble to staging Subinventory.

• mtl_material_transactions
• mtl_transaction_accounts
• wsh_delivery_details (released_status “Y”,”Released” )
• wsh_delivery_assignments

6.Ship Confirm

Here ship confirm interface program runs in background . Data removed from wsh_new_deliveries

·         oe_order_lines_all (flow_status_code “shipped”)

·         wsh_delivery_details (released_status “C” ,“Shipped”)

·         mtl_transaction_interface

·         mtl_material_transactions(linked through Transaction source header id)

·         mtl_transaction_accounts

·         Data deleted from mtl_demand,mtl_reservations

·         Item deducted from mtl_onhand_quantities

7.Enter Invoice

This is also called Receivables interface, that mean information moved to accounting area for invoicing details.

·         Invoicing workflow activity transfers shipped item information to Oracle Receivables.

·         ra_interface_lines_all (interface table into which the data is transferred from order management)T

·         Then Autoinvoice program imports data from this

·         Table which get affected into this stage are recievables base table.

o    ra_customer_trx_all (cust_trx_id is primary key to link it to trx_lines table and trx_number is the invoice number)

o    ra_customer_trx_lines_all (line_attribute_1 and line_attribute_6 are linked to header_id (or order number) and line_id of the orders)

8.Complete Line

In this stage order line leval table get updated with Flow status and open flag.

·         oe_order_lines_all (flow_status_code “shipped”, open_flag “N”)

9.Close Order

This is last step of Order Processing . In this stage only oe_order_lines_all table get updated.

These are the table get affected in this step.

·         oe_order_lines_all (flow_status_code “closed”,open_flag “N”)

These are the typically data flow of a order to cash model for a standard order.

Order To Cash Overview

Newbie, feel comfortable with this post. This is handy note for technical details for Order Management Tables.

When you create an Order with "Entered" status.

·         oe_order_headers_all 1 record created in header table

·         oe_order_lines_all Lines for particular records lines details is there

·         oe_price_adjustments When discount gets applied

·         oe_order_price_attribs If line has price attributes then populated

·         oe_order_holds_all If any hold applied for order like credit check etc.

Order Booking: This is next stage, when Order is booked then the Flow status changed from Entered to Booked.

·         oe_order_headers_all Booked_flag=Y Order booked.

·         wsh_delivery_details Released_status Ready to release

here is few things you will notice for this stage:

·         The FLOW_STATUS_CODE in the table OE_ORDER_HEADERS_ALL would be ‘BOOKED’

·         The FLOW_STATUS_CODE in OE_ORDER_LINES_ALL will be ‘AWAITING_SHIPPING’.

·         Record(s) will be created in the table WSH_DELIVERY_DETAILS with RELEASED_STATUS=’R’ (Ready to Release)

·         Also Record(s) will be inserted into WSH_DELIVERY_ASSIGNMENTS.

Pick Released :Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order

·         wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)

·         wsh_picking_batches After batch is created for pick release.

·         mtl_reservations This is only soft reservations. No physical movement of stock

Full Transaction

·         mtl_material_transactions No records in mtl_material_transactions

·         mtl_txn_request_headers

·         mtl_txn_request_lines

·         wsh_delivery_details Released to warehouse.

·         wsh_new_deliveries if Auto-Create is Yes then data populated.

·         wsh_delivery_assignments deliveries get assigned

Credit Chk Details

·         oe_credit_check_rules To get the Credit Check Againt Customer.

Cancel Orders details

·         oe_order_lines_all

Hold Relaese

·         oe_hold_releases_all Hold released Sales Order.

Pick Confirm/ Move Order Transaction: Here items are transferred from source sub-inventory to staging Sub-inventory.

·         wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock

Ship Confirm: Items are loaded in Truck/ Transportations Mode for the delivery to Customers

·         wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged

·         mtl_material_transactions On the ship confirm form, check Ship all box

·         wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped

·         oe_order_lines_all Shipped_quantity get populated.

·         wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.

·         oe_order_headers_all If all the lines get shipped then only flag N

Price Details

·         qp_list_headers_b To Get Item Price Details.

·         qp_list_lines

Items On Hand Qty

·         mtl_onhand_quantities TO check On Hand Qty Items.

Sales Credit Sales -Credit Information(How much credit can get)

·         oe_sales_credits

If you have any attachment , then these tables are used

·         fnd_attached_documents Attched Documents and Text information

·         fnd_documents_tl

·         fnd_documents_short_text

Blanket Sales Order

·         oe_blanket_headers_all Blanket Sales Order Information.

·         oe_blanket_lines_all

Autoinvoice

Invoice is generated in ERP once Autoinvoice has been run

·         wsh_delivery_details Released_status=I Need to run workflow background process.

·         ra_interface_lines_all Data will be populated after wkfw process.

·         ra_customer_trx_all After running Autoinvoice Master Program for

·         ra_customer_trx_lines_all specific batch transaction tables get populated

Payment Terms

·         ra_terms Payment terms

 Let took the flow part for O2C.

Here are assocaited tables and underline details. for more insight on O2C, refer to this post.

The Order To Cash cycle of any industry includes following steps:

·         Order Entry: This is first stage, When the order is entered in the system

·         Order Booking: This is next stage, when Order is booked then the Flow status changed from Entered to Booked.

·         Pick Release: Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order

·         Pick Confirm/ Move Order Transaction: Items are transferred from source sub-inventory to staging Sub-inventory.

·         Ship Confirm: Items are loaded in Truck/ Transportations Mode for the delivery to Customers

·         Invoice Generation: Invoice is generated

·         Close Order