When approving a supplier registration we get a error supplier ID.

so some we have traced back to alpha numeric in the SS# field. But some of them have 'found' next to the Duplicate Supplier. So we started to search for the duplicates using the below SQLs and can't find any other supplier id with that TIN.

SQLs used to find duplicates

select * from ps_vendor_id_nbrs where std_id_num = '484512693';

select * from ps_vendor_wthd where TIN = '484512693';

no results returned.

Does anyone know why we are receiving an error supplier ID? Or What record the duplicate checking is looking at?