Cannot Update Geography Codes - HZ_GEO_INVALID_PARENT (Doc ID 2284121.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

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

Symptoms

On : 11.12.1.0.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
-----------------------

Using the Manage File Import Activities to update the alternate code to the existing geographies, the import is unsuccessful.


ERROR
-----------------------
HZ_GEO_INVALID_PARENT

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. manage File Import Activities
2. Object = Geography
3. File = up_peru_chachapoyas_01.csv
4. Mapping:
RecordTypeCode -> ImpGeography.RecordTypeCode
CountryCode -> ImpGeography.CountryCode
ParentSourceId -> ImpGeography.ParentSourceId
SourceId -> ImpGeography.SourceId
PrimaryGeographyName -> ImpGeography.PrimaryGeographyName
LevelNumber -> ImpGeography.LevelNumber
IdentifierSubtype -> ImpGeography.IdentifierSubtype
IdentifierType -> ImpGeography.IdentifierType
IdentifierValue -> ImpGeography.IdentifierValue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete import.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms