Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
User-define column does not return values
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:
0