My Oracle Support Banner

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

Last updated on SEPTEMBER 04, 2020

Applies to:

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


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.


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

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