My Oracle Support Banner

Performance Issue: Entering Sample Results and Calculating Expressions (Doc ID 2819261.1)

Last updated on NOVEMBER 09, 2021

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.10 and later
Information 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


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