My Oracle Support Banner

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 and later
Information in this document applies to any platform.


Actual Behavior

The number '2120000007E1' shows as '2.12E+11' in the spread sheet generated from Manufacturer BOM Report

Expected Behavior

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

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