My Oracle Support Banner

MSCPUSH Push Plan Errors ORA-00001: unique constraint (MRP.MRP_GROSS_REQUIREMENTS_U1) violated (Doc ID 944864.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10 and later
Information in this document applies to any platform.
Executable:MSCPUSH - Push Plan Information




Symptoms

After running an ASCP plan, then running Push Plan Information. Push ran and failed with following error.

ERROR

ORACLE error 2055 in FDPSTP

Cause: FDPSTP failed due to ORA-02055: distributed update operation failed; rollback required
ORA-00001: unique constraint (MRP.MRP_GROSS_REQUIREMENTS_U1) violated
ORA-02063: preceding line from ASCP_TO_ERP (<< db link name)

Changes

 Reset RDBMS sequence MRP_GROSS_REQUIREMENTS_S

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
Changes
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.