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 laterInformation 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 |