How do I enable address verification and to avoid data conflicts between the Oracle Address, Email, and Phone Verification and master reference geography data?

You're a sales customer who doesn't use geographies for territory assignment or tax calculation and has purchased Oracle Account and Contact Enrichment by Dun and Bradstreet for data enrichment and the Oracle Address, Email, and Phone Verification for address verification.

To enable address verification and to avoid data conflicts between the Oracle Address, Email, and Phone Verification and master reference geography data you must do the following setups:

  • Deselect the Enable List of Values option in the Geography Mapping and Validation region to avoid Oracle Address, Email, and Phone Verification data conflicts with master reference geography data. By deselecting this option you can avoid any UI level validation against master geographies while adding address.

  • Select Geography Validation Level for Country as No validation to verify address data by Oracle Address, Email, and Phone Verification.

Perform the following steps on the Manage Geography Validation page to enable address verification and to avoid data conflicts between the Oracle Address, Email, and Phone Verification and master reference geography data:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, search for the country by the name or country code, for example US.

  3. Click the Go to Task button in the Validation Defined column. The Manage Geography Validation page appears.

  4. Deselect the Enable List of Values check boxes for all the geography attributes to avoid any UI level validation against master geographies while entering the addresses. If the Enable List of Values check boxes are selected then, in case of data conflicts, Geography Naming References records aren't created.

Note: If any of the Geography Types listed isn't applicable to the selected country's territory structure, then you must deselect the geography validation for that type.

If you're planning to create territories based on a particular Geography Type, such as County, then you must deselect all the Geography Validation levels under that Geography Type (in this case City and Postal Code) based on which you want to create the territory.

Tip: Review the Address Style Formats that are selected on the Manage Geography Validation page. The review is required because on the Account or Contact Simplified UI page, address attributes are displayed based on the address formats and verified or enriched addresses are saved in Oracle Applications Cloud based on the selected address formats.