My Oracle Support Banner

Push Plan Information Failing With Unique Constraint (MRP.MRP_RECOMMENDATIONS_U1) Violated (Doc ID 2290674.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

PROBLEM

Push Plan information failing with unique constraint (MRP.MRP_RECOMMENDATIONS_U1) violated

Customer is on R12.2.6.2 distributed installation. While trying to run the "Push Plan information" for different item categories, the initial run for a category completes fine, the next run for a different category name fails with error
 - MRP.MRP_RECOMMENDATIONS_U1) violated

It is noticed that the sequence nextval is not getting incremented to the last value and is showing a lesser value than the transaction_id value in the table mrp_recommendations.


ERROR

unique constraint (MRP.MRP_RECOMMENDATIONS_U1) violated


STEPS

The issue can be reproduced at will with the following steps:
1. Run push plan from ASCP
2. Log file fails as noted

Changes

 

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.