Number Formatting in Payroll Global Reports

You can use the Unit of Measurement (UOM) option to define how numbers are formatted and displayed on payroll reports. You can use the UOM field to format precision or number of decimal values for the following in payroll reports:

• Hours
• Amount

However, when you use the MS Excel format for a payroll report output and view the output on your local computer, MS Excel does its own formatting based on the settings on your local computer. In order to maintain consistent values across the various output formats of MS Excel, PDF, Text, you must ensure that the settings on your machine are consistent with the UOM definition.

Currencies are always shown as two decimal values after the separator, example, 151.25 or 130.10. The zeros shouldn't be truncated.

Payroll reports will now display Balance values based on its UOM definition.

Submitting User Preference

If you override a predefined flow in an LDG and select the Submitting User check box, the report output of the overridden predefined flow thus created includes the correct translated format of all parameters and values based on the preference setup of the submitting user. The user submitting the flow can use the Set Preferences feature to set the general preference of formatting amount, hours, and currency in the report output.

Use Unit of Measurement (UOM) to define how numbers are formatted and how payroll reports display Balance values based on its UOM definition.

Steps to Enable

Follow these steps to set the user preference of language and formatting in the report output.

• Navigate to Flow Pattern page, search and select the flow pattern for the report in an LDG, copy and edit the flow, and select the Submitting User check box.
• Use the Set Preferences feature to set the general preference of formatting number, time, and currency in the report output.

Key Resources

Refer the following topics on the Oracle Help Center:

• Translate Payroll Reports Based on Submitting User Preference