Reserve Materials Process(IN_FUL_RSV) ABENDED At Step IN_ORD_RLS.GetCReqH.GetLnCom (SQL) Unique Constraint (Doc ID 2894510.1)

Last updated on JANUARY 23, 2024

Applies to:

Symptoms

When an item is substituted in an Order, the substituted item gets created with an existing Order line number instead of a new line number, which causes the process to abend with unique constraint error.

Steps:
1. Create a requisition with 3 lines.
     Purchasing -> Requisitions -> Add/Update Requisition
2. Run Auto Sourcing
     Purchasing ->Purchase Orders ->  Stage/Source Requests -> Auto
Requisition Selection
3. Run Inventory Demand
     Purchasing ->Purchase Orders ->  Stage/Source Requests -> Inventory
Demand
4. Check IN_DEMAND table to see new order created.
5. Create a new Requisition again with 5 lines.
6. Add line comments to all the 5 lines and select the "Send to Supplier"
check box.
7. Run Auto Sourcing.
8. Run Inventory Demand
9. Check IN_DEMAND table to see new order created
10. Run the Reserve Material Process (This runs the Order release process).
      Inventory -> Fulfill Stock Orders -> Stock Requests -> Reserve
Materials Process
11. Check the IN_DEMAND table to see the rows have status changed to
Released(40)
12. Open the Material Picking Feedback process and search without any Order
No to pick all rows in IN_DEMAND table.
       Inventory -> Fulfill Stock Orders -> Stock Requests -> Reserve
Materials Process
13. Substitute second item of the second order and check the confirm box.
14. Save the page: Click on OK for confirmation.
15. New row created for the second Order No with same order line number that
already exists.
16. Check IN_DEMAND table to see the same.
17. Undo Fulfillment for the second order number.
18. Run the Reserve Material Process again for the same order number that was
unfulfilled.
19. Process goes to "No success"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.