File Import Job - Getting Errors In Importing Records (Doc ID 2211428.1)

Last updated on DECEMBER 08, 2016

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

File Import Job - Getting Errors in Importing Records

Customer is importing a batch of 200 K records and getting errors.

200K batch completed with and error. It shows there are only 4 errors, but it looks like it has stopped at Step 25/40. Something is wrong here.

Import activity identifier is 300000001481363.

ERROR
-----------------------

The following are the 4 records that failed in the data import:
3 errors: 2530 - phone number is invalid, the value in the column Country is invalid (must enter a valid TERRITORY_CODE from table FND_TERRITORIES, and Country value must not exceed 2 characters
3 errors: 70200 - The combination of columns CP_ORIG_SYSTEM and cust_email_osr must be unique in table HZ_IMP_CONTACTPTS_T, the value in the column Country is invalid (must enter a valid TERRITORY_CODE from table FND_TERRITORIES, and Country value must not exceed 2 characters
1 error: 207380 - Enter a party name for this record. There must be at least one of the required fields for HZ_IMP_CONTACTPTS_T. Enter either ORGANIZATION_NAME for an organization, or PERSON_FIRST_NAME or PERSON_LAST_NAME for a person
3 errors: 237601 - The combination of columns CP_ORIG_SYSTEM and cust_email_osr must be unique in table HZ_IMP_CONTACTPTS_T, Country value must not exceed 2 characters, and the value in the column Country is invalid (must enter a valid TERRITORY_CODE from table FND_TERRITORIES

However, we see that the addresses and emails were not imported correctly for other records as the batch failed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a file import
2. Run the file import
3. See resulting errors

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the file import has finished with errors, and it looks like certain steps did not finish correctly.

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