Workbooks Show Wrong Null Format in Viewer/Plus After New Install or Upgrade from 4i to 10.1.2 (Doc ID 352194.1)

Last updated on SEPTEMBER 13, 2013

Applies to:

Oracle Discoverer - Version 10.1.2.0.0 to 10.1.2.3 [Release 9.0.4 to 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2013***

Symptoms

After recent upgrade from Discoverer 4.1 to Discoverer 10.1.2, or recent installation of Discoverer 10.1.2, the null values in worksheets are not showing the
correct format.

In Discoverer Desktop and in the pref.txt file, null formats have been set to appear as blank.
When the workbook is run in Discoverer Desktop 4.1 and 10.1.2, the null values correctly show
blank - nothing listed in cell.

When the same workbook is run in Discoverer Plus/Viewer, version 10.1.2, the rows with null values now have the word "null" in the cell instead of just being blank.

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