2Setting Up Geographical Information
Importing Geographies
Use the Manage Geographies task to import geographical information.
The Manage Geographies task of the Agency Profile functional area in Oracle Functional Setup Manager enables you to import geographies into your interface tables. For detailed instructions on importing geographies, see How You Import Geographies.
Importing geographies automatically populates data for the following tasks:
Manage Countries (Setting Up Counties)
Manage States (Setting Up States)
Manage Counties (Setting Up Counties)
Manage Cities (Setting Up Cities)
Manage Public Sector Currencies (Setting Up Currencies)
Setting Up Countries
A country definition includes the country name and various identifying codes.
You add, modify, and delete countries on the Country page.
Adding a Country
Select
.On the Country page, click Add.
On the Country Details page, enter values for the following fields:
Page Element
Description
Country Code
Enter a the unique code that your system uses for the country. For example, you might enter FRA for France.
ISO Alpha 2 Code
Enter the two-letter International Organization of Standardization (ISO) code for the country. For example, you would enter FR as the code for France.
ISO Numeric 3 Code
Enter the three-digit United Nations (UN) M.49 code for the country. For example, you would enter 250 as the code for France.
Country Name
Enter the name of the country as it appears in your system.
Click Save.
Modifying a Country
Select
.Click a row on the Country page.
On the Country Details page you can:
Update the country field values.
Note: You cannot edit the Country Code.Delete the country. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting Countries
Select
.Click Edit.
Select the check boxes next to all the countries you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.
Setting Up States
A state definition includes information such as the state name, country, and various ID codes.
You add, modify, and delete states on the State page.
Adding a State
Select
.On the State page, click Add.
On the State Details page, enter values for the following fields:
Page Element
Description
Country
Enter the code for the country that the state is in.
State Code ISO
Enter the International Organization of Standardization (ISO) code for the state.
Code
Enter the unique code that your system uses for the state.
State Name
Enter the name of the state.
Type
Enter the subdivision type.GNIS ID
Enter the Geographic Names Information System (GNIS) ID for the state’s location.
Click Save.
Modifying a State
Select
.Click a row on the State page.
On the State Details page you can:
Update the state field values.
Note: You cannot edit the Country or State Code ISO fields.Delete the state. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting States
Select
.Click Edit.
Select the check boxes next to all the states you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.
Setting Up Cities
A city definition includes information such as the city name, country, state, and certain ID codes.
You add, modify, and delete cities on the City page.
Adding a City
Select
.On the City page, click Add.
On the City Details page, enter values for the following fields:
Page Element
Description
Country Code and State Code
Enter the codes for the country and state in which the city is located.
County
Enter the five-digit International Committee for Information Technology Standards (INCITS) code for the county in which the city is located.
FIPS Code
Enter the seven-digit Federal Information Processing Standard (FIPS) code for the city.
City Name
Enter the name of the city.
GNIS ID
Enter the Geographic Names Information System (GNIS) ID for the city’s location.
Click Save.
Modifying a City
Select
.Click a row on the City page.
On the City Details page you can:
Update the city field values.
Note: You cannot edit the Country Code, State Code, or County fields.Delete the city. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting Cities
Select
.Click Edit.
Select the check boxes next to all the cities you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.
Setting Up Counties
A county definition includes information such as the county name, country, state, and certain ID codes.
You add, modify, and delete counties on the County page.
Adding a County
Select
.On the County page, click Add.
On the County Details page, enter values for the following fields:
Page Element
Description
Country and State
Enter the codes for the country and state that the county is in.
INCITS Code
Enter the five-digit International Committee for Information Technology Standards (INCITS) code for the county.
County Name
Enter the name of the county.
FIPS Code
Enter the seven-digit Federal Information Processing Standard (FIPS) code for the county.
GNIS ID
Enter the Geographic Names Information System (GNIS) ID for the county’s location.
Click Save.
Modifying a County
Select
.Click a row on the County page.
On the County Details page you can:
Update the county field values.
Note: You cannot edit the Country, State, or INCITS Code fields.Delete the county. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting Counties
Select
.Click Edit.
Select the check boxes next to all the counties you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.
Setting Up Currencies
A currency definition includes currency codes, a description, and the number of decimals that can be used to represent an amount in the currency.
You add, modify, and delete currencies on the Currency page.
Adding a Currency
Select
.On the Currency page, click Add.
On the Currency Details page, enter values for the following fields:
Page Element
Description
Currency Code
Enter a the unique code that your system uses for the currency.
ISO Code
Enter the three-digit International Organization of Standardization (ISO) 4217 numeric code for the currency. For example, you would enter 840 for the US dollar.
Description
Enter a short description of the currency.
Decimal Position
Enter the number of decimal places that can be used to represent an amount for the currency. For example, the United States dollar uses two decimal positions.
Click Save.
Modifying a Currency
Select
.Click a row on the Currency page.
On the Currency Details page you can:
Update the currency field values.
Note: You cannot edit the Currency Code field.Delete the currency. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting Currencies
Select
.Click Edit.
Select the check boxes next to all the currencies you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.