Performance Issue: Entering Sample Results and Calculating Expressions
(Doc ID 2819261.1)
Last updated on MAY 15, 2023
Applies to:
Oracle Process Manufacturing Process Execution - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Sample Results
ACTUAL BEHAVIOR
---------------
Entering Sample Results and Calculating Expressions
After upgrading from 12.1.3 to 12.2.10 it was noticed that entering, navigating, and calculating expressions for sample results is taking lot of time to complete. This is occurring for any results that have expressions. The following SQL looks to be causing the performance issue:
SELECT COUNT(*)
FROM
GMD_RESULTS_A A WHERE A.RESULT_ID=:B1 AND A.AUDIT_TIMESTAMP > TO_DATE('22 47
19 04 06 2021','SS MI HH24 DD MM YYYY')
EXPECTED BEHAVIOR
-----------------------
Entering, navigating, and calculating expressions for sample results completes within a reasonable time
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 |
Cause |
Solution |
References |