MRCMPW - MPS Relief Worker Spawns Many Requests (Doc ID 551237.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
ConcurrentProgram:MRCMPW - MPS Relief Worker
*** Checked for relevance on 24-JUN-2015 ***


Symptoms


11.5.10.2 in Production


PROBLEM
MPS relief worker is spawning many workers trying to process 500K lines this happens on a regular basis as we process many wip jobs/po lines

We are not currently using MPS plans or schedules.

Key profiles

MRP :Interface History Days = 2
MRP:Planning Manager Batch Size 5000
MRP:Planning Manager Max Workers 2

These were set earlier based on performance issue encountered in MPS relief workers.

STEPS
Run standard MRP processes.
This bottleneck happens about 4 out of every 7 days.
Major DRP runs are over the weekend with smaller DRP runs during the week.

BUSINESS IMPACT
Performance team is concerned about these processes and many resources used to process these lines.

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