AMOUNT & CURRENCY APPEAR IN SAME COLUMN AFTER EXPORTED THROUGH EXCEL
(Doc ID 2328768.1)
Last updated on NOVEMBER 15, 2017
Applies to:Oracle Fusion Project Costing Cloud Service - Version 18.104.22.168.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.
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