My Oracle Support Banner

Incorrect Values In The Exported CSV File Of The BAM Dashboards Based On Predefined SQL (Doc ID 2695715.1)

Last updated on OCTOBER 29, 2021

Applies to:

Oracle BAM (Business Activity Monitoring) - Version and later
Information in this document applies to any platform.


On : version, BAM Dashboard

After setting EnableFullDownload=true, export and save the full download .csv file then reopen.

It has been observed that some fields containing a comma will shift to the next column


1) Using the System MBean Browser in EM set the MBean attribute EnableFullDownload to true and apply

2) Restart the BAM server

3) In BAM Designer, create a new project or use an existing one

4) Use an existing data object or create a new one as follows:

a) Create a simple data object called GourmetFood with the following columns:

b) Populate it as follows:
Brand Category Sales
Pasta Gourmet Pasta 42,566.31
Montego Bay Pasta 40,098.78
Specialty Farms,Vermont Cheese 61,992.27
Pasta Gourmet Pasta 37,132.83
Vermont Specialty Farms Cheese 37,524.87
Montego Bay Pasta 57,463.02
Wisconsin Cheese Works Cheese 41,834.61
Wisconsin Cheese Works Cheese 27,406.89

c) Add the data object to your project.
If using an existing data object, add a row with a value that contains a comma in a String field

5) Create a Flat SQL Query to read all fields from the data object created in step 4

6) Create a List view using the query created in step 5

7) Create a Dashboard using the view created in step 6

8) Open the Dashboard created in step 7 and click on the Download icon in the upper right corner of the List view. Save the file.

9) Open the saved file in Excel and verify that the row with the field that contains a comma has the right number of fields in Excel


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.