Receive Error "A reservation record with the same item, organization, demand source, and supply source already exists" when Changing the Scheduled Ship Date on a Sales Order Line
Last updated on OCTOBER 19, 2016
Applies to:Oracle Inventory Management - Version 12.0.0 and later
Oracle Shipping Execution - Version 12.0.0 and later
Oracle Warehouse Management - Version 12.0.0 and later
Information in this document applies to any platform.
When attempting to change the scheduled ship date on a sales order line, the following error occurs. The only workaround seems to be to backorder the lines, re-release, re-pick and finally have rescan the LPN info for the order.
A reservation record with the same item, organization, demand source, and supply source already exists. Please use transfer reservation if you still want to make the changes.
The issue can be reproduced at will with the following steps:
- Create a sales order
- Release the sales order for picking
- Attempt to change the schedule date on a sales order line item.
Note that the status of the sales order line item is "Picked"
- Receive the error message
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms