Configuration Currency Data Column Incorrect Formatting When Export To Excel From Report

(Doc ID 2145244.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2015 R2 Update 4 and later
Information in this document applies to any platform.


When data columns based on configuration currency attributes are exported to Excel, they have a hard coded "_Currency_Code_Delimeter" in between the value and currency code and show up in one column.



This is different than Commerce Currency attributes which show up with the value in one column and the currency code in a separate column.



  1. Assign a configuration currency attribute to a data column
  2. Create a quote with a model that populates this currency attribute
  3. Make a report using the data column as a display column and filters the created quote
  4. Run the report and export to excel
  5. View incorrect output



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