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
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..
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms