Dropship的流程

做的一个Dropship流程的实录(包括流程期间遇到问题的解决)

What are the advantages of Drop Shipment Orders?
These are the benefits:

• No inventory is required
• Reduced order fulfillment processing costs
• Reduced flow times
• Elimination of losses on non-sellable goods
• Elimination of packing and shipping costs
• Reduced inventory space requirements
• Reduced shipping time to your customer
• Allows you to offer a variety of products to your customers
  

How to understand the dataflow for Drop shipment Orders?
To understand, here are the processes divided in sub process and the underline activity is highlighted here:

Here are the Details as per Mark

1.Order Entry
Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked asDROP SHIP
2. Order Booking
3. The Purchase Release program passes information about eligible drop-ship order lines toOracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all
4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders
7. After the goods are successfully received invoices