Address Cleansing Configurations

Address cleansing configurations comprise attributes and parameters for real-time and batch cleansing of addresses.

You have the option of using either the predefined configuration shipped predefined or copying and adapting it to your address cleansing requirements.

For example, you may want the change default country to United Kingdom where the predefined default country is United States.

The predefined real-time address cleansing configuration is named as Address Verification and when done in bulk it's named as Address Cleansing. As part of defining and managing cleansing configurations, you can review and edit the predefined cleansing configuration.

Oracle Address, Email, and Phone Verification includes an online, interactive service to cleanse and validate addresses during the data entry process either through a UI or any other service creating address data into the registry. The real-time address cleansing service parses the input address and validates it against the country-specific postal address reference databases, such as United States Postal Service (USPS), Canada Post, and so on. The real-time address cleansing service runs in two modes:

  • Verify: The verify mode lets you parse, verify, cleanse, transliterate, and format the input address data. This mode checks the reference data and returns the best match (1 to 1).

  • Search: The search mode lets you search all installed data and return multiple results (1 to Many). Note that in search mode up to 20 records are returned for each record. These records are displayed in sorted order from the best potential search result to the least potential search result.

Address cleansing of bulk records performs address cleansing, verification, and standardization for a subset or entirety of the address records in the registry, or as part of a data import process. Batch address cleansing service can only be run in the Verify mode that parses and cleanses the input address data and enables output to be displayed in either native or Latin characters.

You can also specify if the output address must be displayed in native script. For example, if the addresses are in Arabic, the verified output can be displayed in English. This is supported for a native (local) language to Latin (English) output or from Latin to a native output. Note that requests in a non-Latin language can't have a verified output in another non-Latin language. For example, you can't search addresses in Arabic and get the verified output in Chinese. Both these languages are supported, but the transliteration between them isn't supported. For more information on this option, see the Search and Verify Address topic in the Related Topics section.

Note: For more information on address verification, see the Overview of the Address Verification Setup Process topic in the Related Topics section.