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 JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
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 - Memory Based Planner in PROD:

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

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