My Oracle Support Banner

Monitoring Services: Sequences in MRP/CRP Are Approaching MAX_VALUE And Need To Be Reset To Avoid Errors in MRP Applications (Doc ID 2341211.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10 and later
Information in this document applies to any platform.


This monitoring service script checks for Sequences that are approaching MAX_VALUE in the Material Requirements Planning (MRP) application.

These are primarily processes that are run from Material Planner or Supply Chain Planning responsibilities - this is not for ASCP processes that run under the MSC schema /Application except when using Push Plan Information request to move data from MSC schema to MRP schema.

Why do we check these sequences?

 What is purpose of this Monitoring Service?

This information will raise the question -- How long will it take for the sequence to use up last 200 million values and reach MAX_VALUE?

The time horizon to MAX_VALUE cannot be answered without tracking the sequence usage over time.
But generally 200,000,000 should allow for sufficient time to perform the steps below to clean up old data, then reset the sequence and re-load/re-run current active schedules and plans
And the SQL to check data and monitor sequence is included in the solution notes.






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.