Delete The Resource Requirement In WIP Material Requirement Performance Issue (Doc ID 2184064.1)

Last updated on NOVEMBER 27, 2016

Applies to:

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

Symptoms

On :  12.2.3 version, Work Order Definition

ACTUAL BEHAVIOR  
---------------
Performance Issue: Delete the resource requirement in WIP Resource Requirements

EXPECTED BEHAVIOR
-----------------------
Better performance

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Responsibility = Work In Process (WIP)
2.  Navigation = Job/Schedule Details-> Operations
3.  Select a Job (XXX)
4.  Choose an operation and press the resources button
5.  Choose the 'RED X' to delete an operation

Also

SELECT COUNT (*)
FROM
 WIP_OPERATION_RESOURCES   WHERE SUBSTITUTE_GROUP_NUM =  :b1  

is executed twice (Why). It takes most of the execution time


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