My Oracle Support Banner

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 SEPTEMBER 16, 2021

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:



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.