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 07, 2021
Oracle Materials Requirement Planning - Version 11.5.10 and later
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
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
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.