The Foreign Key For The Column PRIMARY_CONTACT_ID Is Invalid (Doc ID 2276724.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms

On : 11.1.11.1.0 version, Leads, Sales Campaigns

When attempting to update the Account and Contact details through import for Leads, the following error occurs.

ERROR
-----------------------
The foreign key for the column CUSTOMER_ID is invalid. Enter a valid value. (HZ-120496)
MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE (MKT- -1) Details: MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE Cause: The message, MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE, can not be accessed. Action: Report this problem to an administrator.
MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE (MKT- -1) Details: MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE Cause: The message, MKT-MKT_IMP_ERR_INV_FK_OR_INACTIVE, can not be accessed. Action: Report this problem to an administrator.
The foreign key for the column PRIMARY_CONTACT_ID is invalid. Enter a valid value. (HZ-120496)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Prepare the import file and login into application
2. Create a import job and do the mapping
3. Submit the job
4. After some time the job fails with above errors

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