My Oracle Support Banner

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

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
-----------------------
The issue can be reproduced at will with the following steps:
1. Run DRP plan with Capacity enabled
2. MRCNEW fails with ORA-8004

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.