WIP MASS LOAD Bad Performance Degraded Over Time, Or Suddenly After Patch 25166872. Discrete Jobs Form Is Also Having Severe Performance Issues. Applicable for EAM Work Orders too.
(Doc ID 2355545.1)
Last updated on JANUARY 02, 2024
Applies to:
Oracle Enterprise Asset Management - Version 12.1.3 and laterOracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
On WIP - Work in Process, 12.1.3 version, Open Interfaces
ACTUAL BEHAVIOR
---------------
WIP Mass Load has performance issues after RUP6 patch.
Statistics :
For updating 25+ jobs, it took 5 to 7 minutes
For updating 200 jobs, it tool around 30 minutes.
EXPECTED BEHAVIOR
-----------------------
Expect to have previous timings at least
could be in seconds for 25 jobs and around 5 to 10 minutes for 100+ jobs.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. release jobs from ASCP
2. observe WIP Mass Load processing them
Changes
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 |