Performance Issue With EAM Maintenance Workbench Form (Doc ID 1457419.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, PM

ACTUAL BEHAVIOR
---------------
We are facing a serious performance issue with eAM maintenance workbench Form when we enter date from, date to and select the check boxes 'Complete' & 'Complete-No Charges'.

We are also facing the performance issue after getting the Results (Capital), when we click on the '+ Assets With Work'. Our application hangs.

EXPECTED BEHAVIOR
-----------------------
Expect performance of less than 5 sec

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

Navigation#1:

Enterprise Asset Management --> Workorder Planning --> Maintenance Workbench --> Enter Date From, Date To and select the check boxes 'Complete' and 'Complete-No Charges' and click on Launch.

Navigation#2:

Enterprise Asset Management --> Workorder Planning --> Maintenance Workbench --> Enter Date From, Date To and select the check boxes 'Complete' and 'Complete-No Charges' --> Launch --> Results (Capital) --> Click on '+Assets With Work'.

In both cases, it takes more than 45mins to fetch the results.

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