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 Custom field DFF?

Received Response
32
Views
2
Comments
edited Apr 12, 2024 6:10PM in Human Capital Management 2 comments

Hello Experts,

We're adding a Custom Grade Ladder through a Descriptive Flexfield (DFF), where the values originate from the UDT. The expected outcome is that selecting Grade ID L1 should display all configured values from the UDT. However, it fails to do so as there's no value present in the Custom Grade Ladder field.

Here's the SQL we are using in the DFF:

select SUBSTR(FUCIF.VALUE,1,150)

FROM FF_USER_COLUMN_INSTANCES_F FUCIF, FF_USER_TABLES FUT, FF_USER_COLUMNS FUC, FF_USER_ROWS_F FURF

WHERE
1=1
AND FUCIF.USER_ROW_ID = FURF.USER_ROW_ID
AND FUCIF.USER_COLUMN_ID = FUC.USER_COLUMN_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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