My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

Applies to:

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


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:


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



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

-- this shows processing 43 rows and taking 48 minutes



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

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