BI PUBLISHER : Leading Zeroes Are Truncated When The Report Is Of Excel Format
(Doc ID 760041.1)
Last updated on MARCH 15, 2021
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