My Oracle Support Banner

You must provide values for column LOCATION_ORIG_SYSTEM and column LOCATION_ORIG_SYSTEM_REFERENCE or for none of them. (HZ-120494) (Doc ID 2401334.1)

Last updated on JUNE 04, 2018

Applies to:

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

Goal

Users are unable to import any Contacts into the Sales Cloud system. The File Import Activities are failing (Status of Completed with errors), citing the following errors in the log file for each Contact record in the import file:

The value in the column Address Country is invalid. You must enter a valid TERRITORY_CODE from table FND_TERRITORIES. (HZ-120736)
The foreign key value {FK} is invalid. (HZ-120080)
You must provide values for column LOCATION_ORIG_SYSTEM and column LOCATION_ORIG_SYSTEM_REFERENCE or for none of them. (HZ-120494)

These don't seem to be specific to the issue - the Address Country used is valid (FR, DE) and we are providing values mapped to the Location Orig System and Location Orig System Reference.

The mapping used is following the seeded mapping template "Contact Create and Update Predefined Mapping" in the same system.

 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.