Opportunity Import With Custom Fields Unsuccessfull : ORA-00942 ODI-1240 ODI-1228: Task OPTY Load (Integration) fails on the target ORACLE connection ORACLE_FUSION. (Doc ID 1954597.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Opportunity Management - Version 11.1.8.0.0 and later
Oracle Fusion Opportunity Management Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

Opportunity Import fails with error


ERROR
-----------------------
ODI-1240: Flow OPTY Insert fails while performing a Integration operation. This flow loads target table MOO_OPTY.
ODI-1228: Task OPTY Load (Integration) fails on the target ORACLE connection ORACLE_FUSION.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(a) Go to Navigator > File Import
(b) On 'Manage Import Activities' page, create Import Activity
(c) Select data file -- PROD_AMN_Import_OPPTY_OPEN.csv
(d) Activate Import task

 

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