Oracle R12 Order Management – Sales Order in Back Ordered Status reasons

Oracle R12 Order Management – Sales Order in Back Ordered Status reasons

Below may be the possible reasons for backordered status even after sales order lines are pick released.

1.       Sales Order in On-Hold

2.       Inventory Period not open

3.       Non availability of On-hand quantity for the ordered item

4.       Non availability of On-hand quantity to reserve / transact

5.       Non availability of On-hand quantity in the required sub-inventory

6.       Lot from which items are selected is inactive / expired 

7.       Lot control Item Lot Divisible Option not enabled

8.       Specified Lot is Disallowed Transaction (Applied on Material Status)

9.       Item On-Hand to Disallowed Transaction (Applied on Material Status)

10.   Wrong Item reservation (even inventory have enough quantity)

11.   Inventory reserved for other sales orders

12.   Previously returned to stock not properly performed

13.   Cycle Count Adjustments

14.   Serial Control Item Serial number not allocated or not assigned 

15.   Manually Backordered 

16.   Move order is in pending status

Solution:

Query the sales order in Shipping Transaction Form and ensure that the status is “Ready to Release”.

Possibilities for this problem:

Case A: Sales Order in On-Hold

Query the sales order & check whether the order is on-hold.

Navigate to the Sales Order View & query using sales order number & order type.

Click on Open Order > Click Action Button > Additional order info.

Perform the same for order level and line level.

Case B & C: Non availability of on-hand quantity / Item on-hand stock with Lot expired

Navigate to Material Workbench to check if the lot has expired or not having enough inventory for this order.

Check if any lot is reserved for other sales order as well.

In Material Work Bench, check for each lot in the physical locator by clicking on the “Attribute” button. (Lot level reservation)

Alternatively, Navigate to Shipping Transaction Form > OM Shipping View or Navigate to Lot Number, click on Attribute column to check the Sale Order reservation of the lot.

Compare the Sales Order info with the order that are having problem.

Case D: Wrong reservation (even inventory have enough qty)

Navigate to Reserve Supply form to check if the order is wrongly reserved.

Case E: Inventory reserved for other orders

In the Reserve Supply form, check if the quantity is being picked up by other order as well. (Order level reservation regardless of lot number)

Also, Navigate to Material Workbench > Availability, to check for the available to reserve.

Case F: Inventory picked up by other orders

High possibility that the On-hand quantity is reserved by order with different line, or other orders which have been auto pick release launched.

If this is the case, the sales order must be backordered manually.

Navigate to Transact Move Order Form > Pick Wave Tab > View/Update allocation > Lot/Serial.

Click on the checkbox for order which need to be backordered, then go to Tool > Back Order Line.

Case G: Previously returned to stock not done properly

Enquire the user if the order has done return to stock previously.

If yes, it might has high possibility that the return to stock not done properly.

Check the lot status, must be in “Resides in inventory”.

Check in Material Workbench to see if the lot is still packed with LPN or not.

Check also if the lot is in physical locator rather than logical locator.