5Geographies

This chapter contains the following:

Overview of Geographies

Overview of Geographies, Geographic Entities, and Locations

Geography is a physical space on Earth, such as a location or region, that's defined by a boundary. For example, it maybe existing geopolitical locations such as San Jose or Peru. These geographical locations are used in applications to manage business requirements such as sales territories, transportation deliveries, taxation, logistics, and so on. Specifying the purpose and use of these geographies is known as Geography Use.

Geography Type

A divisional grouping of geographies is named as Geography Types. It could be a geopolitical division such as Country, First Order Administrative Divisions (State, Province, District, and so on), City, Town, Village, or Non-Administrative Divisions (Southwest Florida, Northern California, and so on) or physical geographic divisions such as Island, Continent, Mountain, and so on.

Geography Hierarchy

Geography Hierarchy lets you establish parent-child relationships between geography types.

At the highest level of the geography hierarchy is country, which is the parent, and the hierarchy contains several child geographies. The following table shows sample parent-child relationships in a geography.

California Parent of San Mateo county

San Mateo County

Parent of Redwood City

Redwood City

Parent of 94065

94065

Child

The state of California is defined as the parent of San Mateo county, which is the parent of Redwood City, which is the parent of the postal code 94065. If you enter 94065, the application can determine that the postal code is in California, or that the corresponding city is Redwood City.

Note: The application doesn't provide seeded geography information. It only provides a means to setup the data model and to store geographical information.

Geography hierarchies can be:

  • Master Reference Geography Hierarchy: This refers to the predefined geography hierarchy and is considered as the source of truth. It is defined by widely recognized administrative or political boundaries such as States, Provinces, Counties, Cities, and so on. This hierarchy can be obtained from a supplier or manually entered. This geography hierarchy is the source when validating addresses or importing data. Examples are the State of California, the Province of Alberta, The Country of India, and so on.

  • User Defined Geography Hierarchy: This refers to geography hierarchy defined by the user. This geography hierarchy may be created using the Master Reference Geography, obtained from a supplier, or entered manually. A user-defined geography hierarchy can have:

    • Zones: User-defined geographical boundaries for the specific geography usage, based on Master Reference Geography Hierarchy data. For example, a Tax geography usage can have the San Jose Tax zone, and a Sales geography usage the Southwest Sales Region zone. The boundaries of the Southwest Sales Region zone would enclose various master reference states, for example California, Arizona, Nevada, Utah, and New Mexico.

    • Zone Type: A layer or grouping of zones, for example, Income Tax and Sales Regions zone types. The Sales Regions zone type would contain zones such as Southwest Sales Region, Midwest Sales Region, and so on.

Geography Name Referencing

Geography Name Referencing is the process of validating and mapping address elements of existing location table records against master reference geographies. For example, CA value in the STATE column of the HZ_LOCATIONS table is mapped to the master reference geography of CA.

There are three components that are dependent on each other when defining a country: geography structure, geography hierarchy, and geography validation. Every country has to have the geography structure defined first before the hierarchy can be defined, and the geography hierarchy has to be defined before the validation can be defined.

Geography Structure

Firstly, you need to create a geography structure for each country to define which geography types are part of the country structure, and how the geography types are hierarchically related within the country structure. For example, you can create geography types called State, City, and Postal Code. Then you can rank the State geography type as the highest level within the country, the City as the second level, and the Postal Code as the lowest level within the country structure. Geography structure can be defined using the Manage Geographies task, or can be imported using tasks in the Define Geographies activity.

Geography Hierarchy

Once the geography structure is defined, the geographies for each geography type can be added to the hierarchy. For example, in the hierarchy of United States you can create a geography called California using a State geography type.

As part of managing the geography hierarchy you can view, create, edit, and delete the geographies for each geography type in the country structure. You can also add a primary and alternate name and code for each geography. A geography hierarchy can be created using the Manage Geographies task, or can be imported using tasks in the Define Geographies activity.

Geography Validation

After defining the geography hierarchy, you need to specify the geography validations for the country. You can choose which address style format you would like to use for the country, and for each selected address style format you can map geography types to address attributes. You can also select which geography types to include in geography or tax validation, and which geography types will display in a list of values during address entry in other user interfaces. The geography validation level for the country, such as error or warning, can also be selected.

This topic describes geography structures and the tasks you can perform using geography structures.

A geography structure is a hierarchical grouping of geography types for a country. The following table describes the geography structure for the United States.

Level Geography Type

1

State

2

County

3

City

4

Postal Code

You can use the geography structure to relate geography types for a country and define geography types for a country.

Relate Geography Types for a Country

You can determine how a country's geographies are hierarchically related by creating the hierarchy of the geography types in the geography structure. When you define a country's structure, the geography type Country is implicitly at the highest level of the geography structure with level as 1. The subsequent geography types that you add after country are numbered in sequence.

You must add a geography type as a level in the country structure before you can define a geography for that geography type in a country. For example, before defining the state of California, the State geography type must be added to the United States country structure. To quickly create country structure, you can copy a structure from another country and modify the geography types for the country.

Define Geography Types for a Country

You can use any of the master reference geography types to create your geography structure. If required, you can create a geography type, before adding it to the country structure. Each geography type is added at a lower level to the current lowest level.

Note: You can't delete geography types that have associated geography data. You can only delete the lowest level geography type of the country structure.

You can use a geography type that you create within the country structure for other country structures as well.

Geography hierarchy is a data model that creates conceptual parent-child relationships between geographies.

The application uses geography hierarchy information to facilitate business processes that rely on geography information, such as, tax calculation, order sourcing rules, and sales territory definition. The geography hierarchy information is centrally located and shared among other application offerings.

The geography hierarchy includes geography, geography type, geography usage, master reference geography hierarchy and user defined zones.

Geography validation determines the geography mapping and validation for a country's address styles, as well as the overall geography validation control for a country.

The No Styles Format address style format is the default address style format for a country. By defining the mapping and validation for this format you will ensure that validations can be performed for any address in the country. After the No Styles Format is defined you can set up additional mapping for specific address styles.

For each address style format, you can define the following:

  • Map to attribute

  • Enable list of values

  • Tax validation

  • Geography validation

  • Geography validation control

Attribute Mapping

For every address style format, you can map each geography type to an address attribute. For example, you can map the State geography type to the State address attribute for the United States, or map the State geography type to the County address attribute for the United Kingdom. The geography types that appear are based on how the country structure is defined. The list of address attributes that appear are based on address formats delivered with the application, or your customer defined address formats.

Note: You only need to map geography types that you want to use for geography or tax validation purposes.

Enable List of Values

Once a geography type is mapped to an attribute, then you can specify whether the geography type will appear in a list of values during address entry in user interfaces. It is very important to review carefully if you want to enable a list of values. You should only enable a list of values if you have sufficient geography data imported or created for that geography. If the setup for master geography data is incomplete, then the geography data is either not imported or created. As a result, the list of values for the address attribute doesn't list any geography data.

Once you have enabled a list of values for an address attribute, you can only select the geography data available for the geography type. This means that if a specific geography value isn't available in the geography hierarchy, you can't create an address with a different geography value.

Tax Validation

You can also specify whether a geography type will be included in tax validation. For example, for the United States North America address style format you specify that County, State, and City are used for tax validation. This will mean that when a transaction involves an address with the North America address style, the address must have the correct county, state, and city combination based on the geography hierarchy data, to be considered valid for tax calculation.

Geography Validation

You must set up geography validation for those geography elements that you plan to use in your sales territories. Setting up validation also helps users fill in missing address information, and validate addresses during entry. For example, you can have users select states or other address elements from lists to ensure accuracy during entry, and you can have the application fill in missing values. For example, when the user enters a Postal Code, the application can retrieve the city and state.

You can specify whether a geography type will be included in geography validation. For example, when the user enters a United States address using the North America address style format, the address must have the correct country, state, and postal code combination based on geography hierarchy data to be considered geographically valid.

If an address element is mapped to a geography type, but not selected for geography validation usage, then during address entry suggested values are provided for the address element, but the address element isn't be validated.

You need to verify that the default mapping between Geography Type and Map to Attribute is valid in the Geography Mapping and Validation region and update it if required when you define geography validation. Oracle recommends that you use the following valid mapping for the countries that GBG | Loqate supports:

Country Name Country Code Geography Type Map to Attribute

Andorra

AD

  • Country

  • Parroqia

  • Settlement

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Angola

AO

  • Country

  • Provincia

  • Municipio

  • Comuna

  • Localidad

  • Country

  • Province

  • County

  • City

  • Additional address attribute 2

Argentina

AR

  • Country

  • Province

  • Department

  • Municipality

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Australia

AU

  • Country

  • State

  • City

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Austria

AT

  • Country

  • Bundensland

  • Bezirk

  • Gemeinde

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Bangladesh

BD

  • Country

  • Bibhag

  • Anchal

  • Zila

  • Thana

  • Postal Code

  • Country

  • State

  • County

  • City

  • Additional address attribute 2

  • Postal code

Belgium

BE

  • Country

  • Gewest

  • Provincie

  • Gemeente

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • City

  • Postal code

Bolivia

BO

  • Country

  • Departmento

  • Provincia

  • Canton

  • Country

  • Additional address attribute 1

  • Province

  • City

Bosnia and Herzegovina

BA

  • Country

  • District

  • Kanton

  • Opcine

  • Nasalje

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • County

  • City

  • Postal code

Brazil

BR

  • Country

  • State

  • City

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Bulgaria

BG

  • Country

  • Oblast

  • Obshhina

  • Settlement

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • City

  • Postal code

Canada

CA

  • Country

  • Province

  • City

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Cayman Islands

KY

  • Country

  • Island

  • District

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Chile

CL

  • Country

  • Region

  • Provincia

  • Kommune

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

China

CN

  • Country

  • Province

  • City

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Croatia

HR

  • Country

  • Zupanije

  • Grad

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Cuba

CU

  • Country

  • Provincia

  • Municipio

  • City

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Cyprus

CY

  • Country

  • Periochi

  • Dimos

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Czech Republic

CZ

  • Country

  • Kraj

  • Okres

  • Obec

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Denmark

