Import Unsuccessful (Doc ID 2278953.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Sales - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms


Im updating a list of opportunity line revenues. I have around 3000 records which i have split into batches around 500 each. i have got almost all successfully updated except the last patch of around 230 records, i get the final status "Unsuccessful" with no clear error message.

The Import Activity Identifier is (300000013447791)
Object : Opportunity
Status : Unsuccessful
Start Date : 2017/06/12 10:28:22 AM

even though the status is "Completed with errors" but almost 99% of records are updated.


ERROR
-----------------------
ODI-1226: Step ErrorHandler fails after 1 attempt(s).
ODI-1232: Procedure ErrorHandler execution fails.
ODI-1228: Task ErrorHandler (Procedure) fails on the target ORACLE connection ORACLE_FUSION.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

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