Performance Issue While Querying Wip Components
Last updated on JANUARY 04, 2016
Applies to:Oracle Work in Process - Version 18.104.22.168 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***
On : 22.214.171.124 - 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
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