Edit Alternative Names and Codes for an Existing Country

You can add or edit alternative names and codes for an existing geography in the geography hierarchy.

For example, you can add a FIPS code of 06 for the state of California.

  1. Click Navigator > My Enterprise > Setup and Maintenance work area.
  2. Click the Tasks menu and click Search. Search for Manage Geographies.
  3. On the Manage Geographies page, enter US in the Code field. Click Search.
  4. Click Hierarchy Defined for United States.
    Note: If there are many child geographies for the selected parent geography, a message asking you to refine the search criteria is displayed. The child geographies are displayed after you refine the search criteria. If there are many search results, you may have to further refine the search criteria. The maximum number of child geographies that can be displayed is controlled by the ORA_HZ_GEO_HIERARCHY_LIMIT profile option. You can change the value of this profile option by navigating to the Setup and Maintenance work area, click the Tasks menu, and search for Manage Administrative Profile Values task. Search for the ORA_HZ_GEO_HIERARCHY_LIMIT profile option and change the value.
  5. Search using State as the Geography Type and CA as the Code.
  6. Select CA and click Actions > Edit.
  7. In the Primary and Alternative Codes section, click Actions > Add.
  8. Type 06 under Code and select FIPS code as the Code Type.
  9. Click Save and Close.
  10. Click Save and Close.
  11. Click Done.