DK

  • Country

  • Amt

  • Settlement

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Dominican Republic

DO

  • Country

  • Provincia

  • Municipio

  • Town

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Ecuador

EC

  • Country

  • Province

  • Canton

  • City

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Estonia

EE

  • Country

  • Maakond

  • Vald

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Finland

FI

  • Country

  • Laani

  • Kunta

  • Postal Code

  • Country

  • State

  • City

  • Postal code

France

FR

  • Country

  • Region

  • Department

  • Commune

  • Postal Code

  • Country

  • Additional address attribute 1

  • State

  • City

  • Postal code

Germany

DE

  • Country

  • Bundesland

  • Kreis

  • Gemeinde

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Great Britain

GB

  • Country

  • County

  • Township

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Greece

GR

  • Country

  • Periferia

  • Nomi

  • Dimotika

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Guadalupe

GP

  • Country

  • Commune

  • Postal Code

  • Country

  • City

  • Postal code

Guam

GU

  • Country

  • State

  • County

  • Municipality

  • Village

  • Postal Code

  • Country

  • State

  • County

  • City

  • Additional address attribute 2

  • Postal code

Guernsey

GG

  • Country

  • City

  • Parishes

  • Villages

  • Postal Code

  • Country

  • City

  • Additional address attribute 2

  • Additional address attribute 3

  • Postal Code

Hungary

HU

  • Country

  • Megye

  • Jaras

  • Telepules

  • Settlement

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • County

  • City

  • Postal code

Iceland

IS

  • Country

  • Jaras

  • Telepules

  • Settlement

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

India

IN

  • Country

  • State

  • City

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Indonesia

ID

  • Country

  • Province

  • Regency

  • City

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Ireland

IE

  • Country

  • Province

  • Post County

  • Post Town

  • Locality

  • Country

  • Additional address attribute 1

  • State

  • City

  • Additional address attribute 2

Isles of Man

IM

  • Country

  • Locality

  • Settlement

  • Postal Code

  • Country

  • City

  • Additional address attribute 2

  • Postal code

Israel

IL

  • Country

  • District

  • Subdistrict

  • City

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Italy

IT

  • Country

  • Regione

  • Provincia

  • Comune

  • Postal code

  • Country

  • Additional address attribute 1

  • Province

  • City

  • Postal code

Jamaica

JM

  • Country

  • Parish

  • Settlement

  • Country

  • State

  • City

Japan

JP

  • Country

  • Prefecture

  • City

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Jordan

JO

  • Country

  • Muhafazat

  • Liwa

  • Tajma

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Kenya

KE

  • Country

  • County

  • Division

  • Settlement

  • Country

  • State

  • City

  • Additional address attribute 2

Latvia

LV

  • Country

  • Rajons

  • Pilseta

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Liechtenstein

LI

  • Country

  • Wahlkreis

  • Gemeinde

  • District

  • Postal Code

  • Country

  • Additional address attribute 1

  • State

  • City

  • Postal code

Lithuania

LT

  • Country

  • County

  • Municipality

  • Ward

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Luxembourg

LU

  • Country

  • District

  • Canton

  • Commune

  • Settlement

  • Postal Code

  • Country

  • Additional address attribute 1

  • State

  • County

  • City

  • Postal code

Malaysia

MY

  • Country

  • State

  • District

  • Subdistrict

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Malta

MT

  • Country

  • Region

  • Local Council

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Martinique

MQ

  • Country

  • Region

  • Department

  • Commune

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Mexico

MX

  • Country

  • State

  • Municipality

  • Locality

  • Postal Code

  • Country

  • State

  • County

  • Additional address attribute 2

  • Postal code

Netherlands

NL

  • Country

  • Province

  • Gemeente

  • Settlement

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

New Zealand

NZ

  • Country

  • Region

  • Town

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Norway

NO

  • Country

  • Fylke

  • Kommune

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Oman

OM

  • Country

  • Muhafazah

  • District

  • City

  • Country

  • State

  • County

  • City

Pakistan

PK

  • Country

  • Province

  • Division

  • District

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Peru

PE

  • Country

  • Region

  • Provincia

  • Distrito

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Philippines

PH

  • Country

  • Provincia

  • Distrito

  • Municipalidad

  • Barangay

  • Postal Code

  • Country

  • State

  • County

  • City

  • Additional adddress attribute 2

  • Postal code

Poland

PL

  • Country

  • Wojewodztwo

  • Powiat

  • Gmina

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Portugal

PT

  • Country

  • Distrito

  • Concelho

  • Settlement

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Puerto Rico

PR

  • Country

  • Commonwealth

  • Municipio

  • Barrio

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Qatar

QA

  • Country

  • Municipality

  • Zone

  • Country

  • State

  • City

Reunion Island

RE

  • Country

  • Region

  • Department

  • Commune

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Romania

RO

  • Country

  • Regiune

  • Judet

  • Settlement

  • Comuna

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • County

  • City

  • Postal code

Russia

RU

  • Country

  • Federal_District

  • Respublik

  • Kray

  • Oblast

  • Postal Code

  • Country

  • Additional address attribute 1

  • State

  • County

  • City

  • Postal code

San Marino

SM

  • Country

  • Comune

  • Postal Code

  • Country

  • State

  • Postal code

Singapore

SG

  • Country

  • Region

  • District

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Slovakia

SK

  • Country

  • Kraj

  • Okres

  • Obec

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Slovenia

SI

  • Country

  • Regija

  • Upravna Enota

  • Obcina

  • Settlement

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • County

  • City

  • Postal code

South Africa

ZA

  • Country

  • Province

  • District Municipality

  • Local Municipality

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

South Korea

KR

  • Country

  • Jibang

  • Siti

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Spain

ES

  • Country

  • Region

  • Department

  • Commune

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • City

  • Postal code

Sri Lanka

LK

  • Country

  • Province

  • District

  • Divisional Secretariat

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Swaziland

SZ

  • Country

  • District

  • Inkhundla

  • Town

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

Sweden

SE

  • Country

  • Lan

  • Settlement

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Switzerland

CH

  • Country

  • Kanton

  • Bezirk

  • Gemeinde

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Taiwan

TW

  • Country

  • County

  • Town

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Thailand

TH

  • Country

  • Region

  • Changwat

  • Amphoe

  • Postal Code

  • Country

  • Additional address attribute 1

  • State

  • City

  • Postal code

Tunisia

TN

  • Country

  • Governorate

  • Delegation

  • Postal Code

  • Country

  • State

  • City

  • Postal Code

Turkey

TR

  • Country

  • Sehir

  • Ilce

  • Kasaba

  • Postal Code

  • Country

  • Province

  • County

  • City

  • Postal code

United Arab Emirates

AE

  • Country

  • Emirate

  • City

  • Area

  • Country

  • State

  • City

  • Additional address attribute 2

United States

US

  • Country

  • State

  • County

  • City

  • Postal Code

  • Country

  • State

  • County

  • City

  • Postal code

Uruguay

UY

  • Country

  • Departamento

  • City

  • Postal Code

  • Country

  • State

  • City

  • Postal code

Vatican City

VA

  • Country

  • Municipal

  • Settlement

  • Postal Code

  • Country

  • Province

  • City

  • Postal code

Vietnam

VN

  • Country

  • Region

  • Tihn

  • Quan

  • Thank Pho

  • Postal Code

  • Country

  • Additional address attribute 1

  • Province

  • County

  • City

  • Postal code

Note: For either the tax or geography validation, don't skip more than one consecutive level unless you're certain that the selected geography types can uniquely identify geographies. For example, the United States country structure is: State, County, City, and Postal Code, and you want to select just State and Postal Code for geography or tax validation. However, for the combination of California and 94065, the city can be either Redwood Shores or Redwood City. In this case, you should also select at least the City geography type for geography or tax validation.

Geography Validation Control

You can select the geography validation level for a country. Validation will check if the entered address maps to the geography hierarchy data available for the country, and the geography validation control determines whether you can save an address that didn't pass validation during address entry. For example, if the validation level is Error, then an address can't be saved if the values don't match the geography hierarchy data.

These are the geography validation levels you can choose:

  • Error - only completely valid addresses can be saved, with all mandatory address elements entered.

  • No Validation - all addresses can be saved including incomplete and invalid addresses.

Regardless of the result of validation, the validation process will try to map any address attribute to a geography of the country, and store any mapping it could establish based on the available data. This is called Geography Name Referencing and it's executed as part of validation. The result of this referencing is used in several business processes in the application to map an address to a specific geography or zone.

The Geography Dimension value in territories is derived from sell-to addresses of sales accounts. To use geography dimensions in territories, you must validate the geography elements in the addresses, such as state, city, and postal code. You can validate the address by enabling geography validation for each country using the Manage Geographies task. Perform the following in the Manage Geographies task:

  • Enable at least one level in the geography hierarchy for geography validation.

  • Enable geography validation for all geography levels that you intend to use for territory definition for each country.

  • If needed, enable a list of values containing specific geography elements. This will help users search and select appropriate geography values during addresses entry and eliminate all possibilities of wrong address entry.

You can set geography validation control to Error in the Manage Geography Validation page. This ensures that users can only use valid geography elements in addresses.

Note: If you have already created addresses before setting up geography validation for a country, you must enable geography validation and then execute the Run Maintain Geography Name Referencing task for that country. This validates all your geography elements.

This example shows how you can configure the geography structure, hierarchy, and validation for a country geography, using the United Kingdom country geography as an illustration.

The following table summarizes the key decisions for this scenario.

Decisions to Consider In This Example

Copy an existing country structure?

No, create a new country structure.

What is the structure of the geography types?

Create geography types with the following ranking structure:

  1. County

  2. Post Town

What is the geography hierarchy?

Create the following hierarchy:

  1. Country of United Kingdom

  2. County of Berkshire

  3. Post Town of Reading

Which address style format will you use when mapping geography validations?

The default address style format called the No Styles Format.

Are you using Oracle Fusion Tax for tax purposes?

No, don't select Tax Validation for the geography types.

Define the Geography Structure

You can add the County and Post Town geography types to the United Kingdom geography structure.

  1. On the Manage Geographies page, enter GB in the Code field. Click Search.

  2. On the Manage Geographies page, click Structure Defined.

  3. On the Manage Geography Structure page, click the Create button next to the Copy Country Structure From field.

  4. In the Geography Structure section, select the County list item in the Add Geography Type field.

  5. Click Add.

  6. Select the Post Town list item in the Add Geography Type field.

  7. Click Add.

Define the Geography Hierarchy

You can add the geographies for the County and Post Town geography types using the geography hierarchy user interfaces to create the geography hierarchy for United Kingdom. You can also use Import Management to import geography hierarchies using a CSV or XML file.

  1. On the Manage Geographies page, enter GB in the Code field. Click Search.

  2. On the Manage Geographies page, click Hierarchy Defined.

    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.

  3. In the Geography Hierarchy section, click United Kingdom to highlight the table row, and click Create.

  4. In the Create County page, Primary and Alternate Names section, enter Berkshire in the Name field.

  5. Click Save and Close.

  6. In the Geography Hierarchy section, click Berkshire to highlight the table row, and click Create.

  7. In the Create Post Town page, Primary and Alternate Names section, enter Reading in the Name field.

  8. Click Save and Close.

Define the Geography Validations

You can define the geography mapping and validation for the United Kingdom default address style format to specify the geography validations for the geography types you added to United Kingdom. You can then map the geography types to attributes, enable the geography types for Lists of Values and Geography Validation, and set the geography validation level.

  1. On the Manage Geographies page, click Validation Defined.

  2. In the Address Style section, click No Styles Format to highlight the table row.

  3. For the County geography type, click the County list item in the Map to Attribute field.

  4. Select the Enable List of Values and Geography Validation options.

  5. For the Post Town geography type, click the City list item in the Map to Attribute field.

  6. Select the Geography Validation option.

  7. In the Geography Validation Control section, select Error in the Geography Validation Level for Country list.

  8. Click Save and Close.

You must group territory geographies into group zones to manage territory geography level splits. Grouping the territory geographies involves two steps, selecting the geography level based on which you need grouping and initiating the grouping.

Select the Geography Level for Grouping

You can perform these steps to select the geography level based on which you want to create the group zones:

  1. Sign in as a set up user such as Application Implementation Consultant.

  2. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  3. Search for the country for which you want to enable territory geography level grouping.

  4. Click Structure Defined. Manage Geography Structure page appears.

  5. Select the Subject to Grouping check box corresponding to the geography type level for which you want to enable grouping.

    You must select the geography level that suits your business requirements. For example, if your product delivery is based on postal code, and your territory geographies don't have higher levels of master geographies such as counties and cities, then you may have postal code splits. In this case you must select postal code as the geography type level for grouping.

    Note: You can enable grouping for only one level at a time.
  6. Click Save and Close.

Initiate Grouping

Here are the steps to initiate grouping:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Sales

    • Functional Area: Territories

    • Task: Manage Territory Geographies

    The Manage Territory Geographies page opens.

  2. Click Initiate Grouping.

  3. Click OK in response to the warning message and confirm the process.

    Note: You can't automatically un-group the grouped territory geographies. You can manually undo the grouping process by recreating territory geography hierarchy either through the UI or import process.

    The geography level that you selected for grouping appears as an expandable Group Zone when the grouping is complete is shown in the following figure.

    Manage Territory Geography page with the newly
created group zones highlighted
  4. Click Save and Close.

This topic describes how we can overcome the problem of territory geography splits by grouping them into group zones.

You do a territory geography grouping when any of your territory geography levels has multiple splits. A territory geography splits occur when the lower level master geographies are added to territory geography hierarchy, while skipping the higher level master geographies. This may cause multiple occurrences of the lower geography level members in a territory geography hierarchy.

For example, postal code split happens when a postal code overlaps across many master geography levels such as cities and counties. Suppose that the business firm Vision Corp. delivers its product according to the postal codes. If counties and cities aren't included in the territory geography hierarchy of Vision Corp., then the end user can see the multiple occurrences of the postal code 97229.

When there is a territory geography level split, and if you want to group the split geographies, first you must specify the master geography level for which you want the grouping to be performed, then initiate grouping. When grouping is performed, all the splits of the selected master geography level get grouped under a new group zone. In the previous example, if you select postal code in the master geographies as the level for grouping and initiate the grouping process, then the 12 postal code splits for the postal code 97229 gets grouped together under one group zone named 97229. So, the Territory Manager user can define territories on a clean list of postal codes or their ranges, although some of those postal codes would in fact be the groupings of the postal code splits. The grouped splits are hidden for the Territory Manager user.

Best Practices for Managing Geography Mismatches

This topic employs a couple of use cases to illustrate the best practices for setting up Master Reference Geographies for sales customers using the Oracle Data as a Service (DaaS) for Sales for data enrichment and the Address Verification Cloud Service for address verification.

When you perform the real-time enrichment of accounts or contacts using the Oracle Data as a Service, if there's a geography data mismatch between the predefined master geography data and the Dun and Bradstreet (D&B) data, then the Service enriches the accounts and contacts data but you can't edit or save the enriched data unless the master geography data mismatches are resolved. In addition, you can verify the enriched address using the Address Verification Cloud Service, however, in case of mismatches between Address Verification Cloud Service (GBG | Loqate) and predefined master geography data you can't save the verified address.

The second use case describes the setup required to enable address verification and to avoid data conflicts between the Address Verification Cloud Service and master reference geography data.

Use Case 1

You're a sales customer using master reference geographies for territory assignments or tax calculation and have purchased Oracle Data as a Service for data enrichment as well as the Address Verification Cloud Service. In this case, while the GBG | Loqate geography reference data is configured as master geography, Tax calculation is being done using Vertex master geography data. Also, address validation is enabled based on the customer's requirement.

Best Practice: Review geography mapping for the countries where you do business. If the geography mapping for a specific country isn't mapped according to the country-specific address attributes, update the mapping. Oracle recommends performing enrichment before verifying address.

Suppose that you're doing real time enrichment of account or contact. If there's a geography data mismatch between the predefined master geography and the D&B data, the Oracle Data as a Service still enriches the accounts and contacts data but can't edit or save the enriched account or contact unless the master geography data mismatches are resolved. However, you can verify the enriched address using the address verification cloud service.

To save a verified address that has master geography data mismatch, you must add alternative names for the mismatched hierarchy elements in master geography. The following are the steps to add alternative name for the mismatched hierarchy element:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, search for the country by the name or country code, for example US.

  3. Click the Go to Task button in the Hierarchy Defined column. The Manage Geographies Hierarchy page for the particular country appears.

    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.
  4. Highlight the mismatched hierarchy element, for example California State, and click the Edit icon.

  5. Click the Add icon on the Edit page.

  6. Add an alternative name CA for the California state geography element.

  7. Click Save and Close

Once the alternative name is added for the mismatched hierarchy element in master geography, you can save the enriched address.

Use Case 2

You're a sales customer who doesn't use geographies for territory assignment or tax calculation and has purchased Oracle Data as a Service for data enrichment and the Address Verification Cloud Service for address verification. To enable address verification and to avoid data conflicts between the Address Verification Cloud Service and master reference geography data you must do the following setups:

  • Deselect the Enable List of Values option in the Geography Mapping and Validation region to avoid Address Verification Cloud Service data conflicts with master reference geography data. By deselecting this option you can avoid any UI level validation against master geographies while adding address.

  • Select Geography Validation Level for Country as No validation to verify address data by Address Verification Cloud Service.

Perform the following steps on the Manage Geography Validation page to enable address verification and to avoid data conflicts between the Address Verification Cloud Service and master reference geography data:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, search for the country by the name or country code, for example US.

  3. Click the Go to Task button in the Validation Defined column. The Manage Geography Validation page appears.

  4. Deselect the Enable List of Values check boxes for all the geography attributes to avoid any UI level validation against master geographies while entering the addresses. If the Enable List of Values check boxes are selected then, in case of data conflicts, Geography Naming References records aren't created.

Note: If any of the Geography Types listed isn't applicable to the selected country's territory structure, then you must deselect the geography validation for that type.

If you're planning to create territories based on a particular Geography Type, such as County, then you must deselect all the Geography Validation levels under that Geography Type (in this case City and Postal Code) based on which you want to create the territory.

Tip: Review the Address Style Formats that are selected on the Manage Geography Validation page. The review is required because on the Account or Contact Simplified UI page, address attributes are displayed based on the address formats and verified or enriched addresses are saved in Oracle Applications Cloud based on the selected address formats.

Import Geographies and Zones

How You Import Geographies

A geography, such as Tokyo or Peru, describes a boundary on the surface of the earth.

You can use the following options when importing geographies:

  • Oracle-licensed geography reference data

  • Import Management

Oracle-Licensed Geography Reference Data

You can import Oracle-licensed data from GBG | Loqate, for those countries where the data is available. For more information about the supported countries, see the List of Available Countries with GBG | Loqate Geography Reference Data topic. You can import geography data using the Manage Geographies task. Search for the country, and select Import Geography Data from the Actions menu. If the licensed data isn't available or already set up for a particular country, then the Import Geography Data action is disabled.

Note: The processing time for the import job can vary based on several variables and the import job could take several hours to complete.
Note: GSI (Global Single Instance) customers who either actively implement or who could prospectively implement HCM Cloud for payroll or payroll interface purposes must import Vertex Geography data for the United States and Canada.

Import Management

The Import Management process reads the data included in your XML or text file and imports the data into the application.

To access Import Management functionality, go to Navigator > Tools > Import Management

For more information, see the Import Your Geography Data topic.

Oracle Applications Cloud provides third-party GBG | Loqate geography data for import. Here's the list of countries for which the GBG | Loqate geography data is available for import.

Country Name Country Code

Andorra

AD

Angola

AO

Argentina

AR

Australia

AU

Austria

AT

Bangladesh

BD

Belgium

BE

Bolivia

BO

Bosnia and Herzegovina

BA

Brazil

BR

Bulgaria

BG

Canada

CA

Cayman Islands

KY

Chile

CL

China

CN

Croatia

HR

Cuba

CU

Cyprus

CY

Czech Republic

CZ

Denmark

DK

Dominican Republic

DO

Ecuador

EC

Estonia

EE

Finland

FI

France

FR

Germany

DE

Great Britain

GB

Greece

GR

Guadalupe

GP

Guam

GU

Guernsey

GG

Hungary

HU

Iceland

IS

India

IN

Indonesia

ID

Ireland

IE

Isles of Man

IM

Israel

IL

Italy

IT

Jamaica

JM

Japan

JP

Jordan

JO

Kenya

KE

Latvia

LV

Liechtenstein

LI

Lithuania

LT

Luxembourg

LU

Malaysia

MY

Malta

MT

Martinique

MQ

Mexico

MX

Netherlands

NL

New Zealand

NZ

Norway

NO

Oman

OM

Pakistan

PK

Peru

PE

Philippines

PH

Poland

PL

Portugal

PT

Puerto Rico

PR

Qatar

QA

Reunion Island

RE

Romania

RO

Russia

RU

San Marino

SM

Singapore

SG

Slovakia

SK

Slovenia

SI

South Africa

ZA

South Korea

KR

Spain

ES

Sri Lanka

LK

Swaziland

SZ

Sweden

SE

Switzerland

CH

Taiwan

TW

Thailand

TH

Tunisia

TN

Turkey

TR

United Arab Emirates

AE

United States

US

Uruguay

UY

Vatican City

VA

Vietnam

VN

You must import and set up reference geography data for the countries where you do business. Using the Oracle-licensed geography reference data, you no longer have to source geography data from a third party. You can import Oracle-licensed data from GBG | Loqate, including the country structure and hierarchy information, either to create a new geography setup or replace your existing geography data.

You can use the information in this section to replace existing geography data with GBG | Loqate geography data. You can follow these steps if you're using Nokia or any other geography data and now want to move to GBG | Loqate geography data.

Before you begin, perform the following steps:

  • Backup existing geography data including customizations, if any.

  • Backup territory geographies.

  • Perform impact analysis by contacting the support team to identify the use of geography IDs downstream.

Note: Before deleting the geography data, make sure that GEOGRAPHY_ID isn't referenced in any downstream applications such as TAX, FIN, Legal, and so on. Geography data is used across Oracle Cloud applications such as Human Capital Management, TAX, and Legal. Global Single Instance POD users share the same geography data and before deleting geography data, the geography usage POD analysis is required. The Oracle Support team can help you identify the downstream impact.

Create an Export File of All Territories

In case you have implemented Customer Data Management along with the sales functionality, you must export all territories before deleting the master geography data because removing the master geography data invalidates the territory definitions that are based on the Geography dimension. You can either export the definitions of all territories to a file or make manual corrections. If there are a large number of territories, export the territories definition to a file for the territories import process. However, if there are very few affected territories, then you can choose to either export the territories definition to a file or make corrections manually.

This procedure is applicable only if there are territories defined using the Geography dimension.

Perform the following steps to create an export file of all territories.

  1. From the Territories and Quotas work area, click View Active Territories in the Tasks pane.

  2. In the View Active Territories page, select the territory at the highest level.

  3. Click the Actions list, and select Export, and then Export Selected Territory Hierarchy.

  4. In the Warning dialog box, click OK.

  5. Click the Actions list and select Export, and then View Export Status.

  6. Review the status of the export job and verify if it has completed successfully.

  7. In the Exported Data File column, click the .zip file against your export job, and click Save. All the territories are exported to a compressed file on your system.

  8. Click OK.

  9. Click Done in the View Active Territories page.

Delete the Territory Geography Data

A territory definition has references to the territory geography data and master geography data. Territory geography data is based on the master geography data, in case you have implemented Customer Data Management along with the sales functionality, you must delete the territory geography data prior to deleting the master geography data. When you delete the territory geography data, all territories that are defined using geography dimension become invalid.

This procedure is applicable only if territory geographies are defined.

Perform the following steps to delete the territory geography data.

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Sales

    • Functional Area: Territories

    • Task: Manage Territory Geographies

  2. On the Manage Territory Geographies page, click View All Hierarchies.

  3. Select the highest level node for the country for which you want to replace the master geography data and click the Delete icon.

  4. In the Warning dialog box, click OK.

  5. In the Confirmation dialog box, click OK. The parent node of the territory geography data and its children are deleted.

  6. Repeat steps 3 to 5 to delete all the higher nodes in the territory geography data.

  7. Click Save and Close.

The Territory Management application retains a copy of the dimension members referenced in the territory definitions. This copy is updated when you trigger the Load and Activate process from the Enable Dimensions and Metrics task. Therefore, although the territory geography data is deleted, the territory definitions may appear to remain valid.

Delete the Master Geography Data

Delete the existing geography data one country at a time. We recommend that you raise a service request for assistance in deleting the geography data.

Delete Geography Structure

If you have created a geography structure, it prevents the geography imports from working or working as desired. For example, if the geography structure exists, the Import Geography option may not be enabled for a country in Manage Geographies even if GBG | Loqate predefined geography data is available for that country and the geography hierarchy doesn't exist yet.

Note: If any geography hierarchy was created manually, it must be deleted first.

If the geography structure was created manually, you can follow these steps to delete it. However, we recommend that you raise a service request for assistance in deleting the geography structure.

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, enter either the country name or the two-letter ISO code (for example, US), and click Search.

  3. Select the country in the search results and click Actions > Manage Geography Structure.

  4. In the Manage Geography Structure page, delete each level of the structure.

  5. Click Save and Close.

You can now proceed to importing geography data.

Note: If other setup or transaction data exists that's based on the geography data, replacement procedures for that setup must also be followed.

Import Oracle-Licensed Geography Reference Data

Use this procedure to import GBG | Loqate geography data in Manage Geographies one country at a time. If the country data you want isn't supported by GBG | Loqate geo seed data and point the GBG | Loqate supported country list here, then the Import Geography Data action is disabled.

The geography data is provided by GBG | Loqate and is third-party content. As per Oracle policy, this software and documentation may provide access to or information about content and services from third parties. Oracle and its affiliates aren't responsible for and expressly disclaim all warranties of any kind with respect to third-party content and services. Oracle and its affiliates aren't responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Perform the following steps to import Oracle-licensed geography reference data.

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, enter either the country name or the two-letter ISO code (for example, US), and click Search.

  3. Select the country in the search results.

  4. Click the Actions list, and select Import Geography Data.

  5. In the Warning dialog box, click OK.

  6. In the Confirmation dialog box, click OK.

The import of larger countries may require several hours to complete.

You can track the progress of the import process by selecting Scheduled Processes from the Navigator.

Note: To access the Scheduled Processes work area, you must be signed in as a user with the Employee abstract role. The initial user doesn't have this role assigned, but the other users you created do.

After the import is complete, you can search for the country again in the Manage Geographies page. Check marks now appear in the Structure Defined and Hierarchy Defined columns indicating the import completed successfully.

Next, click the Validation Defined icon to define the validations, enable List of Values, and choose address style format for a country as set up before. For more information, see the Geography Validation topic.

The Geocoding Defined and Address Cleansing Defined columns are used for additional features which you must license from Oracle and set up separately.

  • Geocoding makes it possible to display customers in the vicinity of a mobile address. You set up Geocoding Enabled for those countries where you're using Around Me functionality in CX Sales Cloud Mobile.

  • Cleansing makes it possible to validate addresses down to the street level.

Add any geography customizations.

Run the Geography Name Referencing Process

The Geography Name Referencing (GNR) process validates address elements in location tables, such as HZ_LOCATIONS, against the master geography data.

Perform the following steps to run the GNR process.

  1. Navigate to Tools > Scheduled Processes work area.

  2. On the Overview page, click Actions > Schedule New Process.

  3. Click the Name list and search for Validate Geographies Against Master Geographies, and then click OK.

  4. Click OK in the Schedule New Process dialog box.

  5. In the Process Details dialog box, enter the following details:

    • Location Table Name: HZ_LOCATIONS

    • Run Type: ALL

    • Usage Code: GEOGRAPHY

  6. Enter the country code in the Country Code field.

  7. Click Submit.

  8. In the Confirmation dialog box, click OK.

  9. Click Close.

  10. In the Scheduled Processes page, click the Refresh icon.

  11. Verify if the status of the process has completed successfully.

Find the locations failing in Geography Name References using: https://cloudcustomerconnect.oracle.com/posts/b1e16b06ae. Fix Geography Name References failures by updating addresses with the latest geography data.

Recreate and Load the Territory Geography Data

In case you have implemented Customer Data Management along with the sales functionality, you can recreate the territory geography data, after the master geography data is imported, using either of the following methods:

  • Import process: If you created the original territory geography data using the import process, then use the same import file to recreate the territory geography structure. For more information about importing the territory geography data using Import Management, see Import Your Sales Territory Data in the Oracle CX Understanding Import and Export Management for CX Sales and B2B Service guide.

  • Manual creation process: You can manually recreate the territory geography data structures, as they existed before their deletion, using the Manage Territory Geographies task. For more information about creating zones and adding geographies to a zone, see Managing Territory Geographies in the Related Topics section.

After you have recreated the territory geography data, perform the following steps to load the data.

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Sales

    • Functional Area: Territories

    • Task: Enable Dimensions and Metrics

  2. On the Enable Dimensions and Metrics page, click the Actions list, and select Load and Activate. The process loads the territory geography data to make dimension members available for selection when defining territories.

  3. In the Confirmation dialog box, click OK.

  4. Click Done.

Restore the Invalid Territory Definitions

After recreating the territory geography hierarchies and running the Load and Activate option from the Enable Dimensions and Metrics task, the geography dimensions are populated with the new geography members. The geography members in the territory appear as invalid because your territories still reference the old copies of the dimension members that were deleted. The new members aren't referenced automatically by the territories. You must re-reference the territory definitions from the old geography dimension members to the new ones.

You can restore the invalid territory definitions by either importing the previously created export file or making manual corrections to the territories.

