Configuration – Value set to get Employee Category list

Employee category (EMPLOYEE_CATG) is a delivered user type lookup in Oracle HCM which can be extended. However, in few cases, there is a requirement to populate employee category at DFF attribute(s), in this case, we need to create a table defined value set.

FROM Clause	fnd_lookup_values
Value Attributes Table Alias
*Value Column Name	substr(meaning,1,80)
Value Column Type	VARCHAR2
Value Column Length	80
Description Column Name	substr(meaning,1,100)
Description Column Type	VARCHAR2
Description Column Length	80
ID Column Name	substr(meaning,1,100)
ID Column Type	VARCHAR2
ID Column Length	80
Enabled Flag Column Name
Start Date Column Name
End Date Column Name
WHERE Clause	lookup_type= ‘EMPLOYEE_CATG’ and TAG is NULL and language = ‘US’ and enabled_flag = ‘Y’
ORDER BY Clause	substr(meaning,1,100)