1. How do I configure addresses for the US?
  2. How do I preserve Secondary Address Information in my validated addresses?

How do I preserve Secondary Address Information in my validated addresses?

The US Postal Service (USPS) maintains the data set that determines the valid US address format. The USPS refers to any content outside this dataset as Secondary Address Information. Oracle's address verification processes automatically strip any Secondary Address Information from addresses.

Oracle's address verification process standardizes an address's Line 1 and Line 2 against the USPS address data set. As part of this process, it removes any Secondary Address Information you may have entered, such as internal-use or nonaddress-related info.

To preserve this address info from the verification processes, enter it in ADDRESS_LINE3.

Note:

Oracle HCM payroll and reporting processes ignore any info in ADDRESS_LINE_3.

Oracle HCM uses these attributes to capture and validate address info.

  • ADDRESS_LINE_1

  • ADDRESS_LINE_2

  • TOWN_OR_CITY

  • ADDL_ADDRESS_ATTRIBUTE4

  • REGION_1

  • REGION_2

  • POSTAL_CODE

  • LONG_POSTAL_CODE

  • COUNTRY

  • LONGITUDE

  • LATITUDE

  • VALIDATION_STATUS_CODES

  • PROVIDER