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 (Doc ID 1315736.1)

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.

Symptoms

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:

  1. Create a sales order
  2. Release the sales order for picking
  3. Attempt to change the schedule date on a sales order line item.
    Note that the status of the sales order line item is "Picked"
  4. Receive the error message

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms