My Oracle Support Banner

HZ_GEO_STRUCT_MAP_DTL & HZ_GEO_STRUCT_MAP Tables Not Getting Populated After Running Import Geography (Doc ID 2519369.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.01.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
HZ_GEO_STRUCT_MAP_DTL & HZ_GEO_STRUCT_MAP tables are not getting populated after running Import Geography from Nokia or Loqate.

The Import Geography process was run for several countries.

The following actions were completed:

  1. Import Geography data for several countries, with Nokia or Loqate options for import;
  2. The Scheduled Process "Import Geography Data" finished successfully;
  3. Did the following actions "Manage Geographies" > Search for the country > Select the country > Complete all the flow for the Geography validation > Drill down in "Validation Defined" > fill the attributes with needed data;
  4. Save and close;
  5. Queried the tables HZ_GEO_STRUCT_MAP_DTL and HZ_GEO_STRUCT_MAP , to see if the data was populated for the countries that were imported, but the data is not there

 

EXPECTED BEHAVIOR

-----------------------
For the imported geographies, to see all data in the tables HZ_GEO_STRUCT_MAP_DTL and HZ_GEO_STRUCT_MAP, after finishing the entire flow for each country.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Import Geography data for several countries, with Nokia or Loqate options for import;
  2. The Scheduled Process "Import Geography Data" finished successfully;
  3. Did the following actions "Manage Geographies" > Search for the country > Select the country > Complete all the flow for the Geography validation > Drill down in "Validation Defined" > fill the attributes with needed data;
  4. Save and close;
  5. Queried the tables HZ_GEO_STRUCT_MAP_DTL and HZ_GEO_STRUCT_MAP , to see if the data was populated for the countries that were imported, but the data is not there



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot upload data correctly, the data is not populated in the tables HZ_GEO_STRUCT_MAP_DTL and HZ_GEO_STRUCT_MAP

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.