Need query to get Customer Account Merge History
Summary:
Need query to get Customer Account Merge History.
Content (required):
How to get history of account merges for HZ_CUST_ACCOUNTS? For HZ_PARTIES, the merged party record has STATUS value of 'M' and the MASTER_PARTY_ID column holds the PARTY_ID of surviving party. I don't see any column similar to MASTER_PARTY_ID in HZ_CUST_ACCOUNTS. So, how can we get history of accounts that were merged along with the corresponding surviving record id?
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Applications 23B (11.13.23.04.0)
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0