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

1. Select Common Setup > Country.

2. On the Country page, click Add.

3. 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.

4. Click Save.

Modifying a Country

1. Select Common Setup > Country.

2. Click a row on the Country page.

3. 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.

4. Click Save.

Deleting Countries

1. Select Common Setup > Country.

2. Click Edit.

3. Select the check boxes next to all the countries you want to delete.

4. 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

1. Select Common Setup > State.

2. On the State page, click Add.

3. 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.

4. Click Save.

Modifying a State

1. Select Common Setup > State.

2. Click a row on the State page.

3. 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.

4. Click Save.

Deleting States

1. Select Common Setup > State.

2. Click Edit.

3. Select the check boxes next to all the states you want to delete.

4. 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

1. Select Common Setup > City.

2. On the City page, click Add.

3. 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.

4. Click Save.

Modifying a City

1. Select Common Setup > City.

2. Click a row on the City page.

3. 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.

4. Click Save.

Deleting Cities

1. Select Common Setup > City.

2. Click Edit.

3. Select the check boxes next to all the cities you want to delete.

4. 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

1. Select Common Setup > County.

2. On the County page, click Add.

3. 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.

4. Click Save.

Modifying a County

1. Select Common Setup > County.

2. Click a row on the County page.

3. 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.

4. Click Save.

Deleting Counties

1. Select Common Setup > County.

2. Click Edit.

3. Select the check boxes next to all the counties you want to delete.

4. 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

1. Select Common Setup > Currency.

2. On the Currency page, click Add.

3. 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.

4. Click Save.

Modifying a Currency

1. Select Common Setup > Currency.

2. Click a row on the Currency page.

3. 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.

4. Click Save.

Deleting Currencies

1. Select Common Setup > Currency.

2. Click Edit.

3. Select the check boxes next to all the currencies you want to delete.

4. Click Delete. You will be prompted to confirm the permanent deletion.