BI PUBLISHER : Leading Zeroes Are Truncated When The Report Is Of Excel Format (Doc ID 760041.1)

Last updated on MARCH 08, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.3 to 5.6.3 [Release 5]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 11.5.10


Symptoms

You are in release 11.5.10 and using BI Publisher 5.6.3.

You created a template using a database values such as  "Invoice number" for example.
In the database the column type storing the information is VARCHAR2  and some values are numbers having leading zeroes. (for example "0012345").

When report is submitted in Oracle application with output format set to Excel, the leading zeroes for this columns are truncated.

For Example if the actual Invoice number is "0012345" and the result you get  in Excel is"12345"

This is not the same if output format is set to PDF, HTML etc..

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