Method getHavingList Fails In ODI 12c When pDSIndex Parameter Is Omitted

(Doc ID 2242794.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.2.6 [Release 12c]
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12c, the substitution of the following getHavingList() method in the LKM fails:

<%=odiRef.getHavingList("having ", "([EXPRESSION])", " and ", "")%>

Observe above, the pDSIndex parameter is being omitted.

However, according to the ODI 12c documentation:

Fusion Middleware Developing Knowledge Modules with Oracle Data Integrator
> Substitution API Reference
> Loading Knowledge Modules
> getHavingList() Method

available at: http://docs.oracle.com/middleware/122126/odi/develop-km/GUID-5A73E952-7E55-4F61-89BD-FB6641035C4D.htm#GUID-A170F5D3-E9FA-4151-8E31-A11B97FB195F

The pDSIndex parameter can be omitted when this method is used in an LKM. It can be also omitted for IKMs. In this case, the dataset taken into account is the first one.

Note when consulting the Session Task in the ODI Operator, instead of the expected SQL code, the following is observed:

...
Sourced file: inline evaluation of: ''out.print("update ");out.print(odiRef.getTable("L", "COLL_NAME", "W"));out.print . . . '' : Error in method invocation: Method getHavingList( java.lang.String, java.lang.String, java.lang.String, java.lang.String ) not found in class'oracle.odi.domain.odireference.OdiRef'
...

Changes

Cause

	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 hundreds of Community platforms