E1: 34: R3483 Parallel Processing MRP Intermittently Stops Processing At End Of LLX=0 (Doc ID 1996957.1)

Last updated on DECEMBER 16, 2015

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

On : 9.1 version, R3483 Parallel MRP with pre-processing
MRP, Parallel Manage Subsystem Trigger R B3401580

Parallel MRP R3483 intermittently may have one or more of the parallel subsystem jobs stop running and remain at a processing state even though no further processing is being performed, as if the process is hung.  The 'hung' processes never complete.

The hung state can be confirmed by reviewing the record counts in MRP related tables (F3411, F3412 and F3413) and also the record count (F3420.MATH01) of the parallel MRP F3420 Semaphore table being processed by MRP. While the record counts are increasing in F3411, F3412 and F3413 and are decreasing in the F3420 Semaphore table, then the subsystem jobs are actively processing and are not hung.  

If, at some later time, it is evident that the system stops creating records in the MRP tables and also Semaphore count at F3420 gets stuck at a record count (such as F3420.MATH01 = “1”), then it becomes apparent that the entire MRP subsystem jobs have stopped processing.

Note: It may also be observed that MRP stopped processing at low level code LLX=0 group. The record count of the semaphore table denotes that system is at the last item of the  LLX=0 group, which is still waiting to be processed. Hence, all the subsystem jobs are continuously looking for that one last item (F986613.JOBSTS=R, F986113.OPCR = ‘W’) at F986113 file, but it is never found, hence subsystem job goes to sleep. Once it is wakes up, it looks for a record or item to process and when no record is found, then it sleeps again.  This is continued indefinitely and MRP subsystem job never completes.

Due to this issue, users cannot consistently run MRP to completion. Intermittent, but recurring issue.

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