BI Publisher (MOSC)

MOSC Banner

Excel output fails when the data contains "E."

edited Jul 5, 2012 6:57PM in BI Publisher (MOSC) 14 commentsAnswered ✓
I am using OIBEE 11.1.1.6.0 to generate Excel output. It is failing to create the spreadsheet when the data contains a capital E and a dot, eg "E."

Here is a small sample output generated when I select XML as my output type

<?xml version="1.0" encoding="UTF-8" ?>
<!-- Generated by Oracle BI Publisher 11.1.1.6.0 -->
<DATA_DS>
<G_1>
 <USER_NAME>E.J Smith</USER_NAME>
</G_1>
</DATA_DS>

When I use rtf to generate Excel it produces a error in the output

The report cannot be rendered because of an error, please contact the administrator. java.lang.NullPointerException

I have other reports, including xls, without issue so it appears to be related to how it renders the E. In other datamodels I've found I have to wrap the output in quotes to get it to display but that isn't helping in this case.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center