1 Reply Latest reply: Nov 20, 2012 1:39 AM by Voltaire RSS

    Load Row into Run table issue

    Prashant_biapps
      Hi All,

      I am working on BI APPS 7.9.6.3, financial module.

      I am doing full load, but it show task failed.
      Task name: SIL_InsertRowInRunTable

      Error:

      ORA-00900: invalid SQL statement

      Database driver error...
      Function Name : executeDirect
      SQL Stmt : DWH
      Oracle Fatal Error
      Database driver error...
      Function Name : ExecuteDirect

      Oracle Fatal Error

      ]

      MAPPING> CMN_1761 Timestamp Event: [Tue Nov 20 10:59:06 2012]
      MAPPING> CMN_1076 ERROR creating database connection.
      MAPPING> DBG_21520 Transform : LKP_W_PARAM_G_Get_ETL_PROC_WID, connect string : Relational:DWH

      MAPPING> CMN_1761 Timestamp Event: [Tue Nov 20 10:59:06 2012]
      MAPPING> TE_7017 Internal error. Failed to initialize transformation [MPLT_GET_ETL_PROC_WID.LKP_ETL_PROC_WID]. Contact Informatica Global Customer Support.
      MAPPING> CMN_1761 Timestamp Event: [Tue Nov 20 10:59:06 2012]
      MAPPING> TM_6006 Error initializing DTM for session [SIL_InsertRowInRunTable].
      MANAGER> PETL_24005 Starting post-session tasks. : (Tue Nov 20 10:59:06 2012)
      MANAGER> PETL_24029 Post-session task completed successfully. : (Tue Nov 20 10:59:06 2012)
      MAPPING> TM_6018 The session completed with [0] row transformation errors.
      MANAGER> PETL_24002 Parallel Pipeline Engine finished.
      DIRECTOR> PETL_24013 Session run completed with failure.
      DIRECTOR> TM_6022


      how to reslove this issue.
      Please give me your suggestion.

      Thanks in advance
      Prashant