🇺🇸 US Address Validation Strategy – Oracle Fusion HCM

-

 

1️⃣ Enable – Activate Full Address Verification

Navigation:

Setup and Maintenance → Features by Country or Territory → United States

Set:

Address Validation Method = Full Address Verification Service

If the field is not available:

Run:

Run Feature Upgrade

  • Do NOT select LDG

  • Feature: Enable Enhanced Address Validation for US

Then run:

Load Geographies for US

This installs the updated Oracle geography dataset.

🔎 What Does Enabling This Feature Do?

It enhances the HCM address framework by:

  • Updating address components in HR flows and address maintenance UI

  • Enabling:

    • Address search in UI

    • Address verification in UI

    • Address verification via HDL

    • Address validation flows

  • Loading updated US geography data

  • Enabling geospatial coordinate capture

In short: it activates USPS-based intelligent validation across the system.

2️⃣ Prepare – Run Address Validation Process (Draft Mode)

Navigation:

My Client Groups → Submit Flow → Address Validation Process

Required Parameters:

ParameterValue
Verification StatusUnverified
TypeLocation, Person
ModeDraft

Optional Parameters:

  • Modified Address Date (From / To)

  • Person

  • Location

  • Payroll Relationship Group

🔎 What Does the Draft Mode Do?

In default mode, the process:

  • Picks up all Unverified addresses

  • That are active on or after Jan 1 of the current year

  • Runs USPS verification

  • Generates a validation output report

  • Does NOT commit changes

This allows review before system updates anything.

⚠ Important:
Once run in Final mode, addresses are no longer “Unverified” and will not be reprocessed using default parameters.

3️⃣ Validate – Review Validation Report

After Draft process completion:

Download and review the Address Validation Report

Use the Validation Status Codes column to filter records.

🚨 Error Codes (Must Fix)

Codes starting with:

HRX_US_AE%

These represent address errors, such as:

  • Missing premise number

  • Missing street name

  • Invalid city/state/ZIP

  • USPS rejected address

These addresses must be corrected in the application before proceeding.

Examples you should NOT leave unresolved:

  • HRX_US_AE01

  • HRX_US_AE02

  • HRX_US_AE03

  • HRX_US_AE05

  • HRX_US_AE07

  • HRX_US_AE10

  • HRX_US_AE11

✅ Validation Status Codes

Codes starting with:

HRX_US_AV%

These indicate validation quality:

  • Full match

  • Partial match

  • ZIP-level match

  • Corrected address suggestion

These are informational but should be reviewed carefully.

4️⃣ Cleanse – Correct and Reprocess

Steps:

  1. Correct invalid addresses in:

    • Person records

    • Location records

  2. Re-run Address Validation Process in Draft mode

  3. Ensure no AE-type errors remain

  4. Run process in:

Final Mode

🔎 What Final Mode Does

  • Commits validated addresses

  • Updates validation status

  • Stores geospatial coordinates

  • Marks addresses as verified

  • Prevents reprocessing under default parameters

This finalizes your address database.

📌 Special USPS ZIP Code Note

Some ZIP codes are assigned to:

  • Universities

  • Large corporations

  • Government entities

These have:

PostalCode Type = U (Unique)

In such cases:

  • Address Line 1 or 2 may be ignored during USPS validation

  • Validation may still succeed despite limited detail


Comments

Post a Comment

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

CAPTCHA IMAGE GENERATION IN OAF PAGE

-
Image
THE DOCUMENT DESCRIBES HOW TO CREATE CAPTCHA IMAGE IN OAF PAGE: Step 1: get captcha: // to get the captchaImage Field in OAF page(code to be written in controller)=>     OAImageBean captchaImage = (OAImageBean)webBean.findIndexedChildRecursive("CaptchaImageField");     captchaImage.setSource("captchaservlet"); Step 2: Creation of captcha servlet: Step 3:  captchaservlet code to generate captcha image: import com.sun.java.util.collections.Random; import java.awt.Color; import java.awt.Font; import java.awt.Graphics2D; import java.awt.image.BufferedImage; import java.io.IOException; import java.io.OutputStream; import javax.imageio.ImageIO; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.awt.GradientPaint; import java.awt.RenderingHints;   public class CaptchaServlet ex...
Read more

Oracle Fusion HCM :: Creating and Assigning a Work Schedule Activity

-
A  Work Schedule Activity  defines a recurring period of work for employees, including hours, shifts, and work patterns. Assigning it ensures correct time, absence, and payroll calculations. 1. Navigate to Work Schedule Activities Login to  Oracle HCM Cloud . Navigate to: My Client Groups → Work Structures → Work Schedules → Work Schedule Activities Click  Tasks → Manage Work Schedule Activities . 2. Create a New Work Schedule Activity Click  Create . Enter the following details: Name : Descriptive name for the activity (e.g., “Regular Shift”). Code : Short identifier. Description : Optional, e.g., “Standard office hours 9 AM – 5 PM.” Assignment Type : Select  Full-Time ,  Part-Time , or other relevant type. Work Hours : Specify start time, end time, and duration. Frequency : Daily, weekly, or custom recurrence pattern. Time Zone : If your enterprise spans multiple regions. Optionally, define  Breaks : Break name, start, duration, and whether it’s...
Read more