My Oracle Support Banner

Performance Issue While Querying Wip Components (Doc ID 1384768.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Work in Process - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


On : - 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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.