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) |