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
Welcome, Guest
Please Login or Register.    Lost Password?
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.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Error - City does not exist in HR_US_GEOCODE_CITY
#1623
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Error - City does not exist in HR_US_GEOCODE_CITY 8 Years, 8 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 Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Error - City does not exist in HR_US_GEOCODE_CITY
arun 2011/01/20 08:42
    thread link
thread linkthread link Re:Error - City does not exist in HR_US_GEOCODE_CITY
handsonerp 2011/01/22 12:41
    thread link
thread linkthread linkthread link Re:Error - City does not exist in HR_US_GEOCODE_CITY
arun 2011/01/22 22:20
    thread link
thread linkthread linkthread linkthread link Re:Error - City does not exist in HR_US_GEOCODE_CITY
handsonerp 2011/01/25 08:16
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop