My Oracle Support Banner

List Employees by Element not Displaying Entry Value That Uses Lookup Value (Doc ID 2249409.1)

Last updated on DECEMBER 11, 2023

Applies to:

Oracle Payroll - Version 12.1.3 to 12.1 HRMS RUP10 [Release 12.1]
Information in this document applies to any platform.
This note provides a brief overview of .


Problem Statement:

When input value uses lookup code, values are not visible in the List Employees by Element form (PAYWSLEE.fmb).


Steps to Reproduce:

The issue can be reproduced at will with the following steps:


  1.  Create 2 lookup types "Lookup A" and "Look B" with lookup values.
  2.  Create an element "Element A" with input value "IV".
  3.  Assign "Lookup A" to input value "IV" from 01-JAN-2000 and "Lookup B" to input value "IV" from 01-JAN-2010. (Create date track records in pay_input_values_f)
  4.  Create element entry "Element A" to the assignment on 01-JAN-2010 and enter the value for the entry value "IV".
  5.  Go to "List Employees by Element" form and search for the element "Element A".
     (N) View > Lists > Employees by Element
  6.  Assignment is listed but showing null value for "IV".



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.