How To Specify The Owner Of Workbooks On The Viewer Url Parameters ?

On Discoverer Viewer/Plus 9.0.4 it was possible to specify the Owner and Workbook Name on the same url parameter :

wb=.

In 10.1.2 this URL parameter is not getting the Owner anymore, just the workbook name.

This is because, the Discoverer Viewer is not checking whether owner name is prefixed to the workbook.

The fix has introduced a new URL parameter "wbkowner" to specify the Owner's name explicitly.

Hence if the owner needs to be specified then instead of prefixing the owner's name to workbook name the user needs to append new URL parameter "wbkowner=Owner's name".
Since, the "." a is valid character for workbook name, the Discoverer Viewer 10.1.2 wouldn't be able to differentiate whether the string of characters before "." in workbook name is owner's name string or substring of workbookname.

The fix is available on top from 10.1.2.3 + Cumulative Patch 2 onwards, where the parameter "wbkowner" can be used on the URL for Discoverer Viewer.

Discoverer Plus users should wait for internal bug to be fixed.

How to Change the Alignment of Page Item in HTML Exported Report Arabic Workbooks From Left To Right

Incredible grow in IT area has been observed in Arabic countries. That's why I've decided to post this info:

Exporting Workbooks from Discoverer Viewer with Arabic Locale in "Hyper-Text Markup
Language)archived)(*.zip)" format, does not align Page Items with the rest of the report. Indeed,
the body of the report (datapoints) are aligned to the right, page items instead are shown on the
left. How to change alignment for Page Items ?

Open the workbook with Discoverer Plus, highlight the Page Items then right click and select
"Format Heading". When dialog window shows, select right alignment icon and save the workbook.

Download Disco5i.jar File with HTTP Protocol While Discoverer Plus is Configured to Work with HTTPS

Recently I've been requested, due to a configuration restrictions with firewalls, whether it is possible to use Discoverer Plus with SSL (https) and yet have the disco5i.jar download occur through http protocol ? The answer is yes, let me show you how :

Pre 10.1.2.2 + CP7 (and 10.1.2.1.0)

• Modify the $ORACLE_HOME/discoverer/config/configuration.xml file.
  
• Change the 'disco_archive' parameter (for relational) to point to the disco5i.jarjar file via an
  HTTPS URL and 'd4o_double' (for Discoverer for OLAP applet)
  
  Example:
  
  
  FROM:
plugin_setup="https://machine.us.oracle.com:443/jpi/j2re.exe" version="1.4.2" versionie="1,4,2,mn"
type="application/x-java-applet"
plugin_page="http://java.sun.com/products/archive/j2se/1.4.2_04/index.html"
disco_archive="disco5i.jarjar" d4o_archive="d4o_double.jarjar"/>
  
  
  
  TO:

plugin_setup="https://machine.us.oracle.com:443/jpi/j2re.exe" version="1.4.2" versionie="1,4,2,mn"
type="application/x-java-applet"
plugin_page="http://java.sun.com/products/archive/j2se/1.4.2_04/index.html"
disco_archive="http://machine.domain/disco/plus_files/disco5i.jarjar"
d4o_archive="http://machine.domain/disco/plus_files/d4o_double.jarjar"/>
  
  

For environments that include iAS/Discoverer 10.1.2.2 with Cumulative Patch 7 or 8 (CP7 or CP8) and/or iAS/Discoverer 10.1.2.3

• Modify the $ORACLE_HOME/discoverer/config/configuration.xml file jar parameters as shown:
  
  
  
  disco_archive=" http://machine.domain/discoverer_disco/plus_files/disco5i.jarjar"
d4o_archive=" http://machine.domain/discoverer_disco/plus_files/d4o_double.jarjar"
  
  
  
• This change will force the disco5i.jarjar to downloaded using the HTTP protocol.