11 Replies Latest reply: Sep 21, 2013 2:11 PM by 1007772 RSS

    DAC Execution Plan turns error on Task SDE_ORA_GL_AR_REV_LinkageInformation

      Dear All,

      Please kindly help me to solve this issue.
      I am trying to run an execution plans which same as "Financials_Oracle R1211" Execution Plan. Returns some errors, one of those error is on Informatica, the detail is :
      DAC Task : SDE_ORA_GL_AR_REV_LinkageInformation_Extract
      DAC Task Detail : SDE_ORA_GL_AR_REV_LinkageInformation_Extract_Full INSTANCE 1
      Status Description : Error while executing : INFORMATICA TASK:SDE_ORAR1211_Adaptor:SDE_ORA_GL_AR_REV_LinkageInformation_Extract_Full:1:(Source : FULL Target : FULL)

      From the status description, I can't see the reliable reason that cause this error.
      So I look into informatica logs folder : INFA_HOME/server/infa_shared/SessLogs and found this one log : .SDE_ORA_GL_AR_REV_LinkageInformation_Extract_Full.ORA_R1211
      In that log, I found SQL script that generated from Informatica :

      User specified SQL Query [SELECT bla bla bla
                                           NVL(XLA_EVENTS.UPG_BATCH_ID,0) UPG_BATCH_ID
                                            FROM XLA_DISTRIBUTION_LINKS DLINK
                                           , GL_PERIODS   PER
                                          WHERE bla bla bla]
      READER_1_1_1> RR_4049 SQL Query issued to database : (Tue Jun 04 17:09:18 2013)
      READER_1_1_1> CMN_1761 Timestamp Event: [Tue Jun 04 17:09:18 2013]
      READER_1_1_1> RR_4035 SQL Error [
      ORA-00904: "XLA_EVENTS"."UPG_BATCH_ID": invalid identifier

      You can see that NVL(XLA_EVENTS.UPG_BATCH_ID,0) UPG_BATCH_ID is taken from table XLA_EVENTS, and XLA_EVENTS Table is not exist in FROM clause, that is the reason why the mapping failed. Then I try to look the mapping in Informatica Mapping Designer, and see the Source Qualifier, but the query there is fine, which XLA_EVENTS Table is exists in FROM clause.

      If anyone could help me to solve this, thank you.