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.

Goal

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:

 

Solution

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