Incentive Compensation Analytics ETL Failed Due To CN_N_HIER_ID Variable

(Doc ID 2165843.1)

Last updated on JULY 27, 2016

Applies to:

Oracle Incentive Compensation Analytics for Oracle Data Integrator - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running the Incentive Compensation Analytics ETL failed due to the variable(CN_N_HIER_ID) not retrieving any value.  The following error is received:

java.lang.Exception: ODI-17511: No value to be set to variable 'CN.CN_N_HIER_ID'. at
oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(Refresh
VariableExecutor.java:70) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute...

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