My Oracle Support Banner

Parcel Manifest Status "Close Manifest In Progress" -Error ORA-00001: unique constraint (Doc ID 2808991.1)

Last updated on SEPTEMBER 22, 2021

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 21.3 and later
Information in this document applies to any platform.

Symptoms


Parcel Manifests Stuck in "Close Manifest In Progress" Status.

There are some parcel manifests stuck in "Close Manifest In Progress" status in WMS Production instance.
Have physically shipped product.
WMS application is not updated to complete the process.

Need to close manifest and have corresponding messages sent to other system.
  Inventory history message sent.



ERROR
-----------------------
Error ORA-00001: unique constraint (ADMIN.PARCEL_SHIPMENT_DTL_UKEY) violated



STEPS
-----------------------
The issue can be observed at:
1. Navigate  to User Interface (UI): Parcel Manifests.
2. Find status: Close Manifest in Progress.
3. Highlight row, select action Manifest Logs.
    See Description: Exceptions found during close manifest, Error ORA-00001: unique constraint (ADMIN.PARCEL_SHIPMENT_DTL_UKEY) violated.





Cause

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
Symptoms
Cause
Solution


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