My Oracle Support Banner

EMM: The Preventive Maintenance Process WM_PM Process Still Takes Longer To Process Even After Applying Bug 30970658 (Doc ID 2802477.1)

Last updated on AUGUST 26, 2021

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The Preventive Maintenance Process (WM_PM) Process is running for more than 7 hours even after applying <Bug 30970658>
The process is stuck on the below SQL:


The issue can be reproduced at will with the following steps:


1. Add a New Work Order with ~200000 Schedules / Projections

Navigation: Maintenance Management > Work Order Management > Work Order
2. Run the Preventive Maintenance Process (WM_PM) process.

Navigation: Maintenance Management > Preventive Maintenance > Run Projection

Changes

 The performance issue occurs after applying FSCM 9.2.36 <Bug 30970658>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.