ORA-03113, ORA-03114, ORA-01041, and ORA-07445 Errors Running OFSA 4.5 Transformation IDs on 9.2.0.5 (Doc ID 276513.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version: 4.5

Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

In OFSA 4.5, when running a Transformation ID, an 'Internal Error' is generated. From the ofste.XXXXXX log file, the following errors are displayed:

ERROR
OCI Function: [4] - oexec(), oexn()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-03113: end-of-file on communication channel

Driver Function: drv_oci::Execute()

SQL Statement: BEGIN
OFSA_SQL.IA_CREATE_TABLE('OFSA_EULOWNER',101931,0,0,'LEDGER_STAT','(((LEDGER_STAT.ORG_UNIT_ID =
4894))) AND LEDGER_STAT.YEAR_S >= 2001 AND LEDGER_STAT.YEAR_S <=
2007','ORG_UNIT_ID,GL_ACCOUNT_ID,COMMON_COA_ID,PRODUCT_ID,OSB_SOURCE_ORG_ID,CONSOLIDATION_CD,ISO_CU
RENCY_CD,CURRENCY_TYPE_CD,SET_OF_BOOKS_CD',51,'OSB_RPT_LS_2','455,457,200010',65); END;
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [16] - oclose()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-01041: internal error. hostdef extension doesn't exist

Driver Function: drv_oci::EndSQL

SQL Statement: BEGIN
OFSA_SQL.IA_CREATE_TABLE('OFSA_EULOWNER',101931,0,0,'LEDGER_STAT','(((LEDGER_STAT.ORG_UNIT_ID =
4894))) AND LEDGER_STAT.YEAR_S >= 2001 AND LEDGER_STAT.YEAR_S <=
2007','ORG_UNIT_ID,GL_ACCOUNT_ID,COMMON_COA_ID,PRODUCT_ID,OSB_SOURCE_ORG_ID,CONSOLIDATION_CD,ISO_CU
RENCY_CD,CURRENCY_TYPE_CD,SET_OF_BOOKS_CD',51,'OSB_RPT_LS_2','455,457,200010',65); END;
Error(Oracle Financial Services Application error) (910001) Unable to process
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error

OCI Function: [14] - oopen()
SQL Function: [0] - SQL function not found!
Oracle Error: ORA-03114: not connected to ORACLE
Driver Function: drv_oci::BeginSQL()
Error(Oracle Financial Services Application error)
(203105) Oracle drv_oci error:

The alert.log for the same time period shows the error:

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Current SQL statement for this session:

Changes

Recently upgraded to Oracle 9.2.0.5.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms