FTP, ALM, or BSP Cash Flow Engine Processes Fail with SIGSEGV and ''FC_TimeDepIRC::InitiateRows()' Error (Doc ID 1605457.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Balance Sheet Planning - Version 8.0.0 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

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