My Oracle Support Banner

The value for column XXXXX must be a value defined in the lookup type XXXXX. (HZ-120113) (Doc ID 2461697.1)

Last updated on DECEMBER 22, 2020

Applies to:

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


On : version, Accounts, Contacts, Households

The Contact import is resulting in errors.

The value for column PersonProfile_SalesBuyingRoleCode must be a value defined in the lookup type HZ_SLS_CNTCT_BUY_ROLE_CODE. (HZ-120113)
The value for column PersonProfile_SalesBuyingRoleCode must be a value defined in the lookup type HZ_SLS_CNTCT_BUY_ROLE_CODE. (HZ-120113)

The issue can be reproduced at will with the following steps:
1. Sign-on to Sales Cloud application
2. Navigate to Setup and Maintenance > Manage File Import Activities
3. Click Actions > Create (or the Create icon)
4. Create a Contact import with the following mapping:
ContactRelationship PrimaryCustomerFlag
ContactRelationship ObjectId
ContactRelationship RelOrigSystem
ContactRelationship RelOrigSystemReference
PersonProfile PersonPreNameAdjunct
PersonProfile PersonFirstName
PersonProfile PersonMiddleName
PersonProfile PersonLastName
PersonProfile JobTitle
PersonProfile SalesAffinityCode
PersonProfile SalesBuyingRoleCode
PersonProfile PartyOrigSystem
PersonProfile PartyOrigSystemReference
PersonProfile PartyNumber
ContactEmail EmailAddress
ContactEmail PrimaryFlag
ContactEmail CpOrigSystem
ContactEmail CpOrigSystemReference
ContactJob JobTitle
ContactJob PrimaryFlag
ContactJob SalesInfluenceLevelCode
ContactJob RelOrigSystem
ContactJob RelOrigSystemReference
ContactFax PhoneCountryCode
ContactFax PhoneAreaCode
ContactFax PhoneNumber
ContactFax PhoneExtension
ContactFax CpOrigSystem
ContactFax CpOrigSystemReference
ContactMobile PhoneCountryCode
ContactMobile PhoneAreaCode
ContactMobile PhoneNumber
ContactMobile CpOrigSystem
ContactMobile CpOrigSystemReference
Phone ContactPointPurpose
Phone PhoneCountryCode
Phone PhoneAreaCode
Phone PhoneNumber
Phone PhoneExtension
Phone CpOrigSystem
Phone CpOrigSystemReference
Address Address1
Address Address2
Address Address3
Address City
Address State
Address PostalCode
Address null
Address Country
Address SiteOrigSystem
Address SiteOrigSystemReference
Address LocationOrigSystem
Address LocationOrigSystemReference
PersonProfile OwnerPartyId
PersonProfileExtn ARC_Seniority_c

The issue has the following business impact:
Due to this issue, users cannot import the records.




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

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