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 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
- Goto Bills of Material > Bills > Bills
- Query an existing bill of material
- Multiple rows display for the same item
Errors
The duplicate bills can cause multiple errors including the following:
- In BOM > routings > operations resources:
Changes
Cause
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
Symptoms Verification Changes Cause Solution A. DATAFIX B. AVOIDING ISSUE References My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.