Re:Error - City does not exist in HR_US_GEOCODE_CITY - HandsonERP

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

	HandsonERP - Oracle E-Business Suite Training	Forum Flat View Rules

Welcome, Guest
Please Login or Register. Lost Password?

HandsonERP - Oracle E-Business Suite Training

HandsonERP.com Forum

Questions Related to Lessons Content

Re:Error - City does not exist in HR_US_GEOCODE_CITY (1 viewing) (1) Guest

Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.

Favoured: 0

TOPIC: Re:Error - City does not exist in HR_US_GEOCODE_CITY

Forum Tools

#1623

handsonerp (Admin)

Admin

Posts: 1989

Re:Error - City does not exist in HR_US_GEOCODE_CITY 13 Years, 3 Months ago

In 12.1.3 address format and Validation Changes were introduced along with Bug 9871990.

12.1.3 onwards Oracle Legal Entity Configurator has adopted HR Address formatting and validation model.

In earlier versions, the formatting and validation were based on HZ_LOCATIONS validation from TCA (stored in HR_LOCATIONS_ALL).

You must be on shared Iinstall for HRMS application. Location information is only available for customers implementing Oracle HRMS.

Before creating a Legal Address make sure that the format specified matches the format desired by your organization.

Update the following Flexfield:
Application: Human Resources
Title: Location Address

Remove the Valueset Validation and make it NOT Required field.

Following fields were updated.
4. City -> HR_US_GEOCODE_CITY
5. State -> HR_US_GEOCODE_STATE
7. County -> HR_US_GEOCODE_COUNTY

After these changes you should be able to create new Legal Entities.

Report to moderator Logged