My Oracle Support Banner

Balances Fields Do Not Sum / Are Not Numeric in Results Generated in Allocation History View Screen & Exported to Excel (Doc ID 2392192.1)

Last updated on MAY 03, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On Oracle Financial Services Profitability Management (PFT), in the Allocation History screen, you selecting an Allocation and click the View button.  When you execute a "Run" on the Source data and export the results to Excel, the "Balance" column is created in a Text format.

When you attempt to sum the Balance column in Excel, the total is wrong.  Even after you select the option to 'Convert to Number', the total is wrong.

Steps to Reproduce:

  1. Run an Allocation
  2. Go to Allocation History
  3. Select the Allocation and click on View
  4. Click on "Run"
  5. Select Export to Excel

You expect to be able to sum the balances in the exported Excel data.

Cause

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

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


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