Performance Issue With The Standard Job Work Bench While Querying

(Doc ID 1644556.1)

Last updated on APRIL 13, 2014

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, SUPPORT

ACTUAL BEHAVIOR
---------------
When we try to query a discrete job in the Job workbench through filter option by entering the job number, the query returns the details for the first job correctly but when you try the same thing with the filter button for the second Job it takes more than 20 mins to return the details.

EXPECTED BEHAVIOR
-----------------------
Expect that the Job workbench responds quickly in all cases

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

1. Responsibility: WIP
2. Go to Job workbench
3. Query a discrete job in the Job workbench through filter option by entering the job number, the query returns the details for the first job correctly but when you try the same thing with the filter button for the second Job it takes more than 20 minutes to return the details.


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