ETL9.2: Leave Time Not Displaying Correctly in Direct Line Reports for Multiple Jobs with Different Benefit Record Number. (Doc ID 2006969.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Leave Time Not Displaying Correctly in Direct Line Reports with Multiple Jobs with the benefit record number which is not the same as a job record number.

The Manager Dashboard should display these values if the customer instance uses Absence Mgmt & Time Labor modules.

STEPS

1. Navigate: Main Menu > Manager Self Service > Manager Dashboard
2. Direct Report Pagelet for the multiple jobs employee with the benefit record number which is not the same as a job record number.
3. View Sick Time or Vacation Time Columns of Multiple Jobs Employee. 

Due to this issue, the emlp_rcd field on TL_COMPLEAV_TBL is equivalent to the benefit_rcd_nbr which is not mutually exclusive to the empl_rcd found on tables for employees like PS_JOB and PS_EMPLOYEES so joining the empl_rcd from a table like PS_JOB to the empl_rcd found on TL_COMPLEAV_TBL can result in inaccurate rows returned

Cause

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