There is a common requirement to use value sets in various DFF attributes across Fusion HCM application. Oracle HCM supports different kind of value sets – Independent, Table validated etc. There is a use case where a user wants to see a list of values containing numbers from 1 to n. There are two approaches…
*FROM Clause wlf_learning_items_f wlif, wlf_learning_items_f_tl wlift Value Attributes Table Alias *Value Column Name SUBSTR(wlift.name,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column Name TO_CHAR(wlif.LEARNING_ITEM_ID) ID Column Type VARCHAR2 ID Column Length 40 Enabled Flag Column Name Start Date Column…
Use below setup to create a table based value set which will show the list of all departments: *FROM Clause HR_ORG_UNIT_CLASSIFICATIONS_F HOCF, HR_ORGANIZATION_UNITS_F_TL HOUT Value Attributes Table Alias *Value Column Name SUBSTR(HOUT.NAME,1,150) Value Column Type VARCHAR2 Value Column Length 150 Description Column Name Description Column Type Description Column Length ID Column…
