Suggestions On How To Improve Address Data Quality (Doc ID 2554942.1)

Last updated on JANUARY 25, 2024

Applies to:

Goal

The following suggestions have been provided to add new or enhance the value of existing Address Verification functionality:

Verbatim:
- Add verification to compare the entered value for an address field to the city field on the same page. matches the city field is an error (case insensitive and city has value)
- An address field that matches the postal code field is an error (case insensitive ignoring spaces and postal code has value)
- An address field that matches the state field (or the corresponding description) is an error (case insensitive and state has value)
- An address field that matches the country field (or the corresponding description) is an error (case insensitive and country has value) with exceptions for city states, e.g. Singapore.
- A blank address field before one that has a value is an error. Alternately, have code shift data 'up' (e.g. address2 -> address1)

Comments:
- Compare the entered value in an Address field to the entered value in a corresponding City or Postal Code on the same page/form. Determine that there is an error if there is a match or predetermined level of similarity between the values.
- Compare the entered value in an Address field to the entered value in a State or Country field on the same page/form. With special exception rules in place to handle cases such as Singapore, determine that there is an error if there is a match or predetermined level of similarity between the values
- In cases where Address Line 1 is empty and Address Line 2 has a value, determine that there is an error or move the entered value from Address Line 2 to Address Line 1 before saving.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.