My Oracle Support Banner

WMSPUREPL - Push Replenishment Concurrent Request Completes With Error ORA-00001: unique constraint (Doc ID 1296950.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Warehouse Management - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Inbound Processing

When attempting to run Push Replenishment concurrent program
the following error occurs.

ERROR
-----------------------
[21-SEP-10 17:06:41] WMS_REPLENISHMENT_PVT: Done with Current Consolidated
record
[21-SEP-10 17:06:41] WMS_REPLENISHMENT_PVT: BULK INSERT ALL CONSUMED DEMANDS
IN WRD table
[21-SEP-10 17:06:41] WMS_REPLENISHMENT_PVT: Error in GET_OPEN_MO_QTY
SQLCODE: -1 : ORA-00001: unique constraint
(WMS.WMS_REPLENISHMENT_DETAILS_U2) violated
[21-SEP-10 17:06:41] WMS_REPLENISHMENT_PVT: Error from API
process_replenishment
[21-SEP-10 17:06:41] WMS_REPLENISHMENT_PVT: Error in PUSH_REPLENISHMENT: 1,
User-Defined Exception


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
References


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