Delete items and mfg part with pl sql

Dear sir,
I have some item and mfg part need to delete with pl sql.

Example :

delete from ….. where item in (AAAA’,’BBBB’,’CCCC)
delete from …. where mfgpart in (‘XXXXXX’,’YYYYY’,’ZZZZZ’)

Provide plsql statement to me,Please.

Thanks you.

No Files Were Attached
sommaip Agile User Asked on April 11, 2018 in Product Collaboration.
Add Comment
2 Answer(s)

Hi,

I don’t think it is advised to do so. Item can have multiple dependencies and so does MPNs. If you must delete then try using sdk codes. First try to programmatically remove the dependencies, make the object orphan and then soft-delete it.

Regards,
Arif

Arif Agile Angel Answered on April 11, 2018.
Add Comment

Definitely Arif has a point.
Do not delete in database.
SDK codes is the best approach but you can also try to use DataLoad.

My best
Carlos

Carlos L Benassi Agile Angel Answered on April 11, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.