ETL9.x: Direct Reports Dashboard No Longer Displays Comp Time Correctly After Bundle 12 or 11.
Last updated on SEPTEMBER 13, 2017
Applies to:PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, Time Reporting
The Direct Line Reports dashboard does not display the compensatory time off balances on the Time tab as it used to prior to applying recent bundles. This occurs if the comptime plan never expires.
In review of the code :
Record: UX_PAGELET_WRK.DIRECT_REPORTS FieldFormula Peoplecode the following -
If UX_DIR_PLT_CFG.INCLUDE_COMPBAL = "Y" Then
SQLExec("SELECT COMP_TIME_PLAN FROM PS_TL_EMPL_COMP WHERE EMPLID = :1 AND EMPL_RCD = :2 AND EFF_STATUS = 'A' AND EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_TL_EMPL_COMP C WHERE EMPLID = :1 AND EMPL_RCD = :2 AND EFF_STATUS = 'A' AND EFFDT <= %DATEIN(:3)) ", &EmplID, &EmplRCD, %Date, &sCompTimePlan);
SQLExec("SELECT END_BAL FROM PS_TL_COMP_DAY_BAL WHERE EMPLID = :1 AND EMPL_RCD = :2 AND COMP_TIME_PLAN = :3 AND ACTION = 'X' AND DUR=(SELECT MAX(DUR) FROM PS_TL_COMP_DAY_BAL WHERE EMPLID=:1 AND EMPL_RCD=:2 AND DUR < %CurrentDateIn)", &EmplID, &EmplRCD, &sCompTimePlan, &rsEmployees.GetRow(&nRow).UX_PAGELET_WRK.COMP_BALANCE.Value);
&rsEmployees.GetRow(&nRow).UX_PAGELET_WRK.COMP_BALANCE.DecimalPosition = TL_INSTALLATION.DECIMAL_POSITIONS.Value;
We do not have any values in PS_TL_COMP_DAY WHERE ACTION = 'X'.
The comptime balance should be displayed with the same value they see on the Timesheets.
The issue can be reproduced at will with the following steps:
1. Find employee enrolled in a Compensatory Time Off plan that never expires
2. Report Comptime earned on the employee's timesheet and approve
3. run time administration
4. verify that the PS_TL_COMPLEAV_TBL and the PS_TL_COMP_DAY_BAL table only contains one row with a value of 'E' and a row with an 'x' value is not inserted.
This keeps the managers from seeing the comptime available balance for their employees.
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