Introduction:
This SQL query is used to fetching the data of Customer CIF information to identify whether we have any duplicate CIF numbers exists or not.
Cause of the issue:
Business wants a report that contains Customer CIF information to cross check if any duplicate values are exists or not.
How do we solve:
Create a report in BI publisher using below SQL query to extract the Customer CIF details.
SQL Query:
select party_name, account_number,JGZZ_FISCAL_CODE from hz_parties hp ,hz_cust_accounts hca
where hp.party_id= hca.party_id
and JGZZ_FISCAL_CODE is not null
group by party_name, account_number ,JGZZ_FISCAL_CODE
Recent Posts
