Planning Manager Hangs When Processing More Than 100k Records
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
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
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
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