Balances Fields Do Not Sum / Are Not Numeric in Results Generated in Allocation History View Screen & Exported to Excel
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)
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:
- Run an Allocation
- Go to Allocation History
- Select the Allocation and click on View
- Click on "Run"
- Select Export to Excel
You expect to be able to sum the balances in the exported Excel data.
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 hundreds of Community platforms