Un-assign/ delete common bill of material from Child Org

 Hi All,

I am faced with a business scenario in which I need to remove the reference to a common BOM from a child organization or delete the BOM all together from the Child org. We created the Common BOM from Master org to child orgs for Configurator but in due course of time some of the child orgs  (MFG INV orgs) had to be disabled. There is sales order related data in these disabled organizations which cannot be purged. So only two options remain:

1. Some how disable the constraint and delete the BOM in child org

2. Remove the COMMON_ASSEMBLY_ITEM_ID, COMMON_BILL_SEQUENCE_ID , and COMMON_ORGANIZATION_ID from BOM table for the child inventory org.