EMM: WM_PM Runs Into No Success With Unique Constraint Error When Run In Parallel Instances (Doc ID 2106892.1)

Last updated on AUGUST 17, 2017

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.
*** Currency checked on 08/17/2017 ***

Symptoms

 
To work around the performance issue with WM_PM process while processing huge volume of work orders, we have triggered parallel instances of WM_PM for different shops within the same business unit.
One of the instances failed due to unique constraint error while inserting data into WO Header table.

Steps
----------
This issue can be replicated by performing the following steps:

Try to run parallel instance of WM_PM for different shops within the same business unit.
make sure you have a volume of at least 1000 work orders per shop that will be picked up for processing.

Business Impact
----------------------
This issue will stop us from running parallel instances of WM_PM and will result in huge amount of processing time to generate PM Work Orders every month.

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