My Oracle Support Banner

After Upgrading to 12.2.9, Find There are Performance Issues When Navigating In Batch Steps Form (Doc ID 2692249.1)

Last updated on JULY 18, 2020

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Performance

ACTUAL BEHAVIOR
---------------
After upgrading to 12.2.9 release, find there are performance issues when navigating in batch steps  form.
When using the batch steps form going from step to step, or drilling down into activity and resources it is taking up to 30 second per move.

Query having performance issue is as follows:

SELECT POC_TRANS_ID
FROM
 GME_RESOURCE_TXNS GRT WHERE GRT.DOC_ID = :B1 AND GRT.DELETE_MARK = 0 AND
  GRT.REVERSE_ID IS NULL AND NOT EXISTS (SELECT 1 FROM GME_RESOURCE_TXNS_GTMP
  GRG WHERE GRG.DOC_ID = :B1 AND GRG.DELETE_MARK = 0 AND GRG.POC_TRANS_ID =
  GRT.POC_TRANS_ID)



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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Production Supervisor
2. Navigation: Batch Details
3. Click on Steps button.



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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