My Oracle Support Banner

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

Last updated on MAY 04, 2024

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


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..


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.