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 APRIL 21, 2020

Applies to:

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


Symptoms

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.

Steps

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

Errors

The duplicate bills can cause multiple errors including the following: