Planning Manager Hangs When Processing More Than 100k Records

(Doc ID 886405.1)

Last updated on JUNE 28, 2017

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


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.

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




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