MRCSAL1 Load/Copy/Merge MDS Errors ORA-08004: Sequence MRP_SCHEDULE_DATES_S.NEXTVAL Exceeds Maxvalue / Also MSC Push Plan Information OR MRP/MPS Plannning And Discussion To Avoid ORA-00001
(Doc ID 1401177.1)
Last updated on DECEMBER 11, 2023
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
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
This can also happen for Load MPS schedule
How is this resolved?
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!