Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
How to get the value from the UDT for the Position DFF?
Hello experts,
We have this requirement where we need to get the values from UDT for the Position DFF. When this DFF Field 'Department' has a value of 'Norca', the LOV for the 'Subdivision' should show the following values from the UDT, but it's not showing any values.
This is the query that we used for the Table value set:
From ff_user_tables t, ff_user_columns c, ff_user_column_instances_f v, fnd_lookup_values_vl lkup
Value Column Name: substr(v.value, 1, 100)
Where Clause: t.base_user_table_name = 'SUBDIVISIONS'-- (name of the UDT)
AND t.user_table_id = c.user_table_id
Tagged:
0