Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
User-define column does not return values — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

User-define column does not return values

Accepted answer
44
Views
10
Comments
edited Apr 13, 2023 12:51PM in Reporting and Analytics for HCM 10 comments

Summary:


Content (required):

Hello everyone,

We are currently trying to create a data model using the following sql:

SELECT /*+ MATERIALIZE */

   r.row_low_range_or_name SSN, r.effective_start_date,

   MAX(CASE WHEN c_tl.user_column_name = 'PERFORMANCE_THRESHOLD_AMOUNT'

            THEN v.value

         ELSE ''

         END) PERFORMANCE_THRESHOLD_AMOUNT

FROM ff_user_tables t

INNER JOIN ff_user_rows_f r ON t.user_table_id = r.user_table_id

INNER JOIN ff_user_columns c

INNER JOIN ff_user_columns_tl c_tl ON c.user_column_id = c_tl.user_column_id ON t.user_table_id = c.user_table_id INNER JOIN ff_user_column_instances_f v ON c.user_column_id = v.user_column_id

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!