Transformation Batch Fails with 'Could not Connect to the Database from Login Information'
(Doc ID 2161166.1)
Last updated on JANUARY 17, 2018
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and laterOracle 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |