Opportunity Import Error : "The process fails to load data into import interface tables. Cause: java.lang.Exception: Failed to construct the staging loader object" (Doc ID 2120273.1)

Last updated on APRIL 12, 2016

Applies to:

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

Symptoms

On : 11.1.10.0.0 version, Opportunities

Opportunity File Import Activity Throwing Error

We have created a mapping for Opportunity which maps to all fields used including custom fields. When we run the file import activity , it throws an error at the interface table.


ERROR
-----------------------
The process fails to load data into import interface tables. Cause: java.lang.Exception: Failed to construct the staging loader object. Please validate the AM configuration and the object mapping. The ERROR is : Mapping: object name = Opportunity attribute name = EXTN_ATTRIBUTE_CHAR055 table name = MOO_IMP_OPTY column name = EXTN_ATTRIBUTE_CHAR055 oracle.apps.marketing.commonMarketing.mktImport.loader.stagingLoader.StagingLoader.(StagingLoader.java:250) oracle.apps.marketing.commonMarketing.mktImport.loader.Loader.loadBatch(Loader.java:2127) oracle.apps.marketing.commonMarketing.mktImport.model.applicationModule.ImportAMImpl.loadBatch(ImportAMImpl.java:2207) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) oracle.jbo.server.svc.

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