ALM 8.1.2.2 Deterministic – Both Static/Dynamic Process Fails if TP Rule Selected Contains Any Product-Currency Combination With Weighted Average Perpetual Method (Doc ID 2969539.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

On  8.1.2.2 version ALM Deterministic - both Static/Dynamic process fails if Transfer price rule selected contains any Product-Currency combination with weighted average perpetual method

Execution log Log abruptly ends with:

............
select distinct REV_DATA_FILTER.table_name,
REV_DATA_FILTER.column_name, REV_DATA_FILTER.rev_data_type_cd
from REV_DATA_FILTER
where filter_sys_id in (select filter_sys_id
from fsi_cond_assumption
where cond_sys_id in (
select distinct c.cond_sys_id
from fsi_m_transfer_price_rule c
where c.transfer_price_sys_id = xxxxxx.000000)
or cond_sys_id in (select distinct b.cond_sys_id
from fsi_m_adjustment_rule b
where b.adjustment_sys_id = - 1.000000)
or cond_sys_id in (select distinct p.cond_sys_id
from fsi_m_transfer_price_rule p
where p.transfer_price_sys_id in (select distinct
q.tp_rule_sys_id
from fsi_m_adjustment_rule q
where q.adjustment_sys_id = - 1.000000))
or cond_sys_id in (select distinct d.cond_sys_id
from fsi_m_ppmt d
where d.ppmt_sys_id = - 1.000000))
and column_name not in (select h.leaf_field
from ofsa_catalog_of_leaves h
where h.table_type = 'I'or h.table_type = 'B')
and column_name not in ( 'ACCRUAL_BASIS_CD',
'ADJUSTABLE_TYPE_CD', 'ADJ_EFFECTIVE_DATE', 'ALL_IN_TP_RATE',
'AMORT_METH_PDFC_CD', 'AMRT_TERM', 'AMRT_TERM_MULT',
'AMRT_TYPE_CD', 'BASIS_RISK_CHARGE_CREDIT',
'BASIS_RISK_COST_AMT', 'BASIS_RISK_COST_RATE',
'BEHAVIOUR_SUB_TYPE_CD', 'BEHAVIOUR_TYPE_CD', 'BREAKAGE_TYPE_CD',
'BREAK_FUNDING_AMT', 'BREAK_FUNDING_AMT_CHG',
'BREAK_FUNDING_RATE', 'CHARGE_CREDIT_OCOST',
'CHARGE_CREDIT_OCOST_REM_TERM', 'CHARGE_CREDIT_TRATE',
'CHARGE_CREDIT_TRATE_REM_TERM', 'COMMIT_FEE_TO_CUST',
'COMMIT_MAT_DATE', 'COMMIT_OPTION_COST',
'COMMIT_OPTION_COST_PCT', 'COMMIT_OPTION_TYPE_CD',
'COMMIT_START_DATE', 'COMMIT_TERM', 'COMMIT_TERM_MULT',
'COMPOUND_BASIS_CD', 'CUR_BOOK_BAL', 'CUR_GROSS_RATE',
'CUR_NET_RATE', 'CUR_OAS', 'CUR_PAR_BAL', 'CUR_PAYMENT',
'CUR_STATIC_SPREAD', 'CUR_TP_PER_ADB', 'DEFERRED_CUR_BAL',
'DEFERRED_ORG_BAL', 'DEVOLVEMENT_STATUS_CD', 'EXPECTED_BAL',
'EXPECTED_BAL_GROWTH_PCT', 'HISTORIC_OAS',
'HISTORIC_STATIC_SPREAD', 'HOLIDAY_CALC_OPTION_CD',
'HOLIDAY_CALENDAR_CODE', 'HOLIDAY_ROLLING_CONVENTION_CD',
'IDENTITY_CODE', 'ID_NUMBER', 'INSTRUMENT_TYPE_CD',
'INTEREST_RATE_CD', 'INT_TYPE', 'ISO_CURRENCY_CD', 'ISSUE_DATE',
'LAST_PAYMENT_DATE', 'LAST_REPRICE_DATE', 'LEG_TYPE',
'LIQUIDITY_PREMIUM_AMT', 'LIQUIDITY_PREMIUM_RATE',
'LIQUIDITY_PREM_CHARGE_CREDIT', 'LRD_BALANCE', 'MARGIN',
'MARGIN_GROSS', 'MARGIN_T_RATE', 'MARKET_VALUE_C',
'MATCHED_SPREAD_C', 'MATURITY_AMOUNT', 'MATURITY_DATE',
'MINIMUM_BALANCE', 'NEG_AMRT_AMT', 'NEG_AMRT_EQ_DATE',
'NEG_AMRT_EQ_FREQ', 'NEG_AMRT_EQ_MULT', 'NET_MARGIN_CD',
'NEXT_PAYMENT_DATE', 'NEXT_REPRICE_DATE', 'OFFSET_PERCENT',
'OPTION_COST', 'ORG_BOOK_BAL', 'ORG_PAR_BAL', 'ORG_PAYMENT_AMT',
'ORG_TERM', 'ORG_TERM_MULT', 'ORIGINATION_DATE',
'OTHER_ADJUSTMENTS_AMT', 'OTHER_ADJUSTMENTS_RATE',
'OTHER_ADJ_CHARGE_CREDIT', 'PERCENT_SOLD', 'PMT_ADJUST_DATE',
'PMT_CHG_FREQ', 'PMT_CHG_FREQ_MULT', 'PMT_DECR_CYCLE',
'PMT_DECR_LIFE', 'PMT_FREQ', 'PMT_FREQ_MULT', 'PMT_INCR_CYCLE',
'PMT_INCR_LIFE', 'PRICING_INCENTIVE_AMT',
'PRICING_INCENTIVE_RATE', 'PRICING_INC_CHARGE_CREDIT',
'PRIOR_TP_PER_ADB', 'RATE_CAP_LIFE', 'RATE_CHG_MIN',
'RATE_CHG_RND_CD', 'RATE_CHG_RND_FAC', 'RATE_DECR_CYCLE',
'RATE_FLOOR_LIFE', 'RATE_INCR_CYCLE', 'RATE_SET_LAG',
'RATE_SET_LAG_MULT', 'REMAIN_NO_PMTS_C', 'REPRICE_FREQ',
'REPRICE_FREQ_MULT', 'RESIDUAL_AMOUNT', 'TEASER_END_DATE',
'TP_AVERAGE_LIFE', 'TP_DURATION', 'TP_EFFECTIVE_DATE',
'TRANSFER_RATE', 'TRAN_RATE_REM_TERM', 'T_RATE_INT_RATE_CD')
order by REV_DATA_FILTER.table_name,
REV_DATA_FILTER.rev_data_type_cd


Module Logging OFS Access module data: Size of CA vector is 0

And below error is captured in the nohup.out from $FIC_DB_HOME/bin folder

lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE V_AUTH_ALIAS = 'ofsa_atomic'

 | strBatchId : <INFODOM>_<PROCESS_ID>_EXEC_<>_8 | strComponentId : Asset Liability Management | Process ID : XXXXXXX| User ID : <ofsaa user> |

ProcSysID = XXXXXXX
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00007f384870f05c, pid=756984, tid=0x00007f384c647d80
#
# JRE version: Java(TM) SE Runtime Environment (8.0_321-b07) (build 1.8.0_321-b07)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.321-b07 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [libtp.so+0x3005c] TP_Context::LoadAssumptionsForAllInstruments()+0xffc
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /u01/OFSAA/ficdb/bin/hs_err_pid756984.log

Changes

Cause

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