Errors Importing Data (Doc ID 1982325.1)

Last updated on JANUARY 10, 2017

Applies to:

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

Symptoms

When attempting to import 2000 records, first 1000 rows import perfectly and 2nd 1000 rows are all error out.
the following error occurs.

ERROR
-----------------------
 You must provide values for column PARTY_ORIG_SYSTEM and column PARTY_ORIG_SYSTEM_REFERENCE or for none of them. (HZ-120494) The reference to the party is invalid, or the party does not exist. (HZ-120737) Details: The party must exist either in the import batch or in the registry. Ensure you have provided a valid reference to the party. An error occurred during the data import. (MKT-285235) Details: This error occurred while importing data: Too many objects match the primary key null. for OrganizationProfile_PartyNumber.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into fusion application.
2. Navigator > Setup and Maintenance
3. Import the csv file.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot able to import more than 1000 records at a time.

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