My Oracle Support Banner

"ODI-40854: No file provided for synchronization. Use CREATE FILE <file> FROM <schema> command" Signalled When Loading Data From An XML File To Oracle Using The ODI 11.1.1.6.0 XML Driver (Doc ID 1496730.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

While executing a Procedure in Oracle Data Integrator (ODI) 11g, the process fails at Step Synchronize Statement when loading data from XML files to Oracle Database Tables:

Error: "Caused By: java.sql.SQLException: ODI-40854: No file provided for synchronization. Use CREATE FILE <file> FROM <schema> command"

The same procedure works fine in ODI 10g (10.1.3.6).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.