Fusion Applications - Global Payroll - Unable To Get Data From Query In Value Set On Payroll Input Value - fetching Employee's children in an Input Value of an Element
Last updated on OCTOBER 29, 2017
Applies to:Oracle Fusion Global Payroll - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
The requirement is to fetch Employee's children in an Input Value of an Element.
The table query is not bringing the value in LOV on Manage Element Entries screen of the Employee;
The steps to achieve this which we used are the following;
1. Create a Value Set ("TEST_VS")
a. Module: Global Payroll
b. Validation Type: Table
c. Value Data Type: Character
d. FROM Clause: PER_PERSON_NAMES_F
e. Value Column Name: LAST_NAME
f. WHERE Clause: PERSON_ID = xxxxxxxxxxxxxxxxx
2. Create a Non-Recurring Element ("TEST_Element")
a. Primary Classification: Standard Earnings
b. Category: Standard
c. Retroactive Event Group: Entry Changes for Retro
d. Create an Input value ("Testing LOV")
i. Unit of Measure: Character
ii. Checked Displayed, Allow User Entry, Required, Create a Database Item
iii. Value Set: TEST_VS
3. Person Management > Search one Employee > Manage Element Entries
4. Assign Element to the employee
i. Change Effective Date
ii. Search "TEST_Element" element
iii. Click on "Testing_LOV" LOV and find it empty, even after searching found nothing.
Kindly help to complete this requirement as I am unable to find the reason for not showing the VS value in the dropdown.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms