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 188.8.131.52.0 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:
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!