Impact of the Profile MSC: Purge Staging and Entity Key Translation effect

Hi All,

we are facing issues with the Trading Partners , Suppose if the user changes the Name of the supplier or customer , they will not be collected properly. The source instance id is being collected as "-1".

Oracle has suggested a one time script for that suggesting us to delete the records

SQL> delete from msc_trading_partners c where c.partner_id
in (select partner_id
from msc_trading_partners a
where a.partner_type in (1,2)
and not exists
(select 1 from msc_tp_id_lid b where a.partner_id = b.tp_id));

SQL> delete from msc_trading_partners where sr_instance_id = -1;