MRCRLF - Planning Manager Taking Too Long To Complete (Doc ID 1616975.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

Qn1:We are having issues due to Planning Manager, which is taking too long to complete.
Not sure if it reflects upon the cause of the issue, but we have noticed that Jet Queue starts pilling up instantly while planning manager is running for too long.

How is this resolved?
 
Qn2: After changing the profiles, we can still see some cycles running for a long time.

Log file shows:

NORMAL CYCLE

PLSQL:Updated mtl_supply                                              28   00:00
.mps_relief                                                           32    0:01
 -- this shows processsing 32 rows in 1 second

 

LONG CYCLE

PLSQL:Updated mtl_supply                                              42   00:01
.mps_relief                                                           43   48:36

-- this shows processing 43 rows and taking 48 minutes

 

Solution

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