Upgrading from 11i
to R12 and you use Bill of Material's (BOM's)? Strike before you upgrade to avoid known errors related to duplicate BOM's. In later versions of 11.5.10, index BOM_STRUCTURES_B_U1 was added to prevent the ability to create duplicate BOM's. Great, right? Yes, very great, except in a case where you are upgrading to R12 and you haven't checked for and removed old duplicate BOM's, before or if index BOM_STRUCTURES_B_U1 was added. If you have duplicate BOM's, upgrade processes such as the one offered in Doc ID 1082375.1
, will fail. You can get ahead of this issue by using note, Find Two Bills of Material (BOM) for the Same Item (BOMFDBOM) leading to ORA-01427 or SQL-02112 error (Doc ID 370841.1)
Duplicate BOM's not only can cause errors while upgrading, they can cause different issues in your system and affect resources. Use Doc ID 370841.1
to help check for duplicate BOM's and let's make sure duplicate BOM's don't throw a wrench into your upgrade.