Performance Issue While Querying Wip Components (Doc ID 1384768.1)

Last updated on JANUARY 04, 2016

Applies to:

Oracle Work in Process - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 09-DEC-2013***

Symptoms

On : 11.5.10.2 - 12.1.3

There are 2 WIP forms (WIPDJMDF.fmb and WIPMRMDF.fmb) that exhibit a performance issue when clicking Component button of the discrete job. The forms and versions are below.
The issue started after Database Upgrade to 11g from 9i.

It should be less than 5 seconds to show all the components for a Discrete Job.

The issue can be reproduced at will with the following steps:
1. Responsibility: Work In Process
2. Navigation: Discrete Jobs-- Query for Discrete Job
3. Click Components for one of the Discrete Job

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