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 11.12.1.0.0 to 11.13.18.02.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

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.

Changes

 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.

Cause

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