Using Time Zones in BI Publisher Reports
When displaying date time values, BI Publisher takes into consideration the time zone of the user running the report. The time zone is retrieved from the user's Personalizations settings (). Personalized time zone display is dependent on the following conditions:
The report template must be either RTF or XSL.
The datetime element in the XML file must include the UTC offset, for example, 2008-07-28T09:00:00-0700.
Note: A Query data source includes the offset for datetime fields.
The time zone must be mapped to a default IANA time zone under the Time Zone Mapping page. To access the page select
BI Publisher uses the associated IANA time zone when processing the report. All delivered PeopleSoft time zones are mapped to a default IANA time zone. If custom time zones have been implemented in your environment and have not been mapped to a default IANA time zone, BI Publisher will not recognize these custom time zones and will display the time in UTC. The following warning will be logged:
Warning: No corresponding IANA time zone defined for user time zone XYZ.See PeopleTools: Global Technology, “Setting and Maintaining Time Zones” for more information.
The datetime field in the template can be formatted using an Oracle abstract format mask that displays the time zone. For example:
<?format-date:STARTDATETIME;'SHORT_TIME_TZ'?>Oracle abstract format masks are listed in Fusion Middleware Report Designer's Guide for Oracle Business Intelligence Publisher “Creating an RTF Template,” Using Oracle Abstract Format Masks.
Alternatively, you may apply the PeopleSoft regional settings formatting mask such as $PsftDateTime or $PsftDateTimeTZ. See Applying PeopleSoft Regional Settings Personalizations to BI Publisher Reports