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 FEBRUARY 13, 2018

Applies to:

Oracle Materials Requirement Planning - Version and later
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner

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


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, )

Statement with the error:
select MRP_FULL_PEGGING_S.nextval from MRP_CACHE_SEQ where rownum <=

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

How do you fix this problem?


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