Configuration Currency Data Column Incorrect Formatting When Export To Excel From Report
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.
- Assign a configuration currency attribute to a data column
- Create a quote with a model that populates this currency attribute
- Make a report using the data column as a display column and filters the created quote
- Run the report and export to excel
- 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