My Oracle Support Banner

ODI Mappings Using "IKM SQL to Hyperion Planning" Fail with "ODI-1590: The execution of the script failed. Caused By: javax.script.ScriptException: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found" (Doc ID 2882597.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

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

Symptoms

After upgrade to Oracle Data Integrator (ODI) 12.2.1.4.220112,  ODI mappings that are using the "IKM SQL to Hyperion Planning" are failing with the below error:

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!

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