Real-Time Address Validation

Real-time address validation validates addresses during address entry. For Oracle Trading Community Architecture, and other Oracle E-Business Suite applications, this validation is based on the information and setup of Geography Hierarchy. See: Geography Hierarchy Overview.

Note: Real-time address validation is performed only for addresses created in the HZ_LOCATIONS table and countries that are set up in Geography Hierarchy.

If Flexible Address Formatting is also set up, then you first use this feature when you enter an address. See: Address Formatting. When you try to save the address, you then go through the real-time address validation process.

Address Entry and Real-Time Validation Process

  1. In the address entry UI, you select a country. Available countries are from the FND_TERRITORIES table.

  2. If Flexible Address Formatting is set up, then address elements are displayed and possibly validated based on the address style defined for the selected country. See: Address Entry and Formatting Process.

  3. Enter address information and attempt to save your address.

    Note: To display an asterisk for mandatory fields in the Address page, you must define these fields as mandatory in FAF and address validation, if both are used.

    1. Address validation automatically completes addresses when you enter enough address elements to uniquely determine other address information. For example, you enter a zip code for a US address, and the application automatically fills in the corresponding city and state, based on Geography Hierarchy data.

    2. If a unique match is not found, then real-time address validation can also provide valid, suggested address elements for you to choose from. For example, if you select United States as the country, and San Francisco as the city, then the application can provide valid state, county, and city combinations, which come from the Geography Hierarchy setup.setup If the HZ: Validate First 5 Digits of US ZIP Code profile option is set to Yes, or you have not specified a value for the profile, and you enter more than five digits for a US ZIP code, then only the first five digits are validated against the Geography repository. If the first five digits are valid according to the HZ_GEOGRAPHIES, then the 5-digit ZIP code is displayed in the list of suggestions in the - State, County, City, and ZIP Code format. If the first five digits of the US ZIP code are valid, then the remaining digits after the fifth digit are stored in the ZIP+4 format.

    3. The address is validated and accordingly saved, or not, based on the geography validation level set up for the country.

      • Error: Only completely valid addresses can be saved. If there are multiple valid combinations, you can select from the displayed suggestions.

      • Warning: Invalid addresses can be saved after issuing you a warning, but you must enter all mandatory address elements, as defined in Geography Hierarchy setup. If there are multiple valid combinations, you can select from the displayed suggestions.

      • Mandatory Fields Only: Invalid addresses can be saved without warning, but you must enter all mandatory address elements, as defined in Geography Hierarchy setup.

      • No Validation: All addresses can be saved.

Related Topics