Last updated on JUNE 21, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 1.0]
Oracle Fusion Sales - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 1.0]
Information in this document applies to any platform.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms