My Oracle Support Banner

E-Business Suite (BI Publisher) 11i - R12 : Excel Format Output Is Trimming Leading Zeros (Doc ID 417811.1)

Last updated on APRIL 13, 2024

Applies to:

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


Symptoms

 

This document has been consolidated into <Note 1546377.1>.  Please reference Note 1546377.1 for the latest updates.

 

Created an XML Publisher report with Excel output.  When numeric data includes leading zeros, these are dropped in the output e.g. 00123 becomes 123.

Example source XML :
<root>
<invoices>
<invoice>
<invoice_number>0000123</invoice_number>
</invoice>
<invoice>
</root>

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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