How do I add a geography to the geography hierarchy?

You can add a new geography to the geography hierarchy. The new geography can be added under any level of the hierarchy for an existing geography type in the country geography structure.

For example, we can add a new postal code 94065 under United State, California, San Mateo, Redwood 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. Drill down to San Mateo and select Redwood City.
7. Click Actions > Create.
8. Type 94065 for Name in the Primary Name and Alternative Names section.
9. Click Save and Close.
10. Click Save and Close.
11. Click Done.