Lead Import Job Completed With Status "Completed with errors"

(Doc ID 1910772.1)

Last updated on JUNE 20, 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.

Goal

A Lead import job completed with Status "Completed with errors". 

The MKT_IMP_ERRORS table shows the following error.

100000001597369 ERROR MKT_IMP_LEAD_RESOURCES_1691850 300000004898710 300000004898730 MKT_IMP_ERR_INV_FK_OR_INACTIVE RECORD_TYPE Resource ATTRIBUTE_NAME RESOURCE_ID 2014-07-18 13:07:25.0 BULK_IMPORT 2014-07-18 13:07:25.0 BULK_IMPORT FUSION_APPS_CRM_ODI_ESS_APPID 1 1
100000001597370 ERROR MKT_IMP_LEAD_RESOURCES_1691850 300000004898710 300000004898730 MKT_IMP_ERR_INV_FK_OR_INACTIVE RECORD_TYPE Resource ATTRIBUTE_NAME USERNAME 2014-07-18 13:07:25.0 BULK_IMPORT 2014-07-18 13:07:25.0 BULK_IMPORT FUSION_APPS_CRM_ODI_ESS_APPID 1 1

 

Solution

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