AMOUNT & CURRENCY APPEAR IN SAME COLUMN AFTER EXPORTED THROUGH EXCEL
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Fusion Project Costing Cloud Service - Version 126.96.36.199.0 to 11.13.18.02.0 [Release 1.0]
Information in this document applies to any platform.
The currency code and amount are in the same column when Project Costs are exported to Excel
After the R12 upgrade issue with Project Costs data export is as under.
When the data is exported, the currency code is concatenated with the amount as a single value. Users need to trim, parse or replace the text in order to have the amounts exist as numeric values.
The expected behavior is that the the users could export the data to Excel and then sum and pivot the burdened cost or raw cost values.
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