My Oracle Support Banner

Planning Manager Completes In Error Without Any Actual Error (Doc ID 2735889.1)

Last updated on JUNE 11, 2021

Applies to:

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

Symptoms

On : 12.2.8 version, Materials Requirements Plan.

The Planning Manager is completing with a status of 'Error', but when looking into the log file, there is no error to be seen:

ERROR
-----------------------
Here is where the log ends:

...Loading periods. Please wait . 0:00
..Loading sales orders 186 0:01
The value of MRP_FC_EXPLOSION is 1
..Inserted 895 rows in MRP_FORM_QUERY (ACTION=inserted) 0:00
..Deleted from MRP_FORM_QUERY 895 0:00

When compared to an instance where the failure is not occurring, the next line shows that 'forecast import' is running.
===========================
forecast import has started
The value of the profile option 'MRP_SCHED_MGR_BATCH_SIZE' is 5000
The value of the profile option 'MRP_SCHED_MGR_MAX_WORKERS' is 2
LOCK TABLE mrp_forecast_interface IN SHARE ROW EXCLUSIVE MODE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch the Planning Manager

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


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