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

(Doc ID 2315409.1)

Last updated on OCTOBER 29, 2017

Applies to:

Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

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.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms