Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Understanding data flow for “Standard Order”

Posted on August 5th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post 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)
    dataflow

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

Posted in Oracle Order Management | 24 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
24 Responses
  1. Nikhilesh Says:

    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’
    )

  2. vishalaksha vyas Says:

    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.

  3. Charlie Gregg Programmer Analyst Senior Says:

    Great flow chart.

  4. Tapash Ray Says:

    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.

  5. Manish Gupta Says:

    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

  6. Sanjit Anand Says:

    I donot think there is any such document avaiable,you can check the irep for details.

  7. Satya Pal Says:

    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….

  8. Sanjit Anand Says:

    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.

  9. Arun Says:

    Hi,
    Could anyone help me how to create pick release doc

  10. Hi Satya Pal Says:

    Hi Actually the data will be populated in “MTL_reservations” after booking the order only .

    Thanks
    Mohan.

  11. Andi Permadi Says:

    Is there anyway, to cancel ship confirm and return the order line to picked status? (with API or using form)

    Best regards,

    Andi Permadi

  12. sandra Says:

    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

  13. Bhaskar Says:

    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

  14. Balram Says:

    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.

  15. ananda Says:

    hi
    when u do release sales order
    why there is execute now and concurrent? whats the difference?
    thanks
    ananda

  16. reddy Says:

    Hai Sangith,

    U have done very good job, It is very fine, but i need to verify this thing.

    Thanks a lot

    Reddy

  17. jayne Says:

    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

  18. Aamer Says:

    Its Good Article

  19. Sunil sharma Says:

    Good One Article

  20. Sunil sharma Says:

    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

  21. murali Says:

    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

  22. swathi Says:

    sir,i need alll the details about interfacing of OM-SPTS. Could you pls mail me.

  23. Devendra Gulve Says:

    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

  24. Vivek Says:

    Nice, comprehensive and concise article!

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.