My Oracle Support Banner

E-BI/XMLP: Bipublisher generating output with incorrect time. (Doc ID 2360967.1)

Last updated on FEBRUARY 14, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.


Running a query with data/time fields from application(query manager or Query viewer) or from the Query scheduler it is displaying same date/time as it exist in that table in the database, But when the same query is used as data source and ran from XMLP it is generating report with time difference where a + 8hours is seen. 

This is working as designed.

The issue can be reproduced at will with the following steps:
1.Create a query from Reporting tools-->Query-->Query manager. using a 
delivered record(ex: PSAUDIT or psprcsrqst) which has date/time zone column. 
2. run to excel.--Observe the date/time fields. 
3. Use same Query as data source and run XMLP process.

The issue has the following business impact:
Due to this issue, users cannot see the actual time in the PDF report.




To view full details, 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 a vibrant support community of peers and Oracle experts.