EMM: WM_PM Process For Auto Assignment Is Running Very Long (Doc ID 2154400.1)

Last updated on JUNE 27, 2016

Applies to:

PeopleSoft Enterprise FIN Maintenance Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, PUM # 11.Performance

ACTUAL BEHAVIOR
---------------
(6/24)WM_PM process for Auto Assignment is running very long

We are testing the new Feature of the Auto Assignment that is delivered Bug 17318312 : EMM: WORK ORDER AUTO ASSIGNMENT. WM_PM Process is running for very long time. One of the SQL (WM_PM.MAIN.AUTOASS2) in the WM_PM process related to auto assignment is running over 2.5 hours. Please help us to resolve the performance issue with this SQL.


Attached is the timing trace from the process, SQL trace output file, SQLT zip file, and the AWR reports
 

EXPECTED BEHAVIOR
-----------------------
AutoAssignment running very long.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable auto assignment feature
2. Run WM_PM


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process WM_PM process in a short time.

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