How to get the value from the UDT for the Position DFF? — 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

How to get the value from the UDT for the Position DFF?

edited Mar 27, 2024 7:31AM in Human Capital Management 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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