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.

Symptoms

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.

Example:

"123456789_Currency_Code_DelimeterUSD"

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

 

Steps:

  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

 

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