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 22.214.171.124 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 R126.96.36.199 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
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