OFSAA ALM 8 Fails With Core Dump in ficdb/bin and C [ofsrm+0x8c620] void BankAccount::FindPPData()+0x3c Errors (Doc ID 2271887.1)

Last updated on JUNE 01, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)

Symptoms

On ALM 8.0.0, an ALM process is currently failing with core dump.

ERROR
The ALM debug log ends abruptly:

Module Logging OFS calculation module data: select
select a.rowid, a.ORG_UNIT_ID, a.GL_ACCOUNT_ID, a.COMMON_COA_ID,
  a.PRODUCT_ID, a.LEGAL_ENTITY_ID, a.CUSTOMER_ID,
  a.iso_currency_cd, a.id_number, a.identity_code,
  a.account_number, a.HOLIDAY_CALENDAR_CODE,
  a.HOLIDAY_ROLLING_CONVENTION_CD, a.HOLIDAY_CALC_OPTION_CD,
  a.instrument_type_cd, a.as_of_date, a.accrual_basis_cd,
  a.amrt_term, a.amrt_term_mult, a.amrt_type_cd, a.cur_book_bal,
  a.cur_par_bal, a.cur_gross_rate, a.cur_net_rate, a.cur_payment,
  a.interest_rate_cd, a.margin, a.last_reprice_date,
  a.maturity_date, a.next_payment_date, a.next_reprice_date,
  a.org_term, a.org_term_mult, a.pmt_freq, a.pmt_freq_mult,
  a.remain_no_pmts_c, a.reprice_freq, a.reprice_freq_mult,
  a.origination_date, a.int_type, a.last_payment_date,
  a.compound_basis_cd, a.issue_date, a.adjustable_type_cd,
  a.EMBEDDED_OPTIONS_FLG, a.org_payment_amt, a.org_par_bal,
  a.AMORT_METH_PDFC_CD, a.cur_tp_per_adb, a.deferred_cur_bal,
  a.deferred_org_bal, a.EFF_INTEREST_RATE_C, a.fees_eir,
  a.margin_gross, a.matched_spread_c, a.net_margin_cd,
  a.percent_sold, a.prior_tp_per_adb, a.rate_cap_life,
  a.rate_chg_min, a.rate_chg_rnd_cd, a.rate_chg_rnd_fac,
  a.rate_decr_cycle, a.rate_floor_life, a.rate_incr_cycle,
  a.rate_set_lag, a.rate_set_lag_mult, a.transfer_rate,
  a.tran_rate_rem_term, a.lrd_balance, a.liquidity_premium_rate,
  a.basis_risk_cost_rate, a.pricing_incentive_rate,
  a.other_adjustments_rate, a.margin_t_rate, a.neg_amrt_eq_date,
  a.neg_amrt_eq_freq, a.neg_amrt_eq_mult, a.neg_amrt_limit,
  a.neg_amrt_amt, a.pmt_adjust_date, a.pmt_chg_freq,
  a.pmt_chg_freq_mult, a.pmt_decr_cycle, a.pmt_decr_life,
  a.pmt_incr_cycle, a.pmt_incr_life, a.teaser_end_date,
  a.t_rate_int_rate_cd, a.RESIDUAL_AMOUNT, a.MATURITY_AMOUNT,
  a.EXPECTED_BAL, a.EXPECTED_BAL_GROWTH_PCT, a.OFFSET_PERCENT,
  a.MINIMUM_BALANCE, a.BEHAVIOUR_TYPE_CD, a.BEHAVIOUR_SUB_TYPE_CD,
  a.DEVOLVEMENT_STATUS_CD, a.ACCRUED_INTEREST, a.ACCRUED_GROSS_AMT,
  a.ACCRUED_TRANSFER_AMT
from FSI_D_CASA a
where a.as_of_date = :as_of_date
and a.COMMON_COA_ID = :COMMON_COA_ID
and a.ORG_UNIT_ID = :ORG_UNIT_ID
and AS_OF_DATE = TO_DATE('12/ 01/ 2016', 'MM/ DD/ YYYY')
and LEGAL_ENTITY_ID = 237

The following error is thrown when the ALM process is run from the command line and is found in hs_err_pidXXXX.log file:

#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x000000010008c620, pid=454, tid=1
#
# JRE version: Java(TM) SE Runtime Environment (7.0_80-b15) (build 1.7.0_80-b15)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.80-b11 mixed mode solaris-sparc compressed oops)
# Problematic frame:
# C [ofsrm+0x8c620] void BankAccount::FindPPData()+0x3c

The issue can be reproduced at will with the following steps:
1. Run ALM process
2. Check status

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