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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Value Set for an Element Input Value not working

Summary:

Value Set for an Element Input Value not working
I created value set " EMP_CHILDREN_VS"
Module : Global Payroll
Validation Type : Table
Value Data Type : Character

when i add element entry to employee and need to select Input Value Child 1 Name , should be showing data
but there is no data showing

FROM Clause :

PER_CONTACT_RELATIONSHIPS, PER_PERSON_NAMES_F_V,PER_USERS, PER_PEOPLE_F

Value Column Name :

SUBSTR((PER_PERSON_NAMES_F_V.DISPLAY_NAME||' - Birthdate: '||PER_PEOPLE_F.DATE_OF_BIRTH),1,150)

WHERE Clause :

PER_USERS.person_id = PER_CONTACT_RELATIONSHIPS.PERSON_ID
--AND UPPER (PER_USERS.USERNAME) = UPPER (fnd_global.user_name)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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