MRCSAL1 Load/Copy/Merge MDS Errors ORA-08004: Sequence Mrp_schedule_dates_s.Nextval Exceeds Maxvalue Also Discussion To Avoid ORA-00001 (Doc ID 1401177.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:MRCSAL1 - Load/Copy/Merge MDS


Goal


On 11.5.10 MDS in PROD:

Users are running MRCSAL1 Load/Copy/Merge MDS. However the MDS fails with the following in the log file:

ORACLE error 8004 in mrlins_insert_mrp_sched_dates
Cause: mrlins_insert_mrp_sched_dates failed due to ORA-08004: sequence MRP_SCHEDULE_DATES_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
.
The SQL statement being executed at the
. 0:04
Buf : ()...
Buf : ()...

Statement with the error:
insert into MRP_SCHEDULE_DATES(inventory_item_id,organization_id,sched
2639914/mrp/src/mrlfl1.pc

How is this resolved?


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