This discussion is archived
1 Reply Latest reply: Nov 19, 2012 11:39 PM by Voltaire RSS

Load Row into Run table issue

Prashant_biapps Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points