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