Got error of duplicate TP_SITE_CODE during collection

Summary:

In MSC_ST_TRADING_PARTNER_SITES there are collection failed record with error:

"There's already a record with the same value for the TP_SITE_CODE attribute for another source system."

Seems it is because the MSC_CUSTOMER_SITES and MSC_ST_TRADING_PARTNER_SITES both have the same TP_SITE_CODE = 493679

select * from MSC_ST_TRADING_PARTNER_SITESwhere tp_site_code = '493679'

select * from MSC_CUSTOMER_SITES where tp_site_code = '493679'

Both records collect from OPS.

But in OPS, we only has one party site , why this duplicate error happen ?

select * from HZ_PARTY_SITES where party_site_number = '493679'