MRCNEW MEMORY BASED PLANNER FAILS ON SEQUENCE MRP_FULL_PEGGING_S - APP-MRP-22075 OR ORA-08004 AND DISCUSSION OF ORA-00001 AVOIDANCE (Doc ID 1056175.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner

*** Checked for relevance on 17-May-2013 ***


Goal

Log file shows MRCNEW module: Memory-based Planner failed with the following:

The SQL statement being executed at the time of the error was: select MRP_FULL_PEGGING_S.nextval from MRP_CACHE_SEQ where rownum <= and was executed from th
e file 3897853/mrp/src/mrlflp.pc.
APP-MRP-22075: An internal error has occurred (mradfpalloc, 1, 3052644, )
ve.

Statement with the error:
select MRP_FULL_PEGGING_S.nextval from MRP_CACHE_SEQ where rownum <=
3897853/mrp/src/mrlflp.pc

Sometimes the log file will show an ORA-08004 or just an 08004 error as well

How do you fix this problem?

Solution

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 hundreds of Community platforms