My Oracle Support Banner

Planning Manager Hangs When Processing More Than 100k Records (Doc ID 886405.1)

Last updated on JANUARY 04, 2021

Applies to:

Oracle Materials Requirement Planning - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:MRCRLF - Planning Manager


Symptoms

Planning Manager is running for long time, and its not spawning new requests for every 30 sec's.
MRP's are completing normal but we are not able to get the data in the Plan work bench.


ERROR
=====================================
SELECT distinct request_id
FROM mrp_so_lines_temp
WHERE process_status = 3
AND request_id IS NOT NULL

=====================================
=====================================
Compute sales order changes has started
The value of profile option 'MRP_COMPUTE_SO_CHANGES' is Y

The Planning Manager is hanging in statement

 

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
References

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