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

Applies to:

Oracle Materials Requirement Planning - Version and later
Information in this document applies to any platform.
Executable:MRCNEW - Memory-based Planner
***Checked for relevance on 22-Aug-2013***


In 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