Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

API to partially Backorder a Pick Released Order Line

Use Shipping API to backorder items on an order which has been pick released

This is achieved using the WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API. This API should be called with the following input variables.

• source_code := 'OE'; -- The only source code that should be used by the API
• changed_attributes(1).delivery_detail_id := &delivery_detail_id  -- Delivery Detail ID
• changed_attributes(1).shipped_quantity := &shipped_quantity       -- Quantity to be shipped, remainder will be backordered.

The following test case has been executed:

1. Created an Order with three Lines
Line 1 -- PC Mousepad    -- Ordered Qty = 15
Line 2 -- PC Mousepad    -- Ordered Qty = 10
Line 3 -- PC01200097    -- Ordered Qty = 20

2. Navigate to Shipping Transaction Form
3. Search for the order created.
4. Select all three lines and then Launch Pick Release.
5. The status of the lines should change to show that the lines can now be pick confirmed - status should be "Staged/Pick Confirmed". A single delivery should have been created.
6. Obtain the value stored in DELIVERY_DETAIL_ID - this is shown on the Shipping transaction form in the Detail column.
7.  Call the WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API to change the shipped quantity to 7 (3 items will be backordered)
8. After calling the code, examine the Shipping Transactions Form, lines/lpns tab for the order to see that the Delivery Line will be changed so that the shipped quantity is 7 and the backordered quantity is 3.
9. Ship Confirm the Delivery, The outcome of doing this will be that:
9.1. Ship confirmed 15 of line 1 on the order
9.2. Ship confirmed 7 of line 3 on the order
9.3. BACKORDERED 3 of line 2 on the order
9.4. Ship Confirmed 10 of line 3 on the order

Related Posts

• Order workflow statuses
• Order Management List of Shipping Statuses
• What is SUPPLY-TO-ORDER?
• Create a Customer
• Defining Release Rules
• OE Header or OE Lines Table Column Links Back To A Purchase REQ for Back To Back Orders
• Set Defaulting Shipping Document at the time of ship confirm based on the customers
• How To Progress ATO Lines Passed Supply Eligible?
• Can I update an imported Internal Order through order import?
• Is it possible to keep the legacy order number through order import?