Have you checked our new Android App!!! Please download and learn oracle at ease

September 7, 2014

Oracle Order Management: Drop Ship Flow

bishnupc / / 2

Setting up the Item first

Master Level:
Inventory Item, Stockable, Transactable
Purchased, Purchasable, List Price

Order Management:
Customer Ordered, Customer Order Enabled, Shippable, OE Transactable
Default SO Source Type should be External
Internal Ordered, Internal Order Enabled (These 2 if the drop ship will happen from internal organization)


Organization Level Setup:



Now create the Sales Order

Make sure source type is External
Now Book the order

Now the line is in Booked

Workflow is deferred for Purchase Release
Run the workflow Background
After the program completes, re query the SO

Now the time, you can see the record both in Drop Ship table and Po Req Interface table
select * from apps.oe_order_headers_all where order_number = '66411';
select * from apps.OE_DROP_SHIP_SOURCES where header_id = 190500;
select * from apps.po_requisitions_interface_all where creation_date >= sysdate-1/24;
Now run the Requisition Import Program

If this program not able to create the requisition, then please check the error if any in below table
select * from apps. PO_INTERFACE_ERRORS where transaction_id = <transaction_id from po_requisition_interface_all table>
Once the program, completes, lets check the Req details in Sales order line, additional Information , Drop Ship tab

PO Creation

Now take this Requisition and Auto Create PO from this using the Purchasing responsibility

Click Automatic

Select the supplier and Site and click Create
This will create the PO

Now check the details and Submit for Approval

Wait till you get the confirmation from supplier for the shipments either by ASN or any EDI communication.
Now you can see this PO details in SO Line, Drop Ship tab

PO Receiving

Once confirmed, then go ahead and do the receipt

Once received, check the transaction completion.
Once the receiving transaction completed, go and check the SO line status

Now run the workflow background program, this will close the line

This will interface the record to Receivable
Now run the Autoinvoice Master program to create the Receivable Invoice


  1. Earn from Ur Website or Blog thr PayOffers.in!


    Nice to e-meet you. A very warm greetings from PayOffers Publisher Team.

    I am Sanaya Publisher Development Manager @ PayOffers Publisher Team.

    I would like to introduce you and invite you to our platform, PayOffers.in which is one of the fastest growing Indian Publisher Network.

    If you're looking for an excellent way to convert your Website / Blog visitors into revenue-generating customers, join the PayOffers.in Publisher Network today!

    Why to join in PayOffers.in Indian Publisher Network?

    * Highest payout Indian Lead, Sale, CPA, CPS, CPI Offers.
    * Only Publisher Network pays Weekly to Publishers.
    * Weekly payments trough Direct Bank Deposit,Paypal.com & Checks.
    * Referral payouts.
    * Best chance to make extra money from your website.

    Join PayOffers.in and earn extra money from your Website / Blog


    If you have any questions in your mind please let us know and you can connect us on the mentioned email ID info@payoffers.in

    I’m looking forward to helping you generate record-breaking profits!

    Thanks for your time, hope to hear from you soon,
    The team at PayOffers.in


Copyright © . Oracle Apps (SCM) . All Rights Reserved
Oracle Apps (SCM) is an online knowledge sharing blog which index online free tutorials, blogs and other sources, to get easier and accessible manner. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. All trademarks, trade names, service marks, copyrighted work, logos referenced herein belong to their respective owners/companies. If any of the posting is violating copyright and you want us to remove that content. Please contact Here