MRCNEW Memory Based Planner Error APP-FND-01564: ORACLE error 8004 in mrcrssq_cache_res_seq For Sequence CRP_RESOURCE_PLAN_S
(Doc ID 1191027.1)
Last updated on FEBRUARY 14, 2018
Applies to:Oracle Materials Requirement Planning - Version 11.5.9 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
Users are running a DRP plan with Capacity check box enabled, but MRCNEW - Memory Based Planner log file errors with the following
APP-FND-01564: ORACLE error 8004 in mrcrssq_cache_res_seq
Cause: mrcrssq_cache_res_seq failed due to ORA-08004: sequence CRP_RESOURCE_PLAN_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
The SQL statement being executed at the time of the error was: select CRP_RESOURCE_PLAN_S.nextval from MRP_CACHE_SEQ where rownum < and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrcrsf_create_res_file, 3132, , )
APP-MRP-22075: An internal error has occurred (mrfrsp_flush_res_plan, 11, 191029, )
Statement with the error:
select CRP_RESOURCE_PLAN_S.nextval from MRP_CACHE_SEQ where rownum <
Total memory usage: 2097144
The issue can be reproduced at will with the following steps:
1. Run DRP plan with Capacity enabled
2. MRCNEW fails with ORA-8004
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!