Siebel SQLs/Error Messages > Find Duplicate Addresses in s_con_addr table
This SQL shows duplicate addresses in s_con_addr table Checked against Siebel 8.1 and Oracle 11g
SELECT created,row_id, accnt_id, addr_per_id, relation_type_cd, start_dt, bu_id, db_last_upd_src FROM S_CON_ADDR WHERE ACCNT_ID in ( SELECT ACCNT_ID FROM S_CON_ADDR GROUP BY ADDR_PER_ID, ACCNT_ID having count(ADDR_PER_ID)>1 and count(ACCNT_ID)>1) order by accnt_id;
|