E1: 37: Enhancment Request for the Performance of the P37204, Test Result Inquiry (Doc ID 1923338.1)

Last updated on DECEMBER 16, 2015

Applies to:

JD Edwards EnterpriseOne Quality Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

9.0

Performance problems with the Test Results Inquiry P37204
When performing an inquiry in P37204, the first result set returns incredibly slowly (several minutes). When they return, if the user tries to advance to the next page of results in the grid, JAS_MSG 347 is received. . After copying the data tables from our production environment to any other environment, the problem exists in the target environment. A similar query can be performed on the database in fractions of a second.

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