My Oracle Support Banner

Customer Data Import Batches Program Is Completing In Error Without Any Error Message (Doc ID 2440456.1)

Last updated on AUGUST 24, 2020

Applies to:

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

Symptoms

On Oracle Fusion, 11.13.18.05.0 version, Importing customers. Using importing customer, the import process ended with errors


ERROR
------------------
The combination of columns CUST_SITE_ORIG_SYSTEM and CUST_SITE_ORIG_SYS_REF must be unique in table HZ_IMP_ACCTSITES_T.

EXPECTED BEHAVIOR
-----------------------
Expecting to be able to import customers


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. On Navigator
2. Go to Customer Data Management
3. Go to Data Import
4. Import the data
5. Review the process and observed the process ended with errors described


Cause

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
Symptoms
Cause
Solution


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