11i Supplier Reload error Supplier name already exists
I have loaded around 150+ suppliers with sites, now user wants to populate one extra column Pay Group.
How to update or end date existing suppliers so that I can reload the suppliers with same name and additional column again.
I re-named existing supplier name as DNU-1234, tax payer id = NULL and populated the end date in Base Table (PO_VENDORS), still import program rejecting saying – ‘Supplier name already exists’
Did not make any change in interface table.