My Oracle Support Banner

Find Two Bills of Material (BOM) for the Same Item (BOMFDBOM) leading to ORA-01427 or SQL-02112 error (Doc ID 370841.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Bills of Material - Version to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
FORM:BOMFDBOM.FMB - Define Bill of Material


You find one item has two (or more) Bill of Materials at the table level.
There are two records for the same assembly_item_id in bom_bill_of_materials but with different bill_sequence_id.
Note that the duplicates may appear as Engineering items or regular Manufactured items.


  1. Goto Bills of Material > Bills > Bills
  2. Query an existing bill of material
  3. Multiple rows display for the same item


The duplicate bills can cause multiple errors including the following: