Users Using ASCP and Not Standard MRP Product - The MRP_RELIEF INTERFACE_S Max Sequence Value Is Reaching Max Value - Steps to Reset
(Doc ID 2283582.1)
Last updated on JULY 05, 2017
Applies to:Oracle Materials Requirement Planning - Version 12.1.3 and later
Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Planning Manager in Production
Users have begun using ASCP and no longer use the older Planning Product called MRP. They recall, when they used the old MRP product, where their MRP planning was shut down for a day due to the sequence MRP_RELIEF INTERFACE_S reaching its maximum value and making the Planning Manager fail. They need to know if the steps they performed when they were using old MRP are the same ones they need to follow since they're now ONLY using ASCP. Here were the previous steps in Old MRP:
1. Run the following sql:
2. Run the following sql:
3. Set the following EBS source instance profiles to No:
4. Run the following sql from time to time to keep the relief table clear
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