"SimServerException Message: Error executing stored procedure" Error When Executing PurgeDSDReceivings Batch (Doc ID 2215997.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

If a Purchase Order is linked to Multiple Direct Store Delivery (DSD) shipments, the batch PurgeDSDReceivings fails with the following exception




Steps To Reproduce:

  1. Navigate to Shipping/Receiving - > Purchase Order.
  2. Select the Purchase Order.
  3. Create Delivery.
  4. Don't create a container for this DSD.
  5. Select the same PO again.
  6. Create Delivery.
  7. Create a container and received all the items and the expected quantities from the PO.
  8. Confirm the Container.
  9. Confirm the DSD.
  10. Observe that the DSD from step 3 is in "In Progress" status and the DSD from step 6 is in "Received" status and the PO is in "Completed" status.
  11. Execute PurgeDSDReceivings batch and notice, the batch fails due to integrity constraint violation on the PO.

Changes

 

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