Duplicate Records In The Mtl_sales_orders Table
(Doc ID 1424652.1)
Last updated on AUGUST 11, 2022
Applies to:Oracle Inventory Management - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Pick Release
When attempting to pick release orders, the following error occurs.
- Pick Release process could not allocate 3 of item XXXX for the Sales order XXXXXX as there was insufficient quantity available Or Inventory allocations have failed, and the line has been back ordered.
The message above is seen for various lines and items.
Pick selection is completed
l_completion_status ==> WARNING
- An error occurred while relieving reservations.,Y,Transaction processor
The issue can be reproduced at will with the following steps:
- Order Management responsibility
- Navigation: Shipping > Release Sales Order > Release Sales Order
- See errors
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document