QA Collection Element's Action SQL Works in WIP but not in MES (Doc ID 1487169.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

When entering quality results from MES, the collection elements are not providing any output from the SQL as per the standard behaviour but the elements considering the SQL as default values.
Error message is like :
Row 1 '&Collection element name' Value '&SQL statement' exceeds the maximum allowed value (VARCHAR (150, -127))
 

Solution

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