My Oracle Support Banner

Fusion Compensation: WFC: View/Manage In Excel Does Not Maintain Rounding Rules Set In Configure Column Properties (Doc ID 2561086.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Goal

1. Compensation Amount - Component 1 columns has Configure Column Properties Rounding Rule = Round to the nearest 0.01 and Decimal Places to display = 2.

When user selects View in Excel the values reflect as round to the nearest 0.001 with 2 decimals displayed. This is causing the sum of values in excel to not equal the summary totals displayed in application.

2. The user-defined custom list values which contain a drop-down list in the worksheet do not show as a drop-down list in excel. Is there a way to have the the drop-down list values maintained as part of the export?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.