My Oracle Support Banner

Item Num/Level Is Converted to Numeric in Excel Format of BOM Comparison Report (Doc ID 2012176.1)

Last updated on MARCH 13, 2019

Applies to:

Oracle Agile Product Collaboration - Version and later
Information in this document applies to any platform.


Actual Behavior
Item Num/Level is converted to numeric in Excel format of BOM Comparison Report
 - Leading 0 is truncated
   e.g. Item Num: 0002231 is shown as '2231'
 - .1 representing BOM level is converted to '0.1'
   e.g. Level: .1 is shown as '0.1'
This is not a display issue. The data in Excel is stored as numeric format. ('2231', not '0002231' is stored in Excel)

Expected Behavior
Item Num/Level is not converted to numeric in Excel format of BOM Comparison Report

1. Login to Web Client
2. Create 2 assemblies
3. Run BOM Comparison Report
   Output Format=Excel
   Item: 0002231, 0002232
4. BOM_Comparison_Report.xls is generated.
 Number is shown like '2231','22311' instead of '0002231','00022311'
 Level is shown like '0.1' instead of '.1'
  (Other levels are shown correctly as '..2')

What Is Working
PDF or HTML format other than Excel shows the correct Item Num/Level


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.