My Oracle Support Banner

MRCNEW Memory-based Planner Erroring Out With 'APP-MRP-22064: An internal error has occurred (mrcatp_calculate_atp, 2)' (Doc ID 2195740.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

MRCNEW Memory-based Planner errors out, details of the error in the log 

Statement with the error:
select MRP_AVAILABLE_TO_PROMISE_S.nextval from MRP_CACHE_SEQ where r

APP-MRP-22064: An internal error has occurred (mrcatp_calculate_atp, 2)

Cause: The current routine encountered the specified internal error.

Action: Contact your customer support representative.

 

In order to apply the below solution , ensure that the same statement with error is listed in your log :

Statement with the error:
select MRP_AVAILABLE_TO_PROMISE_S.nextval from MRP_CACHE_SEQ where r

 

Cause

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
Symptoms
Cause
Solution
 Recovery from Error Condition
 CHECK SEQUENCE
 DROP AND RE-CREATE THE SEQUENCE
 CHECK DATA AND PERFORM MAINTENANCE
 Preventative Maintenance
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.