My Oracle Support Banner

Incorrect ALM Results on Borrowings After Upgrade to 8.0.6 or 8.0.7+ (Doc ID 2780164.1)

Last updated on JUNE 02, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)

Symptoms

On ALM 8.0.7.4.0 after upgrade from 8.0.4, the ALM process does not produce any results in the RES_DTL or FSI_O_CASH_FLOWS tables.

The extraction logic for Borrowings / FSI_D_ BORROWINGS does not yield any results after upgrade from 804 to 8074. Below is the extraction logic used.

select ACCOUNT_NUMBER, PRODUCT_NAME, SUM(Base) Base
, SUM(BaseMinus25) BaseMinus25, sum(BaseMinus50) BaseMinus50, sum(BaseMinus100) BaseMinus100
, SUM(BasePlus25) BasePlus25, sum(BasePlus50) BasePlus50, sum(BasePlus100) BasePlus100
from (select a.account_number, p.product_name, cf.result_sys_id
, CASE WHEN cf.result_sys_id = 200608 THEN cf.float_value ELSE 0 END as Base
, CASE WHEN cf.result_sys_id = 200611 THEN cf.float_value ELSE 0 END as BaseMinus25
, CASE WHEN cf.result_sys_id = 200623 THEN cf.float_value ELSE 0 END as BaseMinus50
, CASE WHEN cf.result_sys_id = 200612 THEN cf.float_value ELSE 0 END as BaseMinus100
, CASE WHEN cf.result_sys_id = 200624 THEN cf.float_value ELSE 0 END as BasePlus25
, CASE WHEN cf.result_sys_id = 200625 THEN cf.float_value ELSE 0 END as BasePlus50
, CASE WHEN cf.result_sys_id = 200626 THEN cf.float_value ELSE 0 END as BasePlus100
from fsi_o_process_cash_flows cf, FSI_D_BORROWINGS a, dim_products_tl p
where cf.financial_elem_id=710 and cf.float_value!=0 and cf.scenario_num=1 and a.as_of_date='&AS_OF_DATE'
and cf.id_number=a.id_number and cf.product_leaf_node=p.product_id
and cf.result_sys_id in (200608,200611,200612,200623,200624,200625,200626)
)
group by account_number, product_name
order by 2,1
;


The following error appears in the FSI_PROCESS_ERRORS table for all records:

ERROR

Invalid record:Maturity date in the past Leaf member:

Upon checking the above, it appears that FSI_D_BORROWINGS.MATURITY_DATE is null for all records.

Changes

Upgrade from ALM 8.0.4 to ALM 8.0.7.4.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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