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)

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

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

05-DEC-2018 update: If users have increased the MAX_VALUE of sequence MRP_FULL_PEGGING_S above 2147483647 in order to fix the problem you may see the following error in the Memory Based Planner MRCNEW

APP-FND-01564: ORACLE error 1455 in mrsgrs_select_full_peg_sequence

Cause: mrsgrs_select_full_peg_sequence failed due to ORA-01455: converting column overflows integer datatype

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 the file 4706477/mrp/lib/mrlflp.pc.
APP-MRP-22075: An internal error has occurred (mradfpalloc, 1, 5537163,  )
@ERRORTEXT            Cause:        The current routine encountered the specified@ERRORTEXT  x        Action:        Contact your customer supportrepresentative.

Statement with the error:
select MRP_FULL_PEGGING_S.nextval   from MRP_CACHE_SEQ where ROWNUM<=:
4706477/mrp/lib/mrlflp.pc

How do you fix this problem?

Solution

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