E-BI/XMLP: String Field Leading Zeroes Do Not Appear When Report Is Run To Excel
Last updated on JUNE 02, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.
*** Currency Checked December 2013 ***
*** Currency Checked September 2015 ***
BI Publisher, (XML Publisher), reports that have fields based on String values in the database, where the numbers have leading zeros, when run to Excel output the leading zeroes are not shown in the resulting Excel output.
For a value such as: "0001000", it appears as "100".
When the same report is run to .HTM, .PDF or .RTF, the leading zeroes are correctly displayed.
By following these steps the issue can be reproduced:
1. Log in into PIA.
2. Go to Reporting Tools > Query > Query Manager to create a new Query.
3. Create a Query on record containing a VARCHAR field with prefix zeroes (for example, PS_DEPT_TBL record containing DEPTID field).
4. Save the new Query.
5. Go to Reporting Tools > XML Publisher > Data Source to create a new Data Source.
6. Create a new Data Source using the newly created Query.
7. Click on "Generate" link to generate the sample XML Data File.
8. Click on "Generate" link to generate the XSD schema file.
9. Create a simple RTF template for XML Publisher and run it to XLS.
10. DEPTID values like "000100" are shown as "100" (numeric).
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