Posted on August 5th, 2007 by Sanjit Anand || Email This Post
Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today |
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 to Booked.At this stage , these table get affected.
-
oe_order_headers_all (flow_status_code as booked ,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.
-
ra_customer_trx_all (cust_trx_id is primary key to link it to trx_lines table and trx_number is the invoice number)
-
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.
Related Posts
October 26th, 2007 at 2:26 pm
Hi
I have come across few more flow status code . May be this is due to the cusomization. Would u be able to explain
‘AWAITING_SHIPPING’,
‘PO_CREATED’,
‘BOM_AND_RTG_CREATED’,
‘PO_REQ_CREATED’,
‘AWAITING_FULFILLMENT’,
‘PO_REQ_REQUESTED’,
‘AWAITING_RETURN’
)
November 21st, 2007 at 5:51 am
When I click on Book Order button in order entry screen (In Order management super user responsibility) then following message appears.
“Order is not eligible for booking. Check workflow status for this order.â€
Can you provide me the reason for this.
November 30th, 2007 at 12:17 pm
Great flow chart.
January 10th, 2008 at 4:04 pm
Very good effort, but the last step is for closing the order line, not the header.
Order Header closing is a different cycle altogether, it would be amazing if this article could be appended with that flow as well.
March 6th, 2008 at 7:48 am
hi Sanjit,
Can you please guide me on from where I can get the high-level OM Flow starting from Siebel (covering different status) to moving into TIBCO to creating Order in Oracle till order closure.
Appreciate your help.. :)
Thanks
March 6th, 2008 at 9:53 pm
I donot think there is any such document avaiable,you can check the irep for details.
April 22nd, 2008 at 2:24 pm
I have got good idea for starting, but I did step by step all the above process. there is lot of mistake in this document. (1)U said after order is ‘booked’, it will create data in mtl_reservation,mtl_demand….not true…after pick release only…please check lot of other mistake….this makes lot of errors for a person who doesn’t apply in work…..(2) Data removed from wsh_new_deliveries – not true….
April 27th, 2008 at 11:33 pm
satya,
I am not sure, about your set up, as we learn there are number of setup we need to perform.
More over , If you provide the setup details and some profile options under which you have mention the steps is bit diverted which I documented.I can possibly explain what setup driving at which leval.
More over , these steps are based out of standard setup at client side, which is clubbed by some profile options.
April 29th, 2008 at 7:04 am
Hi,
Could anyone help me how to create pick release doc
May 28th, 2008 at 4:39 am
Hi Actually the data will be populated in “MTL_reservations” after booking the order only .
Thanks
Mohan.
June 3rd, 2008 at 6:24 pm
Is there anyway, to cancel ship confirm and return the order line to picked status? (with API or using form)
Best regards,
Andi Permadi
June 25th, 2008 at 12:02 am
Hi
It was really interesting article but iam stuck with many questions
1)Can u tell me before runnning auto invoice import program to transfer data to base tables from interface tables how data is appearing in interface table like we do ship confirm then are we running any concurrent program to import shipping info to interface tables in ar
July 25th, 2008 at 5:25 am
Can any one pls tell me what are the APIs to be used for Allocating and Transacting Move Orders.
After we Pick release the move order no# and lines get generated. But how to Allocate the Move order thru APIs.
Appriciate your quick response
October 15th, 2008 at 12:22 pm
Can someone pls explain to how can I generate an invoice from a sales order? What steps are involved?
I’m pretty good at the functional part of Order Management but not that good at AR.
October 20th, 2008 at 8:02 pm
hi
when u do release sales order
why there is execute now and concurrent? whats the difference?
thanks
ananda
December 9th, 2008 at 12:00 pm
Hai Sangith,
U have done very good job, It is very fine, but i need to verify this thing.
Thanks a lot
Reddy
March 24th, 2009 at 8:54 am
we have several orders were we need the OM header status changed from closed back to billed or cancelled… does anyone know if there is a data fix that will fix the issue.
We have applied holds on the workflow for future orders however we need to have all orders in booked / cancelled
March 30th, 2009 at 7:03 am
Its Good Article
August 17th, 2010 at 10:47 pm
Good One Article
August 17th, 2010 at 10:49 pm
Hi,
Any one tell me,
Flow Status code is INVOICE_HOLD in Oe_Order_lines_all table
and oe_order_lines-all flow_status code is Booked
August 24th, 2010 at 4:14 am
Hi,
I am working on OM. i need the query to get status Picked and Picked Partial. In the table oe_order_lines_all ,flow_status_code these are not there. And in front end we have status Picked and when i query from backend i m unable to see the Picked status.
Will u please send me the query to get the orders which are in the status of Picked and Picked Partial.
thanks & regards
Murali
October 9th, 2010 at 3:37 am
sir,i need alll the details about interfacing of OM-SPTS. Could you pls mail me.
December 9th, 2011 at 12:27 am
Hi,
This is an answer for the 1st comment by Nikhilesh.
All the status u mentioned r standard…
1. ‘AWAITING_SHIPPING’—– When order line is waiting to be shipped.
2. ‘PO_CREATED’———— this is used in case of “Back to back” or “Drop Ship” order, when PO is created in Purchasing
3. ‘BOM_AND_RTG_CREATED’— Not sure about this status
4. ‘PO_REQ_CREATED’——– this is used in case of “Back to back” or “Drop Ship” order, when requestion is created in Purchasing
5. ‘AWAITING_FULFILLMENT’– when order line has same fulfillment set as line which is not yet shipped.
6. ‘PO_REQ_REQUESTED’ —– this is used in case of “Back to back” or “Drop Ship” order, when requisition is waiting to be imported in Purchasing
7. ‘AWAITING_RETURN’ —— When RMS line is waiting for receiving
You may want to visit below links for more clarification.
http://functionalguy.blogspot.com/2009/02/back-to-back-order-cycle.html
http://functionalguy.blogspot.com/2008/10/drop-ship-order-flow.html
Hope this will help understanding…
Devendra Gulve
May 28th, 2012 at 2:55 am
Nice, comprehensive and concise article!