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


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



SELECT 
  MSLT.LINE_ID
FROM 
  MRP_SO_LINES_TEMP MSLT
WHERE 
  MSLT.PROCESS_STATUS = 2 AND
  MSLT.REQUEST_ID  IS NULL AND
  ROWNUM <= :B1 AND
  NOT EXISTS (SELECT 1 FROM MRP_SALES_ORDER_UPDATES UPD WHERE  UPD.SALES_ORDER_ID = MSLT.LINE_ID AND
  UPD.PROCESS_STATUS = 3) AND
  NOT EXISTS (SELECT 1 FROM  MRP_SO_LINES_TEMP MSLT1 WHERE MSLT.LINE_ID = MSLT1.LINE_ID AND
  MSLT1.PROCESS_STATUS = 3) FOR  UPDATE OF PROCESS_STATUS NOWAIT

 

Cause

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