Module: BOMStructureSeverity: CRITICAL
Bill of Material Contains Infinite Circular Component Loop
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
circular assembly loopcircular loop in bomBOM_CIRCULAR_REFassembly item contained within itselfbom explosion failed
Root Cause Analysis
Assembly item {assemblyItemId} contains itself as a direct or recursive sub-component.
Diagnostic SQL Queries (Read-Only)
CHECK_CIRCULAR_BOMQuery BOM_STRUCTURES_B and BOM_COMPONENTS_B for self-referencing parents
SELECT s.assembly_item_id, c.component_item_id, s.organization_id
FROM bom_structures_b s
JOIN bom_components_b c ON s.bill_sequence_id = c.bill_sequence_id
WHERE s.assembly_item_id = c.component_item_idRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM bom_components_b WHERE bill_sequence_id = :billSeqId AND component_item_id = :assemblyItemIdExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.