Edit a Specific Geography in the Geography Hierarchy

You can edit the following details of a geography hierarchy using the Manage Geography Hierarchy page:
  • geography's date range
  • primary and alternate names
  • primary and alternate codes
  • creating geographies within the hierarchy such as adding a postal code for a city.
  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. (Optional) Select the row that you want to specify as the primary name under the Primary and Alternative Names section and click Actions > Set Primary.
  8. (Optional) Select the row that you want to specify as the primary code under the Primary and Alternative Codes section and click Actions > Set Primary.
  9. Click Save and Close.
  10. Click Save and Close.
  11. Click Done.