R12.0+ Customer Merge Validation

Hi Friends,

Many of your customer Merge programs are terminating by DBA team since those are taking long time to complete and creating locks in Database

This will result in partial merge .

in these cases, duplicate Accounts and sites will be marked as inactive but invoices/contracts or orders are still in inactive sites.

Requirement:

+---------------+

1. We are trying to find some reports we can run after the merge which will show if there is any pending items

2. Report to run before the merges to do all validation and capture the expected errors customer merge can cause (these are related to the data validation like  consolidated invoices are in draft status or orders are in ship confirm status )