My Oracle Support Banner

Configuration Currency Data Column Incorrect Formatting When Export To Excel From Report (Doc ID 2145244.1)

Last updated on MAY 08, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.