To restore valid territory definitions using territories import:

  1. Open the export file you saved in the Creating an Export File of All Territories step. The compressed file contains four CSV files.

  2. Open TERR_HEADER.CSV file.

  3. Enter REPLACE in the Action column for all territories that are based on geography dimension.

  4. Save the file in CSV format and compress it together with three other CSV files.

  5. From the Territories and Quotas work area, click View Active Territories in the Tasks pane.

  6. Click the Actions list, and select Import to Proposal, and then Import Territories.

  7. Select the newly created compressed file and click OK.

  8. Click the Actions list and select Import to Proposal, and then View Import Status.

  9. Review the status of the export job and verify if it has completed successfully.

  10. Click OK.

  11. From the Tasks pane, click Manage Territory Proposals.

  12. In the Manage Territory Proposals page, on the Current Territory Proposals table, search for the proposal with your import file name.

  13. Click the import file name to open the territory proposal.

  14. Click Edit Coverage to verify that the territory definitions are valid.

  15. Verify that there are no values listed as invalid in the Selected Dimension Members section.

  16. Click Save and Close.

  17. Click Activate. The territory proposal of your import file is activated.

To restore valid territory definitions through manual corrections:

  1. From the Territories and Quotas work area, click Manage Territory Proposals in the Tasks pane.

  2. In the Manage Territory Proposals page, click the Create icon.

  3. In the Create Territory Proposals dialog box, enter a name and click Save and View.

  4. In the Territory Proposals page, add all the territories with the Geography dimension value other than the value Any to the proposal.

  5. Select a territory and click Edit Coverage.

  6. In the Edit Coverage page, select Geography from the Dimensions list. The invalid dimension members are displayed in the Selected Dimension Members pane.

  7. Expand the values in the Available Dimension Members section or search for the member that has the same name as the one marked invalid in the Selected Dimension Members pane.

  8. Select one or more new geography dimension members from Available Dimension Members pane and click Add icon to the Selected Dimension Members pane.

  9. Click the Remove icon to remove the invalid members from the Selected Dimension Members pane.

  10. Click Save and Close.

  11. Repeat steps 4 to 10 for all territories that were based on Geography dimension.

  12. Click Activate. After the activation process is complete, your territory definitions are valid again and are referencing to the new geography data.

Although this method is always applicable, it's most appropriate when you have to restore territory definitions for a smaller number of territories.

To run the batch assignment process for opportunities:

  1. From Navigator, click Scheduled Processes.

  2. In the Schedule Processes page, click Schedule New Process.

  3. In the Schedule New Process dialog box, search for the Request Revenue Territory Assignment process and select it.

  4. Click OK.

  5. In the Process Details dialog box, enter OpenOpportunitiesByCreationDate in the View Criteria Name field. This selects all revenue lines belonging to open opportunities that were created in the last 'X' days.

  6. Enter BindOptyCreationDateFrom= followed by the date.

    For example, if BindOptyCreationDateFrom=2014-01-01, then all open opportunities which were created between 1st January 2014 till the current date, are processed.

  7. Click Submit to schedule the process.

  8. In the Confirmation dialog box, make a note of the process identifier for monitoring the process, and click OK.

  9. Click Close.

  10. In the Schedule Processes page, click the Refresh icon.

  11. Review the status of the process job and verify if it has completed successfully.

    Note: Review a small subset of the open opportunities to confirm that the territory assignment is as expected.

To run the batch assignment process for sales accounts:

  1. Ensure that the ZCA_SA_AUTO_ASSIGN_ON_CREATE and ZCA_SA_AUTO_ASSIGN_ON_UPDATE profile options are set to Yes in the Manage Customer Center Profile Options task.

  2. From Navigator, click Customers.

  3. In the Customers page, click Create Account.

  4. In the Create Account page, enter a name and address of the sales account, and select the Address is sell to check box.

  5. Click Save and Close.

  6. From Navigator, click Customers.

  7. In the Search pane, search for the name of the sales account you created and select it.

  8. In the section Customer Information, select Sales Account Team. The details of the sales account and territories associated with the sales account are displayed.

    This indicates that the sales account was created successfully and the batch assignment was run automatically to assign the matching territories to the sales account.

To run the batch assignment process manually from the Scheduled Processes page, perform the following steps.

  1. From Navigator, click Scheduled Processes.

  2. In the Schedule Processes page, click Schedule New Process.

  3. In the Schedule New Process dialog box, search for the Request Account Assignment process and select it.

  4. Click OK.

  5. Enter SalesAccount_Work_Object in the Work Object Code field and SalesAccountTerritory_Candidate_Object in the Candidate Object Code field.

  6. Select Territory in the Assignment Mode list.

  7. Enter AllSalesAccountsVC in the View Criteria Name field. This selects all sales accounts.

  8. Click Submit to schedule the process.

  9. In the Confirmation dialog box, make a note of the process identifier for monitoring the process, and click OK.

  10. Click Close.

  11. In the Schedule Processes page, click the Refresh icon.

  12. Review the status of the process job and verify if it has completed successfully.

    Note: Review a small subset of the accounts to confirm that the territory assignment is as expected.

Verify that the downstream applications using geography data is working fine.

Create Countries

This procedure lists the steps to create countries in the application.

The countries are seeded in the application. If you're unable to find a specific country in the Manage Geographies page, then you can add it to the application.

Note: The application provides support for GBG | Loqate geography data for countries.

For countries where GBG | Loqate geography data isn't available, you can purchase the geography data from a third-party data provider and load it into the application using Import Management. For more information, see the Import Your Data chapter in the Oracle CX Understanding Import and Export Management for CX Sales and Service guide.

If countries aren't available in the application, then use the procedure outlined in this topic to create them.

Perform the following steps to create a new country.

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Application Extensions

    • Task: Manage Territories

  2. On the Manage Territories page, click the New icon.

  3. Enter the following details:

    • Territory Code: Enter a unique code for the territory.

    • Territory Name: Enter a unique name for the territory.

    • Description: Enter a description for the territory.

  4. Click Save and Close.

    Note: After you have added a new country in the application, if you want to import the geography data for that country, then you must perform Step 5 to 10.
  5. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  6. On the Manage Geographies page, click Actions > Create Country.

  7. In the Create Country dialog box, select the name of the country and click Save.

  8. Click Done.

Note: You can now import the geography data for the newly created country using GBG | Loqate geography data available in the application. In case geography data for your country isn't available from GBG | Loqate, you can purchase the geography data from a third-party data provider and import it using Import Management.

Import Your Geography Data

You can use Import Management to create or update Geography records.

To import Geography records, perform the following tasks:

  1. Map your source data to Oracle Applications Cloud object attributes.

  2. Create source Comma Separated Values (CSV) file for import.

  3. Create the import activity.

  4. Review the import results.

How You Map Your Source Data to Object Attributes

To import your Geography data into Oracle Applications Cloud, you must populate a .csv file with your source data and map that source data to target object attributes in Oracle Applications Cloud.

You need to do the following before creating the CSV file for data import:

  • Identify how your source data attributes map to the target object attributes in Oracle Applications Cloud.

  • Ensure prerequisite setups are done, if applicable.

  • Understand your options for uniquely identifying the records.

  • Ensure parent records exist before importing child records.

  • Identify the target object attributes that are required in the CSV file for a successful import.

Before You Start

You must do some basic checks before starting your import. For example, make sure that:

  • You have completed all the prerequisites for importing each attribute in your source data.

  • You have all parent records in place before importing child records.

Select a Unique Identifier for Your Records

To import data into Oracle Applications Cloud, your CSV file must include some specific attributes that enable the import process to uniquely identify the records. The file import process uses the attribute values to automatically map your source data to the target object attributes in Oracle Applications Cloud.

The preferred options to uniquely identify an object record are as follows:

  • Internal ID: If you're identifying a record that already exists in Oracle Applications Cloud, then you can use the internal ID of the record, a system-generated unique identifier Attributes with "id" in the attribute name are typically internal IDs. Use this option only if you're updating Geographies. You can determine the internal ID of a record by exporting Oracle Applications Cloud object data, or by doing a transactional database query. Using an internal ID typically provides better performance and reduces the import duration. For the Geography object, the attributes are Batch Id and Interface Row Id.

  • Public unique identifiers: If you're creating new records, then you can provide a user-friendly public unique identifier (attributes denoted with 'Number' and usually visible in the business object's UI). If you update a record for which you have previously provided a Number attribute, or for which a Number attribute is visible in the object's UI, you can use the Number attribute to identify the record. For the Geography object, the attribute is Import Activity Identifier.

Required Attributes and Validations for the Geography Object

To import data successfully into Oracle Applications Cloud, your CSV file must include the required attributes. Ensure that you provide valid values for the attributes. The following table lists the required attributes for importing new Geography records, prerequisite setup tasks for the attributes, and specific validations, if any, for Geography import:

Attribute Description Prerequisite Setup Task/ Import Validations Creating a Geography Record

CountryCode

The code of the country to which the geography belongs.

This is validated against the country structure to check if the structure is defined for this country.

Required

PrimaryGeographyName

The primary name of the geography.

This is validated against the country structure to check if the structure is defined for this geography name.

Required

RecordTypeCode

Specifies the data that needs to be created

No Validation

Required

You can view the Geography object and attributes in the Manage Import Objects page of the Import Management flow. You can find attribute information like type, length, description, and so on, on this page.

You can enable high-volume import for the Geography import object in the Manage Import Objects page.

Create the Source CSV File

You include the data that you want to import into CX Sales and B2B Service in a source CSV file.

You can use the templates available in the Import Objects UI page to create the source CSV file. To download a template:

  1. Go to Navigator > Tools > Import Management > Import Objects.

  2. Select the Geography object in the table and click Download.

You can now edit the downloaded file and provide valid values for the required attributes.

Note: For help in populating the CSV file and to avoid any issues in entering values, see the topic Potential Issues When Opening CSV Files With Excel in Related Topics section.

Create the Import Activity

