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
Oracle Materials Requirement Planning - Version 220.127.116.11 and later Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
***Checked for relevance on 22-Aug-2013***
In 18.104.22.168 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!