My Oracle Support Banner

'java.lang.Exception: Oracle Data Integrator Function does not exist' Error When Executing a Step that Uses A New Open Tool Added (Doc ID 989266.1)

Last updated on JUNE 16, 2022

Applies to:

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


The  following error occurs after added an new Open Tool (called ODITest) following ODI documentation and executing a step in an ODI Package that uses this Open Tool.

java.lang.Exception: Oracle Data Integrator Function does not exist
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(


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

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