After you have the CSV file ready, create an import activity to import the information. To create an import activity:

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click Create Import Activity in the Manage Imports page.

  3. In the Enter Import Options page, provide a name for the import activity, and select Geography from the Object drop-down list.

  4. Select the CSV file in the File Name field, and click Next.

  5. The source and target attributes are automatically mapped in the Map Fields page. Review and edit the mappings if required.

  6. Check the file for unmapped columns or data format issues by clicking Validate Data. Click Next.

  7. Review the import details on the Review and Submit page, and click Submit when you're ready.

Review the Import Results

Check if your import succeeded on the Manage Imports page. This page shows the status of all active, completed, and unsuccessful imports. To check the status of the import activity:

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click All Imports and search for the import activity that you created earlier.

  3. Check the Status column for the import activity. The import is successful if the status displays as Completed. You can drill down on the import activity to go to the Import Status page which provides the status details of the import activity.

Note: Geography names aren't translatable and are always displayed in the same language in which they were loaded irrespective of the language of the signed in user. If you need different options of display, you can use the alternative names option.

Example of Importing Geography Data

This example demonstrates how to import data using Import Management. In this example, you have a source file containing geography data that you want to import into the application to make the geography data available for real time address validation and tax purposes. A geography is any region with a boundary around it, regardless of its size. It might be a state, a country, a city, a county, or a ward.

Summary of the Tasks

You perform the following steps to create an import activity and activate the import:

  1. Determine what information is in the source file.

  2. Create and schedule the import activity.

Before You Start

  1. You use the country structure of a country to define which geography types are part of the country. For more information about an example of importing a country structure, see the topic "Example of Importing Country Structure Data".

  2. Ensure that the combination of the Source ID and Parent Source ID values is unique for each row of data within a single import. However, your source data files don't need to have the same Source ID and Parent Source ID values as your previously imported geography data. If the geography structure levels and the parents for each geography value are the same, then the changed IDs will not affect the import.

  3. Ensure that all the parents of a child geography are included in your data file so that the child geography can be added. For example, if you originally imported US, CA, and San Francisco, and now you want to import the city of San Jose in CA, then your data file must include US, CA, and San Jose.

  4. Check that your source data file has the correct values for the geography data that you have already loaded. For example, if your initial import included the value US for country and CA as state, and in a subsequent import you have California as a state, then your geography import creates two state records (CA and California) in the application data, with the US as the country parent.

Determine the Information in the Source File

The source geography data files must include a unique Source ID value for each row of data and Parent Source ID value for the parent of that row of data. You include the data that you want to import into CX Sales and B2B Service in a source CSV file. A sample input CSV file is shown below.
RecordTypeCode PrimaryGeographyName CountryCode LevelNumber SourceId ParentSourceId LanguageCode

0

United States

US

1

1

<blank>

US

1

California

US

2

11

1

US

1

San Mateo

US

3

111

11

US

1

Redwood City

US

4

1111

111

US

1

94065

US

5

11111

1111

US

2

United States

US

1

2

1

US

2

California

US

2

11

1

US

Import validation is triggered only when updating the address data. While inserting the address data, validation isn't triggered even if the same address already exists.

Note: Note the following:
  • The hierarchy is modeled in the CSV file using the SourceId and ParentSourceId. The ParentSourceId for the Country Record (level Number 1) is always null.

  • If defining an alternate name (RecordTypeCode = 2) for the country, ensure that the ParentSourceId is the same as the SourceId for the Country record (RecordTypeCode=0) and the SourceId is a unique number.

  • If defining an alternate name (RecordTypeCode = 2) for any level below the country (LevelNumber >1), ensure that the SourceId and ParentSourceId columns match the values for the original record respectively.

You must create a source file (CSV) file with the attributes and import it using import management as shown in this table.

Attribute Name Value Description

RecordTypeCode

1

The record type code that represents the intent of the import data. The values are:

  • 0 - indicates the geography that already exists in the base table.

  • 1 - indicates the intent to create a new geography.

  • 2 - indicates the intent to add an alternate identifying name or code to an existing geography.

PrimaryGeographyName

California

This is the primary geography name. This will be marked as the primary name for the Geography and also displayed in the Manage Geographies Page.

CountryCode

US

This indicates the Country Code for the country for which you're importing data.

LevelNumber

2

The level number of the geography in the hierarchy. For example, Country is at Level 1 and State (California) is at Level 2.

SourceId

1

The source ID for the geography, along with the parent source ID is used to identify the geography parent and child relationship within the source file data and the interface table data.

ParentSourceId

1

The parent source ID for the geography, along with the source ID is used to identify the geography's parent and child relationship with records within the source file data. This should be null for the country record, as Country is at the top of the hierarchy.

LanguageCode

US

The code that represents the language for the translated values for the geography, such as the primary geography name, alternate name.

You can create an import activity, enter the import details, and schedule the import.

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click Create Import Activity in the Manage Imports page.

  3. In the Enter Import Options page, provide a name for the import activity, and select Geography from the Object drop-down list.

    Note: In the Advanced Options section, the option Enable High-Volume Import is selected by default. This mode is designed to import millions of records at once.

  4. Select the CSV file in the File Name field, and click Next.

  5. The source and target attributes are automatically mapped in the Map Fields page. Review and edit the mappings if required.

  6. Check the file for unmapped columns or data format issues by clicking Validate Data. Click Next.

  7. Review the import details on the Review and Submit page, and click Submit.

Import Your Country Structure Data

You can use Import Management to create, update, or delete Country Structure records.

To import Country Structure records, perform the following tasks:

  1. Map your source data to Oracle Applications Cloud object attributes.

  2. Create source Comma Separated Values (CSV) file for import.

  3. Create the import activity.

  4. Review the import results.

How You Map Your Source Data to Target Object Attributes

To import your Country Structure data into Oracle Applications Cloud, you need to populate a CSV file with your source data and map that source data to target object attributes in Oracle Applications Cloud.

You need to do the following before creating the CSV file for data import:

  • Identify how your source data attributes map to the target object attributes in Oracle Applications Cloud.

  • Ensure prerequisite setups are done, if applicable.

  • Understand your options for uniquely identifying the records.

  • Ensure parent records exist before importing child records.

  • Identify the target object attributes that are required in the CSV file for a successful import.

  • Ensure that you don't insert duplicate addresses while importing, to avoid redundant data.

Before You Start

You must do some basic checks before starting your import. For example, make sure that:

  • You have completed all the prerequisites for importing each attribute in your source data.

  • You have all parent records in place before importing child records.

Select a Unique Identifier for Your Records

All records must be unique in the application. You can use one of these to identify records:

  • Public unique identifiers: If you're creating records, then you can provide an easily understandable public unique identifier. These are, usually, denoted with 'Number' and visible in the business object's UI. PUID attributes are usually named <object> Number. If you're updating a record with a Number attribute, then use the Number attribute to identify the record. For more information about public unique identifiers, see the topic "How You Use Alternate Keys to Import Records" in Related Topics section.

  • Source system and source system reference: Source system is an identifier for the external system, and source system reference is a unique identifier within the external system. If you're importing new contacts or are updating contacts that have source system reference data, then provide the source system and source system reference values.

Required Attributes and Validations for Country Structure Object

To import data successfully into Oracle Applications Cloud, your CSV file must include the required attributes. Ensure that you provide valid values for the attributes. This table lists the required attributes for importing new Country Structure records, required attributes for updating Country Structure records, required attributes for deleting Country Structure records, prerequisite setup tasks for the attributes, and specific validations, if any, for Country Structure import:

Attribute Description Prerequisite Setup Task/ Import Validations Creating a Country Structure Record Updating a Country Structure Record Deleting an Existing Country Structure Record

CountryCode

The country code to which the country structure is applicable.

The GeographyType has to be "Country" and the LevelNumber has to be "1" for a country.

You can't pass duplicate country codes when importing a record.

Yes

Not updatable

Yes

GeographyType

The different structure types of a geography for a country such as Region, City, County, and so on.

The country has to be present.

Yes

Optional

Yes

LevelNumber

The different structural levels of a country.

When defining a country, Level 1 has to be present.

Yes

Optional

Yes

You can view the Country Structure object along with all its child objects and attributes in the Manage Import Objects page of the Import Management flow. You can find attribute information like type, length, description, and so on, on this page.

Create the Source CSV File

You include the data that you want to import into CX Sales and B2B Service in a source CSV file.

You can use the templates available in the Import Objects UI page to create the source CSV file. To download a template:

  1. Go to Navigator > Tools > Import Management > Import Objects.

  2. Select the Country Structure object in the table and click Download.

You can now edit the downloaded file and provide valid values for the required attributes.

Note: For help in populating the CSV file and to avoid any issues in entering values, see the topic Potential Issues When Opening CSV Files With Excel in Related Topics section.

Create the Import Activity

After you have the CSV file ready, create an import activity to import the information. To create an import activity:

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click Create Import Activity in the Manage Imports page.

  3. In the Enter Import Options page, provide a name for the import activity, and select Country Structure from the Object drop-down list.

  4. Select the CSV file in the File Name field, and click Next.

  5. You would see that the source and target attributes are automatically mapped in the Map Fields page. Review and edit the mappings if required.

  6. Check the file for unmapped columns or data format issues by clicking Validate Data. Click Next.

  7. Review the import details on the Review and Submit page, and click Submit when you're ready.

Review the Import Results

Check if your import succeeded on the Manage Imports page. This page shows the status of all active, completed, and unsuccessful imports. To check the status of the import activity:

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click All Imports and search for the import activity that you created earlier.

  3. Check the Status column for the import activity. The import is successful if the status displays as Completed. You can drill down on the import activity to go to the Import Status page which provides the status details of the import activity.

Example of Importing Country Structure Data

You use the country structure of a country to define which geography types are part of the country and how the geography types are hierarchically related within the country. For example, you can create geography types called State, City, and Postal Code. Then you can rank the State geography type as the highest level within the country, the City as the second level, and the Postal Code as the lowest level within the country structure.

To add or update a country structure using import management, your source file must contain information about the country to which the country structure belongs. You also need to specify the level at which the geography types need to be placed. By default, all countries are at Level 1. You create the country structure by increasing the level number as you go down the country structure. You place the geography types such as states, provinces, and so on at Level 2, districts or counties at Level 3, and so on. To add or update a country structure, your source file must include the values that let the import process identify the existing records.

