FTP, ALM, or BSP Cash Flow Engine Processes Fail with SIGSEGV and ''FC_TimeDepIRC::InitiateRows()' Error
(Doc ID 1605457.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle Financial Services Balance Sheet Planning - Version 8.0.0 and laterOracle Financial Services Asset Liability 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 Funds Transfer Pricing (FTP), Asset Liability Management (ALM), or Balance Sheet Planning (BSP), when running a Cash Flow Engine (CFE) process, all processes are ending in a status of failed. If you run the ALM or FTP process from $FIC_DB_HOME/bin using the command line or check the nohup.out in $FIC_DB_HOME/bin, an error like the one below is output:
$ ./ofstp INFODOM_200123_20130731_1 TP TASK1 20130731 200123 USER1
Warning: iso88951 does not exist.
Host IP--> XX.XXX.XX.XX
HostIP... XX.XXX.XX.XX
Port... XXXX
[AESCryptorImpl.handleJVM]->INFO: JVM created successfully...
[LOG] Starting up.....
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
| strBatchId : INFODOM_200123_20130731_1 | strComponentId : TP | Process ID : 200123 | User ID : USER1 | AS_OF_DATE : 07/31/2013 Connection to the following database was successful: ORCL
Running TP, Process ID: 200123
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f5c1f18aaa1, pid=20763, tid=140033532409584
#
# JRE version: 6.0_45-b06
# Java VM: Java HotSpot(TM) 64-Bit Server VM (20.45-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [librates.so+0x72aa1] FC_TimeDepIRC::InitiateRows()+0x71
#
# An error report file with more information is saved as:
# /app/ofsaa/ficdb/bin/hs_err_pidxxxxx.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
Abort
In BSP, the error is output to BSPCalculation_UnpricedAcc_udf.log in $EPM_ORACLE_HOME/logs/bsplog.
After turning logging on in Application Preferences, an ofstp.xxxxxx.log or ofsrm.xxxxxx.log is created in $FIC_DB_HOME/log/FusionApps when you run the Process. The last SQL statement in the log file is a select from an Interest Rate Code table:
Module Logging OFS Access module data: select
select FSI_IRC_RATE_HIST.interest_rate_cd,
FSI_IRC_RATE_HIST.effective_date,
FSI_IRC_RATE_HIST.interest_rate_term,
FSI_IRC_RATE_HIST.interest_rate_term_mult,
FSI_IRC_RATE_HIST.interest_rate
from FSI_IRC_RATE_HIST
where FSI_IRC_RATE_HIST.interest_rate_cd = 12345.00000
and FSI_IRC_RATE_HIST.effective_date <= '07/ 31/ 2013'
order by FSI_IRC_RATE_HIST.interest_rate_cd,
FSI_IRC_RATE_HIST.effective_date,
FSI_IRC_RATE_HIST.interest_rate_term_mult,
FSI_IRC_RATE_HIST.interest_rate_term
This issue is preventing you from running the cash flow engine successfully.
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 |