MSCPDP - 'Planning Data Pull' Periodically Completes With ORA-01403 Error (Doc ID 827533.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

When Launching the 'Planning Data Collections', the 'Planning Data Pull' concurrent process will periodically error with an ORA-01403. At the end of the log file, it shows the following message:

This request finished with an error and produced the following completion message: Concurrent Manager encountered an error while attempting to start your immediate concurrent program MSCPDP. Routine &ROUTINE received a return code of failure.

Steps:
1) Launch Planning Data Collections.
2) Note the 'Planning Data Pull' concurrent program ends with error status and shows an ORA-01403 No Data Found error message in the log file.

Cause

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