Sample Input CSV File

You include the data that you want to import into CX Sales and B2B Service in a source CSV file. A sample input CSV file is shown below.
CountryCode LevelNumber GeographyType

US

1

COUNTRY

US

2

STATE

US

3

COUNTY

US

4

CITY

US

5

POSTAL CODE

You must create a source file (CSV) file with the attributes and import it using import management as shown in this table.

Attribute Name Value Description

CountryCode

US

This indicates the Country Code for the country for which you're importing data.

LevelNumber

2

The level number of the geography in the hierarchy. For example, Country is at Level 1 (Top level) and State (California) is at Level 2.

GeographyType

COUNTRY

A code used for internal reference at an administrative level. For example, this administrative code may be COUNTRY, STATE, COUNTY, CITY, and so on.

Create an import activity to import the information. To create an import activity:

  1. Go to Navigator > Tools > Import Management > Import Queue.

  2. Click Create Import Activity in the Manage Imports page.

  3. In the Enter Import Options page, provide a name for the import activity, and select Country Structure from the Object drop-down list.

    Note: In the Advanced Options section, the option Enable High-Volume Import is selected by default. This mode is designed to import millions of records at once.

  4. Select the CSV file in the File Name field, and click Next.

  5. The source and target attributes are automatically mapped in the Map Fields page. Review and edit the mappings if required.

  6. Check the file for unmapped columns or data format issues by clicking Validate Data. Click Next.

  7. Review the import details on the Review and Submit page, and click Submit.

How You Import and Export Territory Geography Zones

Territory geography zones are geographical boundaries that you can set up to replicate your organization's regions, such as a Pacific Northwest sales region. You can set up territory geography zones in one application instance, and then after the territory geography zones are defined you can export the territory zones and import them into another application instance.

To define your territory geography zones and then import your territory zones into another application instance, you must complete the following steps:

  1. Import the master reference geography data into the application.

  2. Define your territory geography zones using the Manage Territory Geographies task.

  3. Export the territory geography zones.

  4. Import the territory geography zones into another application instance.

Import the Master Reference Geography Data

Firstly, you must import the master reference geography data. Master reference geography data includes geography elements, such as country, state, and city, and is required for any geographical information that you store in the application, such as address information used in customer and sales records. For more information, see the topic Geography Hierarchy. Master reference geography data can be imported into the application using the Import Management.

Define Your Territory Geography Zones

After the master reference geography data has been imported, you can then create your territory geography zones in the application using the Manage Territory Geographies task in Setup and Maintenance. For more information, see the Manage Territory Geographies topic in the Related Topics section.

Export the Territory Geography Zones

After you have completed importing the master reference geography data and defining your territory geography zone tasks, you can create a configuration package to export the territory zone data. For more information, refer to the Exporting Setup Data demo listed in the related topics section.

Import the Territory Geography Zones

After you have downloaded your configuration package for your territory geography zone setup, you can import the territory zones into another application instance.

Note: Ensure that you import your master reference geography data into the new application instance before you import the configuration package.

Set Up Geocoding

This topic explains geocoding and how to enable this option in the application.

Geocoding is the process of finding latitude and longitude coordinates from geographic data such as street addresses or postal codes. Once these coordinates are available, you can use the spatial services feature to identify points of interest, such as customer and contact addresses, in the vicinity. The application integrates the Geocoding feature with eLocation (http://elocation.oracle.com/maps_oracle_dot_com_main.html), which is a Geocoding service provided by Oracle.

By default, the Geocoding option is turned off in the application. You can enable the Geocoding option by going to the Setup and Maintenance work area and performing the following:

  • Offering: Customer Data Management

  • Functional Area: Enterprise Profile

  • Task: Manage Geographies

If the Geocoding feature is enabled, the feature can be scheduled to run at regular time intervals. This ensures that newly created or updated locations are picked up and geocoded whenever you create or update an address using the user interface, web services, bulk import, or using import management.

Set Up Geocoding

This procedure lists the steps to set up geocoding in Oracle Cloud applications.

Geocoding is a process that determines the latitude and longitude coordinates for a location. By default, geocoding is turned off in the application. You can use geocoding to display customers in the vicinity of a mobile address.

Enable Geocoding for a Country

To enable geocoding for a country, complete these steps:

  1. In the Setup and Maintenance work area, go to the following:

    • Offering: Customer Data Management

    • Functional Area: Enterprise Profile

    • Task: Manage Geographies

  2. On the Manage Geographies page, search for the country for which you want to enable geocoding. You can either search by the country name or country code.

  3. Click Search. The search results for the matching country names are displayed.

  4. Select the country for which you want to enable the geocoding option.

  5. Select Geocoding Defined for the country.

Populate Location Latitude and Longitude Information

Once geocoding is enabled, you can schedule this feature to run at regular time intervals so that newly created or updated locations are picked up and geocoded. To schedule the geocoding feature to run at regular intervals, complete these steps:

  1. Navigate to Tools > Scheduled Processes work area.

  2. On the Overview page, click Actions > Schedule New Process.

  3. Click the Name list and search for Populate Location Latitude and Longitude Information, and then click OK.

  4. Enter the parameters such as Start Date and End Date, and click Submit.

Use Web Services to Populate Location Attributes for the Around Me Feature

Use this procedure to populate location attributes using Web services for the Around Me feature in countries that aren't supported by the eLocation service. The Around Me feature enables you to quickly locate information about your surroundings. This feature uses your current location to run a proximity search on objects with location information, such as contacts, opportunities, and customers.

Create an Address with the Location Attributes Using the LocationService Web Service

Perform the following steps to create an address with location attributes, such as latitude and longitude, using the createLocation operation.

  1. Extract the Web Services URL

    1. Sign in to the Oracle Enterprise Manager Applications Control using the WebLogic Server credentials.

    2. Select Oracle Fusion Customer Relationship Management from the navigation tree, and then select Fusion Applications.

    3. From the tree, select CrmCommonApp, and then select CrmCommonApp (CRMCommonServer_1).

    4. In the Web Services pane, click Test for the LocationServiceSoapHttpPort port.

    5. In the Test Web Service pane, copy the URL of a WSDL that appears in the WSDL field until "?wsdl", and then paste to a notepad.

  2. Derive the Payload

    1. Launch the WSDL URL in a Web browser to open the LocationService endpoint page.

    2. In the LocationServiceSoapHttpPort pane, select createLocation from the Operation list.

    3. In the Location pane, complete the fields, as shown in the following table.

      Field Value

      Country

      CN

      Address1

      Chaoyang District

      City

      Shanghai

      Postal Code

      200233

      State

      China

      CreatedByModule

      AMS

      Latitude

      20.36789

      Longitude

      -39.34444

      Note: Deselect all the other parameters in this Location pane. Also, deselect LocationProfile, OriginalSystemReference, and LocationInformation options.
    4. Click the XML Source option.

      Note: This option appears next to the Operation list.
    5. Copy the XML source and paste to a notepad.

  3. Call the Web Service

    1. Open the Oracle Fusion Service Tester page.

    2. In the WebService URL field, paste the WSDL URL that you derived from Step 5 of the Extracting the Web Services URL section.

    3. Enter the user name and password credentials.

    4. In the Payload pane, paste the XML source that you derived from Step 5 of the Deriving the Payload section.

    5. Click Invoke. The Output Payload pane displays the output payload.

  4. Test the Web Service

    1. Sign in to the Oracle Fusion Applications Home Page.

    2. Navigate to the Customer Center work area.

    3. Search the address that you added.

    4. Click the Addresses section.

    5. From the Actions list, select the View Geography Information option.

    6. Verify the latitude and longitude details.

Update the Location Attributes of an Address Using the LocationService Web Service

Perform the following steps to update the location attributes of an address, such as latitude and longitude, using the updateLocation operation.

  1. Extract the Web Services URL

    1. Sign in to the Oracle Enterprise Manager Applications Control using the WebLogic Server credentials.

    2. Select Oracle Fusion Customer Relationship Management from the navigation tree, and then select Oracle Fusion Applications.

    3. From the tree, select CrmCommonApp, and then select CrmCommonApp (CRMCommonServer_1)

    4. In the Web Services pane, click Test for the LocationServiceSoapHttpPort port.

    5. In the Test Web Service pane, copy the URL of a WSDL that appears in the WSDL field until "?wsdl", and then paste to a notepad.

  2. Derive the Payload

    1. Launch the WSDL URL in a Web browser to open the LocationService endpoint page.

    2. In the LocationServiceSoapHttpPort pane, select updateLocation from the Operation list.

    3. In the Location pane, complete the fields, as shown in the following table.

      Field Value

      LocationId

      300100078489616

      Note: Enter the location ID that was generated in Step 1 of the Testing the Results section.

      Latitude

      30.36789

      Longitude

      -40.34444

      Note: Deselect all the other parameters in this Location pane. Also, deselect LocationProfile, OriginalSystemReference, and LocationInformation options.
    4. Click the XML Source option.

      Note: This option appears next to the Operation list.
    5. Copy the XML source and paste to a notepad.

  3. Call the Web Service

    1. Open the Oracle Fusion Service Tester page.

    2. In the WebService URL field, paste the WSDL URL that you derived from Step 5 of the Extracting the Web Services URL section.

    3. Enter the user name and password credentials.

    4. In the Payload pane, paste the XML source that you derived from Step 5 of the Deriving the Payload section.

    5. Click Invoke. The Output Payload pane displays the output payload.

  4. Test the Web Service

    1. Sign in to the Oracle Fusion Applications Home Page.

    2. Navigate to the Customer Center work area.

    3. Search the address that you updated.

    4. Click the Addresses section.

    5. From the Actions list, select the View Geography Information option.

    6. Verify the latitude and longitude details.

Address cleansing validates, corrects, and standardizes address information that you enter in the application. Address cleansing, unlike geography validation, validates both the geography attributes and the address line attributes.

To use the address cleansing functionality, you need to have license for the customer data quality application, because the feature is delivered using data quality integration.

You can specify the real-time address cleansing level for each country by choosing either of these options:

  • None: Specifies no real time address cleansing.

  • Optional: Provides option to cleanse addresses.

Once you have enabled address cleansing for a country, a Verify Address icon appears at address entry points in the application. Click the icon to perform address cleansing and receive a corrected, standardized address. If the application doesn't find a matching address, then an alert message is displayed.

FAQs for GBG | Loqate Support

How to Import Nokia Geography Data

We recommend that you use GBG | Loqate geography data. However, if you need to use Nokia data for one or more countries for business reasons you can do so.

By default, Import Geography Data task invokes GBG | Loqate geography data.

Note: Oracle doesn't support any Nokia geography data fixes.

Perform these steps to import Nokia geography data:

  1. Set the profile value of the ORA_HZ_ENABLE_DAAS_LOQATE profile option to No in the Setup and Maintenance work area by going to the following:

    • Offering: Sales

    • Functional Area: Sales Foundation

    • Task: Manage Administrator Profile Values

  2. Import the Nokia geography data for a country as follows:

    1. Navigate to the Manage Geographies task in the Setup and Maintenance work area by going to the following:

      • Offering: Sales

      • Functional Area: Sales Foundation

      • Task: Manage Geographies

    2. On the Actions menu, Click Import Geography Data for a country.

    Note: The Import Geography Data action is disabled for a country if the geography data for that country isn't available from GBG | Loqate or if the country data is already imported using either GBG | Loqate, Nokia, or any third party geography data.

    After the geography data is loaded, the data provider name (GBG | Loqate or Nokia) is displayed in the Hierarchy Defined section in Manage Geographies.

How many countries does GBG | Loqate support?

GBG | Loqate supports 82 countries. Any additional country support beyond the 82 must be logged as an enhancement request. To log the enhancement request, go to Idea Lab.

Will I be charged for GBG | Loqate data?

There's no charge or licensing requirement for GBG | Loqate geography data.

I am an existing customer, how will I be impacted? Can I import both GBG | Loqate and Nokia geography data?

No. You can import either GBG | Loqate or Nokia geography data, but you can't import from both providers for a single country. We recommend that you use GBG | Loqate geography data because GBG | Loqate supports 82 countries including existing 62 Nokia supported countries.

If you're already using Nokia geography data, you can select one of these two options:

  • Option 1: You need not do anything and continue to use Nokia geography data. Oracle doesn't support any Nokia geography data fixes.

  • Option 2: You can replace Nokia geography data with GBG | Loqate geography data. This is a manual process today. You must follow manual steps and work closely with the support team to import new GBG | Loqate geography data. For more information about this process, see Replace Existing Master Geography Data with Revised Oracle-Licensed Geography Data section in this chapter.

How often are updates to Oracle licensed geography reference data available? How will I be informed about new countries that are supported by Oracle-licensed geography reference data?

The geography data is updated on a quarterly basis but the update of the latest geography data refresh isn't automated. You will be informed about the geography data refresh using release readiness documents.

How is the Geography Data updated? Are updates available for all countries at the same time or only some countries are updated at a time?

When you import the geography data for a country after Release 18C for the first time you would get the latest GBG | Loqate geography data. But if your GBG | Loqate geography data is more than three months old, you have to uptake the latest GBG | Loqate geography data by following Replace Existing Master Geography Data with Revised Oracle-Licensed Geography Data section in this chapter.

Can I import Vertex or other third-party geography data in Manage Geographies?

Yes, you can continue to import geography data of your choice. Oracle provides support for GBG | Loqate geography data out of the box.

Can I import geography data for multiple countries in one import job?

No. You can submit only one import job for a country. After submitting the import job, you can search for a different country and submit another import job for that country. Currently, you can only search and import GBG | Loqate data for one country at a time using the Manage Geographies task in Setup and Maintenance menu.

FAQs for Define Geographies

How You Search Geographies in the Language You Prefer

You must first define the profile option Filter Geographies Using User Language (HZ_GEO_FILTER_BY_USER_LANG) and specify the language you want to use.

  1. Create the profile option as follows:

    1. Click Navigator > My Enterprise > Setup and Maintenance > Search and search for Manage Profile Options.

    2. Click Create new profile option icon and enter the following:

      • Profile Option Code: HZ_GEO_FILTER_BY_USER_LANG

      • Profile Display Name: Filter Geographies Using User Language

      • Application: Trading Community Model

      • Module: Trading Community Model

      • Description: provide the description

      • Start Date: specify a date

    3. Click Save and close.

    4. In Profile Option Levels table, select Enabled and Updateable for the site level.

    5. Click Save and Close.

  2. Set the default value for the profile option as follows:

    1. Click Navigator > My Enterprise > Setup and Maintenance > Search and search for Manage Administrator Profile Values.

    2. Search HZ_GEO_FILTER_BY_USER_LANG as the profile option code.

    3. Add new Site level profile value.

    4. Specify the new profile in the following format:

      <COUNTRY_CODE1>:<GEOGRPHY_LEVEL1>, <GEOGRAPHY_LEVEL2>;<COUNTRY_CODE2><GEOGRAPHY_LEVEL1>

      Where Geography Level values start with value 1 for country and increment for each level that's defined in the country's geography structure setup.

      For example, below are geography levels for United States:

      Country - 1, State - 2, County - 3, City - 4, Postal Code - 5

      Example 1: If you want to filter data for Canadian Cities, then the profile value is CA:3 where CA is the country code for Canada and 3 is geography level value for City.

      Example 2: If you want to filter data for both State and Cities for United States, then value should be US:2,4

      Example 3: If you want to filter data for multiple countries as given in both example 1 and example 2, then use semi colon as delimiter, like CA:3;US:2,4

    5. Click Save and Close.

When address data entered into the application must conform to a particular format, to achieve consistency in the representation of addresses. For example, making sure that the incoming data is stored following the correct postal address format.

You can only update a geography structure by adding existing geography types, or by creating new geography types and then adding them to the geography structure. You can only copy an existing country structure when you're defining a new country structure.

How many levels in a geography structure can I define?

We recommend that you add up to six levels, starting with country at level 1, while defining geography structures. If you add more than six levels containing list of values or validations, then the sixth level and above may not work as expected in the Address UI of accounts, contacts, suppliers, persons, and so on.

If a geography exists for a country geography structure level then you can't delete the level. For example, if a state geography has been created for the United States country geography structure, then the State level can't be deleted in the country geography structure.

Yes. However, the geography type for the geography that you want to add must be already added to the country geography structure.

Yes. In the Manage Geography Hierarchy page you can edit details such as the geography's date range, primary and alternate names and codes, and parent geographies.

Yes. You can add alternative names and codes. Click Navigator > My Enterprise > Setup and Maintenance . Click the Tasks menu and click Search. Search for Manage Geographies and open it. Search for a country by Country Name or Country Code. Click Actions > Edit. Click Actions > Add on the Edit Country page to add the Primary and Alternative Names or the Primary and Alternative Codes.

Select the geography that you want to create a geography at lower level, and then click the Create icon. This lets you create a geography for a geography type that's one level lower to the geography type you selected. The structure of the country's geography types are defined in the Manage Geography Structure page.

You can track the progress of the geography structure and hierarchy import process by navigating to the Scheduled Processes page and viewing the status of the third-party geography data import process. Once the process completes, the status changes to Succeeded. You can then verify the newly imported geography structure and hierarchy in the Setup and Maintenance work area by navigating to the following: offering: Customer Data Management; functional area: Enterprise Profile; task: Manage Geographies, where you first loaded the third-party geography data.

Note: Before you load geography data for a country from a third party provider, ensure that no geography structure or hierarchy is saved for that country. If geography structure or hierarchy data is already available, the load process fails.

How can I enable geocoding?

You can enable geocoding for a country by turning the Geocoding option for that country in the Setup and Maintenance work area by going to the following: offering: Customer Data Management; functional area: Enterprise Profile; task: Manage Geographies. Search for the country for which you want to enable geocoding and click the Geocoding Defined icon. If geocoding is enabled for a country, the Geocoding Defined icon displays a check mark.

Once you have enabled geocoding for a country, you must run the Run Geocode Generation ESS job on the Run Geocode Generation task. Before you run the job, however, ensure that you have specified the country code of the country for which you want to generate the geocodes.

You can search for and view the geocode values of a party's location in the Party Center and the Customer Center pages. Navigate to the Addresses section of the party's profile and click either View, Columns, Latitude and View, Columns, Longitude, or View, Columns, Manage Columns, Latitude and Longitude. This displays the latitude and longitude, or geocode values, associated with the location of the party.

Note: Geocode information display is available only when geocoding is enabled for the country to which the address belongs.

What are Spatial Services?

Spatial services allow users to find points of interest such as customers, contacts, and so on using the latitude and longitude coordinates of an address.

The Oracle Fusion Mobile Sales application provides these services for sales representatives to discover accounts and contacts around their location.

Where can I update and view the geography name reference information for parties?

To view the geography name reference information associated with parties, you need to ensure that you have created an address for the party. You can create or update party addresses in the Organizations, Persons, and Groups work areas.

Once you have updated an address, you must either wait for the Run Geocode Generation ESS job to run automatically as scheduled or start geocode generation manually from the Setup and Maintenance work area by navigating as follows: offering: Customer Data Management; functional area: Enterprise Profile; task: Run Geocode Generation.

Once the Run Geocode Generation job has updated the geography information for the country associated with the party you updated, you can search for and view the geography name reference information associated with the party in the Organizations, Persons, and Groups work areas. Navigate to the person, organization, or group whose address you want to verify and click Actions, View Geography Information. This displays a dialog box that displays the updated geography information, complete with address values enhanced using geography name reference.

Note: Geography name reference enriched geography information display is available only when geography validation is enabled for the country to which the address belongs.

How can I save an address that didn't pass geography validation?

Search and select for the country name in the Manage Geographies page, and then click the Validation Defined option. In the Manage Geography Validation page, select No Validation in the Geography Validation Level for Country drop-down list. This option saves addresses that don't pass the geography validation, including incomplete and invalid addresses.