My Oracle Support Banner

Errors Importing Data (Doc ID 1982325.1)

Last updated on DECEMBER 22, 2020

Applies to:

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


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

 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.

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.

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


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.