E-BI/XMLP: Incorrect Report Time Zone Displayed Compared To Application Server System Time (Doc ID 2184709.1)

Last updated on JUNE 15, 2023

Applies to:

Symptoms

Environment

1. PeopleTools release and patch : Reported on PeopleTools 8.54.24 but issue exists on PeopleTools 8.54 and 8.55
2. PeopleSoft Application and release : HCM TL Time Reporting 9.2
3. Database Product and version : Oracle

Issue
1. BI Publisher report displays or prints incorrect time on report. For example Time and Labor BI Publisher report contains 1 hour inconsistency with punch time
2. BI Publisher report runs with no error.

Impact
1. Erroneous time displayed on BI Publisher report. For instance there may be a one hour difference where the printed and displayed time maybe one hour behind the system time on Application Server.
2. Issue exists for every user running BI Publisher reports.

The issue can be reproduced with the following steps:

1. The data in the tables is in EST. When the report runs, it shows the time in a different time zone.
2. Punch time done at 5:17. When running the report it shows the 5:17 punch time was recorded at 4:17. The data in the underlying table that the report uses is 5:17.

In Production:
Find incorrect time - one hour behind displayed on BI Publisher report - in this case for HCM Time Reporting for Punch Time field.

Expect correct consistent time displayed on BI Publisher report and system time on Application Server.

Cause

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