My Oracle Support Banner

Mass Remove Invalid City Data (Doc ID 2739005.1)

Last updated on DECEMBER 09, 2022

Applies to:

Oracle HRMS (US) - Version 12.2 HRMS RUP14 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Requested a script to identify and mass remove invalid city, zip code combinations within the Oracle EBS Payroll application

EXPECTED BEHAVIOR
-----------------------
Need automated method as identified in the enhancement 24657926 - GEO19:121:Cleanup of Old Vertex Non Supported Geocode Data with similar requirement to clean the old city and zipcode data that are currently not supported by Vertex

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When navigating to the Employee's address form
2. Click on the list of values and confirm invalid City and zip codes
3. Requested automated, mass script to correct the invalid combinations

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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