Analytics Software

Hi,

I'm running an Oracle BI Apps 7.9.6 install with R12 Oracle vision instance. DAC (v10.1.3.4.1) and Informatica (8.6 applied Hotfix already) are setup properly. I tried to do a test run with just Oracle R12 Financial - Receivable and it failed in the SIL_InsertRowInRuntable Failed step. I output the error to a file and traced all the way to the server\infa_shared\SrcFiles\ORA_R12_Flatfile.DataWarehouse.SILOS.SIL_InsertRowInRunTable.txt SIL_InsertRowInRunTable. And in this file, it mentions the $$FlatFileConnection=ORA_R12_Flatfile. In the Physical Data Source, the warehouse and Oracle R12 source connection work fine but the ORA_R12_Flatfile is not working. It doesn't mention anything about the flatfile connection setup in the BI apps setup/configuration doc. In some blogs, it even talks about deleting some of the unneccessary connections. I know for a fact that I will need the flatfile connection to bring in some of the flat files. Any suggestions?

ORA_R12_Flatfile.DataWarehouse.SILOS.SIL_InsertRowInRunTable.txt SIL_InsertRowInRunTable

[SILOS.SIL_InsertRowInRunTable]
$$ANALYSIS_END=01/01/2011 12:59:00
$$ANALYSIS_END_WID=20110101
$$ANALYSIS_START=12/31/1979 01:00:00
$$ANALYSIS_START_WID=19791231
$$COST_TIME_GRAIN=QUARTER
$$CURRENT_DATE=08/10/2009
$$CURRENT_DATE_IN_SQL_FORMAT='2009-08-10 17:16:27.14'
$$CURRENT_DATE_WID=20090810
$$DATASOURCE_NUM_ID=9
$$DEFAULT_LOC_RATE_TYPE=Corporate
$$DFLT_LANG=US
$$ETL_PROC_WID=20832376
$$FILTER_BY_LEDGER_ID='N'
$$FILTER_BY_LEDGER_TYPE='N'
$$FlatFileConnection=ORA_R12_Flatfile
$$GBL_CALENDAR_ID=Accounting~41
$$GBL_DATASOURCE_NUM_ID=9
$$GLOBAL1_CURR_CODE=USD
$$GLOBAL1_RATE_TYPE=Corporate
$$GLOBAL2_CURR_CODE=USD
$$GLOBAL2_RATE_TYPE=Corporate
$$GLOBAL3_CURR_CODE=USD
$$GLOBAL3_RATE_TYPE=Corporate
$$HI_DATE='3714-01-01 00:00:00.0'
$$HI_DT=01/01/3714 12:00:00
$$HR_ABSNC_EXTRACT_DATE='1980-01-01 08:19:00.0'
$$HR_WRKFC_ADJ_SERVICE_DATE='N'
$$HR_WRKFC_EXTRACT_DATE=01/01/1970
$$HR_WRKFC_SNAPSHOT_DT='2004-01-01 00:00:00.0'
$$HR_WRKFC_SNAPSHOT_TO_WID=20090810
$$Hint1=
$$Hint2=
$$Hint_Tera_Post_Cast=
$$Hint_Tera_Pre_Cast=
$$INITIAL_EXTRACT_DATE=06/30/2005
$$INVPROD_CAT_SET_ID=27
$$INV_PROD_CAT_SET_ID10=
$$INV_PROD_CAT_SET_ID1=27
$$INV_PROD_CAT_SET_ID2=
$$INV_PROD_CAT_SET_ID3=
$$INV_PROD_CAT_SET_ID4=
$$INV_PROD_CAT_SET_ID5=
$$INV_PROD_CAT_SET_ID6=
$$INV_PROD_CAT_SET_ID7=
$$INV_PROD_CAT_SET_ID8=
$$INV_PROD_CAT_SET_ID9=
$$LANGUAGE_CODE=E
$$LAST_EXTRACT_DATE=
$$LAST_EXTRACT_DATE_IN_SQL_FORMAT=
$$LAST_EXTRACT_DATE_WID=
$$LAST_TARGET_EXTRACT_DATE_IN_SQL_FORMAT=
$$LEDGER_ID_LIST=1
$$LEDGER_TYPE_LIST='NONE'
$$LOAD_DT='2009-08-10 17:15:37.907'
$$LOW_DATE=TO_DATE('1899-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
$$LOW_DT=01/01/1899 00:00:00
$$MASTER_CODE_NOT_FOUND=
$$ORA_HI_DATE=TO_DATE('4712-12-31 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
$$PROD_CAT_SET_ID10=
$$PROD_CAT_SET_ID1=2
$$PROD_CAT_SET_ID2=
$$PROD_CAT_SET_ID3=
$$PROD_CAT_SET_ID4=
$$PROD_CAT_SET_ID5=
$$PROD_CAT_SET_ID6=
$$PROD_CAT_SET_ID7=
$$PROD_CAT_SET_ID8=
$$PROD_CAT_SET_ID9=
$$PROD_CAT_SET_ID=2
$$SOURCE_CODE_NOT_SUPPLIED=
$$TENANT_ID=DEFAULT
$$WH_DATASOURCE_NUM_ID=999
$DBConnection_OLAP=DataWarehouse
$DBConnection_OLTP=PARAM_OLTP_SIEBEL
$PMSessionLogFile=ORA_R12_FLATFILE.DATAWAREHOUSE.SILOS.SIL_InsertRowInRunTable.log
MPLT_GET_ETL_PROC_WID.$$ETL_PROC_WID=20832376