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

Last updated on JULY 31, 2017

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms