My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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:


And this is an example result after exporting to PDF:





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.