11g When Exporting A Smart Watchlist To HTML, PDF or EXCEL "Custom Columns" Are Not Exported - The Default Values Are Exported Instead (Doc ID 1905366.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140114 and later
Information in this document applies to any platform.

Symptoms

Users are trying to export to PDF, HTML and Excel the output of a Smart Watchlist, in that moment an issue is seen. Basically if you add some "Custom Columns" to the view when you export this it shows the default ones and doesn't include the custom ones. For examples:

1. When seeing the Smart Watchlist in the Dashboard
2. Under "New Smart Watchlist View" you have View option to "Show More Columns". Click there.
3. Scroll down in the Available Columns section and move to the right i.e the "Custom Column 1"
4. Click on Ok
5. Go to Page options (where you commonly go to Edit the dashboard) and choose Print. Here you can try HTML, PDF or Export to Excel.

As described, export results don't have the same columns that the Dashboard shows. In fact you see all default columns. 

 

Below is an example of the Dashboard:

 

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