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.


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 at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute...


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