Collection Elements Of Data Type Date Are Observed In QA_Result Table As Data Type CHARACTER1,2,3

(Doc ID 2297927.1)

Last updated on AUGUST 24, 2017

Applies to:

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

Goal

User has observed that Collection Elements of data type Date are seen in the QA_Results Table in a column with a data type of CHARACTER1, CHARACTER2, ETC.

They have the following questions

 Will calculations of date function using these values in formulas work and will it have a limitation on number of CHARACTER type attributes used in a Collection plans.
 

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