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 “Internal Orders”

Posted on August 6th, 2007 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

The process flow for Internal OrdersInternalOrderFlow

Internal orders normally start with creation of requisitions in Oracle Purchasing (which is created as Internal Sales Orders) .

Once the requisitions created from the MRP and Inventory modules, the Requisition Import program must be run in order to move records from the requisition interface tables to the historical PO_REQUISITION_HEADERS_ALL, PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL.

Now next is to create internal requisitions from Purchasing module.When each requisition is approved, data will be inserted into the MTL_SUPPLY table. When the items on the requisition are stocked in inventory, the supply data can be viewed from the inventory form called Item Supply/Demand.

Once the Internal Requisition is approved, a user should run Create Internal Sales Orders (from a Purchasing responsibility) to load the internal sales orders interface tables called in Order Entry.

After the Creation of Internal Sales Orders has completed, a Import Orders concurrent program need to run from an Order Management.

at this stage, Oracle order Workflow will process the internal sales order using the workflow definition listed for the Transaction Type definition in Order Management. When the workflow completes the Shipping Network is checked to see if the Transfer Type between the source and destination organization is In transit or Direct.

You can use Oracle Order Entry/Shipping to define order cycles, approvals and holds.

Internal Requisitions use the Account Generator, which automatically builds account distributions. You can specify only one accounting distribution per inventory sourced line.

This internal requisition process provides the features needed to define your inter- organization shipping network. For transfers between two organizations, you can specify whether to use in transit or direct shipments. You can also require internal requisitions for transfers between specific organization.

The Data Flow for Internal orders


Related Posts

Posted in Oracle Order Management | 6 Comments »Email This Post Email This Post |

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

    Dear Mr Anand,

    I beleive, invoice will be generate. If invoice is not going to generate, we can achive this process through inter org transfer.

    Can you please justify your comments/ Please provide source document.


  2. Ajay agrawal Says:

    it is great help us to understand the flow and respective table.
    Thanks lot

  3. Mihir Says:


  4. Datha Says:

    Very nice info…Thanks…

  5. Srinivas Pasupuleti Says:

    Hi Guys..this is FYI.
    Order Management does not process internal sales order lines for the Receivables Interface, even if the Receivables Interface is an action in the order cycle for the internal sales order.

    Inter Org transfer happens between the orgs where no Shipping involved

  6. Srinivas Pasupuleti Says:

    Order Management requires both a ship–to and an invoice–to for each order, even though internal order lines are not invoiced. When you define a customer, either make the ship–to address both a ship–to and bill–to business purpose and set the Primary flag to Yes on the business purpose, or assign the ship–to to a bill–to location.

Leave a Comment

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