File-Based Address Validation Process

Use the File-Based Address Validation process to validate your employee or location addresses using an offline copy of your addresses data. It is most useful for validating addresses from a legacy application before you load them into Oracle Fusion Human Capital Management.

Note:

This process doesn’t update the addresses in the Oracle application. After using this process to validate your addresses, create your own HCM Data Loader (HDL) file and upload them into Oracle.

The HDL upload process performs its own address validation on the data file. Since you’re using validated data from the file-based address validation process, be sure to disable HDL validation before you perform the upload.

To run this process:

From My Client Groups, click Payroll.
Click Submit a Flow.
Select your US legislative data group (LDG).
Search for and select File-Based Address Validation.

Before you start

Prepare an input file in CSV format with these columns in this order.

Address Line 1
Address Line 2
City
County
State
ZIP Code
Additional Details

This column is for notes or address identifiers to help you track this info. It isn't used in address validation.

Process parameters

Upload File

Click to select and upload your CSV file.

Content ID

After you select and upload your CSV file, this read-only field displays your UCM ID.

Process output

This process produces an output file suitable for viewing in a spreadsheet application, such as Microsoft Excel. Use this report to identify invalid address combinations, so you can correct the input source and resubmit those addresses.

Once verified, upload the addresses into Oracle HCM using HCM Data Loader (HDL). Before you do, disable HDL’s address verification to avoid reprocessing your addresses.

Section	Columns and descriptions
Address	Describes the address data you provided as input into the flow. It includes: Address Line 1 Address Line 2 City County State ZIP Code Additional Details This is the additional info you provided in the upload file.
Validation Details	Address data after it has been verified with suggested changes. It includes: Address Line 1 Includes the premises number, such as house or building, followed by the street name. Address Line 2 Includes premise unit numbers like suite or apartment. City County State ZIP Code ZIP + 4 Longitude Latitude Validation Status Codes These codes are captured in backend address table along with other address attributes. Validation Status Messages These messages describe the codes returned by the flow. It doesn't store them in the backend address table.

Section

Columns and descriptions

Address

Describes the address data you provided as input into the flow. It includes:

Address Line 1
Address Line 2
City
County
State
ZIP Code
Additional Details

This is the additional info you provided in the upload file.

Validation Details

Address data after it has been verified with suggested changes. It includes:

Address Line 1

Includes the premises number, such as house or building, followed by the street name.
Address Line 2

Includes premise unit numbers like suite or apartment.
City
County
State
ZIP Code
ZIP + 4
Longitude
Latitude
Validation Status Codes

These codes are captured in backend address table along with other address attributes.
Validation Status Messages

These messages describe the codes returned by the flow. It doesn't store them in the backend address table.