Item Number with 'E' Displays as Scientific Notation in the Excel File Exported From Report Using BI Publisher
(Doc ID 2305515.1)
Last updated on DECEMBER 03, 2020
Applies to:Oracle Agile Product Collaboration - Version 126.96.36.199 and later
Information in this document applies to any platform.
The number '2120000007E1' shows as '2.12E+11' in the spread sheet generated from Manufacturer BOM Report
The number '2120000007E1' to show correctly in the spread sheet generated from Manufacturer BOM Report
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Create item with number: 2120000007E1
3. Run Manufacturer BOM Report, and select the custom template created by BI Publisher
4. Export Report to Excel
5. Open the exported report with Microsoft Excel. See the number shows as 2.12E+10 (and in the formula bar it shows 21200000070), and the format is Scientific
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