java.lang.Exception: ODI-17511: No value to be set to variable 'AIF.p_prd_source_coa_id'.

Oracle Community | imran_311 | 1 year ago
  1. 0

    FDMEE unable to import from EBS instance

    Oracle Community | 1 year ago | imran_311
    java.lang.Exception: ODI-17511: No value to be set to variable 'AIF.p_prd_source_coa_id'.
  2. 0

    ODI-17511: No value to be set to variable

    Oracle Community | 1 year ago | 1642743
    java.lang.Exception: ODI-17511: No value to be set to variable 'GLOBAL.VAR_ERROR_MESSAGE'.
  3. 0

    ERPi - ODI meta data load failing

    Oracle Community | 3 years ago | 1712272
    java.lang.Exception: ODI-17511: No value to be set to variable 'AIF.p_profile_option_value'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    gettting ODI-17511: No value to be set to variable.?

    Oracle Community | 1 year ago | SanthoshSreshta
    java.lang.Exception: ODI-17511: No value to be set to variable 'MULTI_DEMO.File_Name'.
  6. 0

    Variable is not refreshing during execution a scenario

    Oracle Community | 7 years ago | 723246
    java.lang.Exception: Variable has no value: MY_PACKAGE.BUDGET_VERSION

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.Exception

      ODI-17511: No value to be set to variable 'AIF.p_prd_source_coa_id'.

      at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute()
    2. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:70)
      2. oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
      3. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      3 frames
    3. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.processTask(SnpSessTaskSqlV.java:410)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTask(SnpSessTaskSqlV.java:240)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)
      5. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      7. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)
      7 frames
    4. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    5. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    6. oracle.odi.runtime
      DefaultAgentTaskExecutor$1.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:50)
      4 frames
    7. Spring Core
      SyncTaskExecutor.execute
      1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
      1 frame
    8. oracle.odi.runtime
      InternalRemoteRuntimeAgentInvoker.invokeStartScenario
      1. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)
      2. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:93)
      3. oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)
      4. oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)
      5. oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:49)
      6. oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:173)
      7. oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:140)
      7 frames
    9. com.sunopsis.dwg
      SnpSessTaskSql.executeOdiCommand
      1. com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:271)
      2. com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)
      3. com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)
      4. com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)
      4 frames
    10. oracle.odi.runtime
      TaskExecutionHandler.handleTask
      1. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
      2. oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
      3. oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
      3 frames
    11. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
      2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
      3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)
      4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
      5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      6. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1931)
      6 frames
    12. oracle.odi.runtime
      StartScenRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
      1 frame
    13. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    14. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
      2. oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
      3. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      4. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
      4 frames
    15. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame