ALM Static Deterministic Process Fails With No Errors Except Command Line GetTreeFilterTreeRollup(double, short&, double&) Error (Doc ID 2147257.1)

Last updated on APRIL 19, 2021

Applies to:

Symptoms

On Oracle Financial Services Asset Liability Management (ALM) 8.0.2, Static Deterministic Process fails when running on FSI_D_CASA.  The following error is only thrown if run directly from command line:

ERROR

 | strBatchId : <INFODOM>_200964_EXEC_20160429_14 | strComponentId : ALM | Process ID : 200964 | User ID : <USER>|

ProcSysID = 200964
Running Oracle ALM, Process Rule: 200964 Engine started execution
#
# A fatal error has been detected by the Java Runtime Environment:
#
# SIGSEGV (0xb) at pc=0x00000000004196f7, pid=1720, tid=140523731498464
#
# JRE version: Java(TM) SE Runtime Environment (7.0_60-b19) (build 1.7.0_60-b19)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (24.60-b09 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C [ofsrm+0x196f7] GetTreeFilterTreeRollup(double, short&, double&)+0x196f7

This process previously worked on prior period 03/31/2016 data.

There are no errors reported in FSI_PROCESS_ERRORS and the ALM debug log does not contain any errors, but ends abruptly at:

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.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.PRODUCT_ID = :PRODUCT_ID
and AS_OF_DATE = TO_DATE('04/ 29/ 2016', 'MM/ DD/ YYYY') 

The process does not have a Forecast Balance Rule and Consolidate to reporting currency" option is not checked.

The issue can be reproduced at will with the following steps:
1. Run ALM Static Deterministic Process fails when running on FSI_D_CASA for the new period.
2. Find the process shows as Failed in the UI.

Cause

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