Transformation Batch Fails with 'Could not Connect to the Database from Login Information' (Doc ID 2161166.1)

Last updated on JULY 21, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and later
Oracle Financial Services Hedge Management and IFRS Valuations - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Hedge Management (HM) 6.1.1, when you run a Batch for a "Transformation" program like fn_popDimAccount, the batch execution fails with the following errors in the RunProc_<bactch>.log from $FIC_DB_HOME/log/date:

ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
Log Message here 1: Tue Jul 05 09:38:20 2016||INFO||Database Type : ORACLE
Log Message here 1: Tue Jul 05 09:38:20 2016||INFO||NLS Value : AMERICAN_AMERICA.UTF8
FAILED: log_on()
CheckErr ::OCI_SUCCESS_WITH_INFO
Log Message here 1: Tue Jul 05 09:38:20 2016||SEVERE||Could not Connect to the Database from Login Information
Log Message here 1: Tue Jul 05 09:38:20 2016||INFO||After Calling execProc
Log Message here 1: Tue Jul 05 09:38:20 2016||SEVERE||Stored procedure execution failed

The error prevents the batch from executing.

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