Understanding Applying PeopleSoft Regional Settings Personalizations to BI Publisher Reports

When displaying date, date-time, time or number values in a report, you may format these values according to the PeopleSoft Regional Settings formatting options.

Parameters

To apply PeopleSoft regional settings personalizations to BI Publisher reports, PeopleSoft provides the following parameters to the BI Publisher core engine at runtime:

  • $PsftDateTime

  • $PsftDateTimeTZ

  • $PsftDate

  • $PsftTime

These parameters contain the PeopleSoft specific formatting mask for PeopleSoft date-time, date, and time fields. You may declare and use these parameters in the template in conjunction with the format-date() function. For example:

  • <?format-date:QEQ_HIST_DT;$PsftDate?>

  • <?format-date:DTTM_STAMP;$PsftDateTime?>

  • <?format-date:DTTM_STAMP;$PsftDateTimeTZ?>

Prior to using these parameters, you must declared them under a form field at the top of the reports primary template, one for each of the parameters being used as shown in the following example:

<xsl:param name="PsftDate" xdofo:ctx="begin"/>
<xsl:param name="PsftDateTime" xdofo:ctx="begin"/>
<xsl:param name="PsftDateTimeTZ" xdofo:ctx="begin"/>
<xsl:param name="PsftTime" xdofo:ctx="begin"/>

Time Value Formats

To format time values, you must prefix an arbitrary date value to the time before you can successfully format it. This is necessary to ensure that the date-time value passed to the format-date() function is in the required canonical format. The following example shows prefixing a date component to the runtime value and formatting it using the $PsftTime parameter:

<?if:RUNTIME!=' ' and RUNTIME!=''?>
<?format-date:concat('1900-01-01T',RUNTIME);$PsftTime?>
<?end if?>

Number Value Formats

Formatting a number value does not require the use of a parameter. It only requires that an Oracle number format mask, including the grouping separator (G) and decimal separator (D), be specified in the format-number() function, as shown in the following example:

<?format-number:AMOUNT;'999G999D99'?>

See Report Designers Guide for Oracle Business Intelligence Publisher, “Formatting Numbers” for more information.

Formatting Masks

The following are the PeopleSoft regional settings formatting options taken into consideration for the PeopleSoft formatting masks:

  • Time Separator

  • Date Separator

  • Local Time Zone

  • Date Format

  • Digit Group Separator

  • Decimal Separator

  • Time Format

Dependencies

Note the following dependencies for applying PeopleSoft regional settings personalizations to BI Publisher reports:

  • The report template type must be RTF or XSL.

  • The format-date() function requires a date-time value in the canonical format. For example:

    Date:  2008-07-28
Date-Time:  2008-07-28T09:00:00-0700 
Time:  1900-01-01T05:55:00

    Data from the T onwards is optional. If not included, BI Publisher assumes it represents 12:00 AM UTC.

    For example:

    2008-07-28T00:00:00-0000