MRCNEW Memory Based Planner Errors Mrp_exception_details_s.Nextval App-Mrp-22064 And Extended Discussion On ORA-00001 Error Resolution
Last updated on JUNE 28, 2017
Applies to:Oracle Materials Requirement Planning - Version 188.8.131.52 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***
In 184.108.40.206 - 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:
:var_output := dbms_lock.release(:var_handle);
Statement with the error:
select MRP_EXCEPTION_DETAILS_S.nextval from MRP_CACHE_SEQ where rown
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
1. Run MRP/SCP plan
2. Plan fails in MRCNEW with error
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms