Transformation Batch Fails with 'Could not Connect to the Database from Login Information'
Last updated on JANUARY 17, 2018
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 22.214.171.124.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)
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
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.
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