My Oracle Support Banner

ODI Fails to Load XML File with Error "ODI-1227" and "Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found" (Doc ID 2953899.1)

Last updated on JUNE 09, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Oracle Data Integrator - Version and later
Information in this document applies to any platform.


Using Oracle Data Integrator (ODI) 12c to load XML files. Executions fail intermittently with the following error:

To reproduce:

1. Execute a mapping or package that involves loading of XML files
2. Notice the failure

The same execution was working fine previously




To view full details, 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 a vibrant support community of peers and Oracle experts.