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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.