Duplicate Supplier check during conversion from several source systems
Summary:
We are converting supplier ( Party ) from different lagacy (MS Dynamic, SAP and Oracle EBS) to a single instance Oracle Cloud. Many suppliers across the application are same but with different name ( not exact Name) i.e. Fedex in one instance and Fedex Inc in another. What is the best way to merge them to a single global supplier before conversion. Any idea on this, we want to avoid manual process of validation as there are more than 100000 suppliers.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):