Push Plan Information Failing With Unique Constraint (MRP.MRP_RECOMMENDATIONS_U1) Violated
Last updated on JULY 31, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
Push Plan information failing with unique constraint (MRP.MRP_RECOMMENDATIONS_U1) violated
Customer is on R18.104.22.168 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.
unique constraint (MRP.MRP_RECOMMENDATIONS_U1) violated
The issue can be reproduced at will with the following steps:
1. Run push plan from ASCP
2. Log file fails as noted
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms