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 SEPTEMBER 07, 2023

Applies to:

Symptoms

Users are running a DRP plan with Capacity check box enabled, but MRCNEW - Memory Based Planner log file errors with the following

ERROR
-----------------------
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 <

gthsk1=207868
gthsk2=543
gthsk3=1
gthsk4=1
gthsk5=53
gthsk6=1297
Total memory usage: 2097144

STEPS
-----------------------
1. Run DRP plan with Capacity enabled
2. MRCNEW fails with ORA-8004

Cause

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