Oracle Drop Ship Flow for R12

In this blog I will explain Oracle Drop Ship Flow for R12.

What is Drop-ship Order - In drop-ship Order, sales order line creates a requisition line that becomes a PO and sent to your supplier. You instruct your supplier to send the item or configured item directly to your customer only and items never physically pass through your warehouse, and therefore you do not pick, pack or ship them yourselves

In this blog I will explain the R12 Data flow of Drop-ship order from OM to Oracle Payable.
Topics covered in this blog are
Drop Ship Sales order creation and booking.
Requisition Import
Auto Creation of PO
Receipt against PO
AP against PO

In a header level

Order type = ‘Auto Mixed’

Since in Drop-ship we don’t receive the goods in our warehouse, SOURCE_TYPE will be “External”, where as for non-drop-ship orders it is Internal. Once Book, we cannot Changes SOURCE_TYPE.

We can change the SOURCE_TYPE as “External” for an item at the time of order creation, or we can define it permanently in the Item creation Setup, by setting Default SO Source Type = External.

Also as we don’t have any shipping activity in drop-ship orders, Receiving Transaction Processor (RTP) , triggered after Submitting the receipt will push the workflow from Shipping activity to Fulfillment.
R12 Data flow of Drop-ship order from OM to Oracle Payable.
Step1 - Drop ship Sales Order Creation
Step2 - Source Type = External

 

 

Step3 -Once order is Book, order line workflow will be at Purchase release Deferred Status .

 

 Step4 -Submit Workflow to progress the Order line workflow.

 

 Step5 -Submit the requisition Import to create Requisition for Drop Ship

 

Step6 -Once requisition Import Completed successfully , Navigate to Order lines Action >Additional Information and then go to Drop-Ship tab.

 Step7 - Switch to Purchasing Responsibility and Navigate to Requisition Summary



Step8 -Query for Requisition Number

Step9 – Open the Auto Create Window and Query for Requisition #

 

Step10 – Click on Automatic or Manual

Step11 -Approve the PO




Step12 - Navigate to receipts.



Step13 - Enter Receipt against PO.

Step14 - Once you save the Receipt , System will submit Receiving Transaction processor.

Step15 - RTP on successful completion Progress the OM Workflow and Line status change from Awaiting receipt to SHIPPED.