My Oracle Support Banner

MRCNEW Memory Based Planner Errors MRP_EXCEPTION_DETAILS_S.NEXTVAL APP-MRP-22064 And Extended Discussion On ORA-00001 Error Resolution (Doc ID 1329545.1)

Last updated on FEBRUARY 13, 2018

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
***Checked for relevance on 22-Aug-2013***

Symptoms

In 11.5.10.2 or LATER- Memory Based Planner

Users are running Single Org and Multi-Org MRP/SCP plans (Not ASCP). However, MRCNEW module: Memory-based Planner errors with the following:

begin
:var_output := dbms_lock.release(:var_handle);
end;

Statement with the error:
select MRP_EXCEPTION_DETAILS_S.nextval from MRP_CACHE_SEQ where rown
3637659/mrp/src/mrlnw4.pc

APP-MRP-22064: An internal error has occurred (mraexd_add_exception_details, 2)

Cause: The current routine encountered the specified internal error.

Action: Contact your customer support representative.

All plans are now failing with the same error

STEPS
======
1. Run MRP/SCP plan
2. Plan fails in MRCNEW with error

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!


In this Document
Symptoms
Cause
Solution
 Recovery from Error Condition
 CHECK SEQUENCE
 DROP AND RE-CREATE THE SEQUENCE
 CHECK DATA AND PERFORM MAINTENANCE
 Preventative Maintenance
References


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