Applying PeopleSoft Regional Settings Personalizations to Reports Run Through Process Scheduler

When reports are run through the Process Scheduler, there is no browser locale to consider, and personalization depends only on the user-specified overrides or system defaults from the My Preferences - Regional Settings page. This is determined specifically for the user who scheduled the report.

Note however that for a scheduled report, the regional settings only apply to the date, date-time and time values. For the purpose of maintaining backwards compatibility, a number value in a scheduled report will always be determined by the language code that is associated with the process run control. This is meant to avoid impacting already-existing behavior regarding the formatting of number values in a scheduled report. Essentially, the language code is used to obtain the associated ISO locale code from the PSLANGUAGES table (for example, ENG=en, FRA=fr, etc.), which is then used by the BIP engine while processing the report. This determines the appropriate locale-specific grouping separator (G) and decimal separator (D) to be used when a number is formatted with the format-number() function.

For example, when running with language code FRA, the outcome of this form-field syntax:

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

where AMOUNT = 1234.56 will be 1 234,56.