My Oracle Support Banner

BOM Item Is Exported But Does Not Appear in the UI (Doc ID 2540143.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Actual Behavior

There is a BOM item that is exported in the export file, but does not appear in the BOM tab of the Item through Client UI.

Expected Behavior

BOM item that is exported to the export file to appear in the Client UI as well


The issue can be reproduced at will with the following steps:

  1. Login to Web Client
  2. Open the Item with problem BOM
  3. Goto BOM tab
  4. Actions > Export, and export to Excel file
  5. Open Excel file. See there is a BOM item which is not visible in the BOM tab
  6. When running below sql on agile database schema, can see that the record returns with component=0
    SELECT * FROM BOM WHERE ITEM_NUMBER='<BOM item number found in step 5'>;
    Note: BOM with COMPONENT=0 means that the BOM item was manually added through UI, however corresponding item still does not exist in the database. Such BOM item should appear in the client UI with the question mark


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.