Removing Specification from Parts and MPNs
I have to remove obsolete specification from all parts (where it is used) and MPNs.
Parts/MPNs are in Lakhs.
I tried by creating SDK and remove from specification table ( on parts and it’s all revision) but System on ‘Calculate Compliance'(set as daily run) add it again(not able to locate cause).
querying by sdk itself is challenge as data is huge.
direct action on DB is unacceptable, but might try for extreme cases.
Any suggestion on approach.