Oracle Sales Cloud Relationship File Import Activity (Doc ID 2247468.1)

Last updated on MARCH 31, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Accounts, Contacts, Households

Client cannot identify where the error is in the data that they populated.

ERROR
-----------------------
1. You must enter a party name. (HZ-120051) Cause: At least one of the required name fields in the HZ_IMP_PARTIES_T table is missing a value. Action: Enter ORGANIZATION_NAME for an organization. Enter PERSON_FIRST_NAME or PERSON_LAST_NAME or both for a person.

2. The combination of columns OrganizationProfile.PartyOrigSystem and OrganizationProfile.PartyOrigSystemReference must be unique in table HZ_IMP_PARTIES_T. (HZ-120149)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import relationships
2. See that it completed with errors
3. See the errors in the logs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have all of their records import successfully.

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