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:

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

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