MRCNEW Memory Based Planner Errors MRP_EXCEPTION_DETAILS_S.NEXTVAL APP-MRP-22064 And Extended Discussion On ORA-00001 Error Resolution
Last updated on FEBRUARY 13, 2018
Applies to:Oracle Materials Requirement Planning - Version 18.104.22.168 and later
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
***Checked for relevance on 22-Aug-2013***
In 22.214.171.124 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:
: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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms