Oracle Logo

Oracle Financial Services Asset Liability Management (OFS ALM) Application Pack v8.1.2.0.0 Maintenance Level Release (8.1.2.11.0)

 

OFS Financial Services Asset Liability Management (OFS ALM) Application Pack is a separately licensed product.

Description

Bug 39056281 - Oracle Financial Services Asset Liability Management (OFS ALM) v8.1.2.11.0 Maintenance Release.

Pre-installation Requirements

The minimum patch set level must be OFS ALM Application Pack v8.1.2.0.0.

Installing this Release

For detailed instructions on installing this Maintenance Level Release, see OFS ALM Installation Guide 8.1.2.11.0. AAI 8.1.2.6.0 automatically installed with ALM 8.1.2.11.0.

Bugs Fixed in this Release

The following bugs are fixed in this Release.

Sl.No

Component

Bug Number

Description

1

CALCENG

38461877

FORWARD PORT OF BUG 38414559 - INTEREST ACCRUED FE 440 HIGHER IN FIRST BUCKET WITH PREPAYMENT VS NO PREPAYMENT

 

Functional Changes:

When early redemption with user-defined tenor is used, during first accrual event, last payment date was getting derived using payment frequency and next payment date instead of directly using last payment date from data. A code fix has been implemented to address this issue. This affected Financial Element 440.

2

CALCENG

37786521

FORWARD PORT OF BUG 37720533 - ALM 8.1.2.2: TOTAL AMOUNTS FOR FE711 IN RES_DTL AND FSI_O_PROCESS_CASH_FLOWS TABLE ARE NOT MATCHING

 

Functional Changes:

#### Issue ####:

For FE711, a NaN value is generated for some cash flows, causing a mismatch in the aggregated bucket value compared to the FE711 cash flow value.

##### Root Cause ####:

The NaN value for FE711 occurs because, during cash flow calculation, the formula used to determine FE711 relies on the Floor_Strike value, which is derived as follows: Floor_Strike = Coupon_Rate - RATE_DECR_CYCLE The Coupon_Rate depends on cur_gross_rate, which, in turn, fetches its value from cur_net_rate. Currently, cur_net_rate is set to `0` in the instrument table for a few instrument IDs. Since Coupon_Rate is 0, the Floor_Strike value becomes negative. As a result, when calculating FE711, the formula encounters: log(ForecastBenchMarkRate} /Strike) This leads to an INVALID_VALUE or NaN output when: - Strike = 0, making the division undefined. - ForecastBenchMarkRate / Strike results in a negative value, causing an invalid logarithmic operation.

##### Fix #####:

The following code fixes have been implemented: 1. In the expression log(ForecastBenchMarkRate / Strike), if Strike = 0, it will be replaced with 1 to avoid division by zero. 2. In the expression log(ForecastBenchMarkRate / Strike), if ForecastBenchMarkRate / Strike evaluates to a negative value, the logarithmic result will be replaced with 0.001 to prevent invalid operations.

3

CALCENG

38292485

FORWARD PORT OF BUG 38166139 - INTEREST ACCRUAL FE 440 WRONG FOR CASE WITH HOLIDAY CALENDAR AND SHIFT DATES.

 

Functional Changes:

Interest accrual FE 440 results were not coming expected for case with Holiday Calendar and shift dates, Code fixes have been added to address it.

4

CALCENG

37212256

FORWARD PORT OF BUG 37097537 - EARLY REDEMPTION INTEREST CASH FLOW AND MV WITH VARIABLE RATE TERM DEPOSITS

 

Functional Changes:

Following the early redemption event, the incorrect interest cash flow was calculated. Necessary code corrections have been made to address this issue.

5

CALCENG

38284465

FORWARD PORT OF BUG 37289704- FORMULA RESULTS FOR CUSTOM FINANCIAL ELEMENT NOT OUTPUT TO TABLE IN 8.1.2.

 

Functional Changes:

NA

6

CALCENG

38284479

FORWARD PORT OF BUG 37784873- ALM 8.0.7.4 CASHFLOW DESCREPANCY - INTEREST (FE430) NOT GENERATED FOR SOME SCHEDULE DATE

 

Functional Changes:

Code fixes have been added to address Compound Rate formula for schedule and non-schedule amortization types that are made different to handle stub period. In case of non-schedule Rate Per Payment is calculated for payment frequency and it must be adjusted for any difference in actual interest calculation period.

7

CALCENG

37827011

FORWARD PORT OF BUG 37571263 - FE 660 FAILS TO GENERATE CASHFLOWS FOR THE FIXED TIER IF THE 1ST TIER IS FIXED AND 2ND IS FLOATING

 

Functional Changes:

Code fixes have been added to address the issue where FE 660 was not generating correct cashflows for the fixed tier if the 1st tier is fixed and 2nd is floating  

8

CALCENG

39057009

FORWARD PORT OF BUG 38740257 - NO NEW BUSINESS GOT GENERATED FOR STOCHASTIC PROCESS

 

Functional Changes:

The code utilizes individual runoff FEs (190, 180, 195, etc.) to generate new business. However, Financial Elements related to behaviour patterns (200�209) were not passed to the Stochastic process. Only the total runoff FEs (210, 211) were available, which resulted in new business not being generated. This has now been addressed by including FEs 200�209 in the Stochastic processing. For the Deterministic process, this functionality was already in place.

9

CALCENG

38785226

ALM PROCESS SHOULD END IN FAILED STATUS WHEN SIGNAL 6 AND CORE DUMP OCCURS

 

Functional Changes:

The technical exit conditions of the processes are corrected to resolve the issue.

10

CALCENG

39275417

FORWARD PORT OF BUG 38334874 - PREVIOUS BUSINESS DAY HOLIDAY ROLLING CONVENTION IS NOT WORKING FOR PAYMENT PATTERN

 

Functional Changes:

When using the Previous Business Day holiday rolling convention, the current date could be adjusted backward (e.g., from a holiday like 26-Jan to 24-Jan). The existing logic in Synchronize compared current date with the input date to determine whether to advance to the next event. This caused incorrect advancement of current event, leading to skipping of valid scheduled events (e.g., 26-Feb) when synchronizing on the rolled date. Code fix is done to handle the issue.

11

CALCENG

39275406

FORWARD PORT OF BUG 38423093 - ALM 8.1.2.2: FE 430 DIFFERENCE COMING AFTER ALM 8.1.2.2.18 CONSOLIDATED PATCH

 

Functional Changes:

The accrual factor for the last cash flow date, which occurred on the maturity date, was calculated incorrectly due to a leap year vs. non-leap year issue. A code fix has been implemented to address this.

12

CALCENG

39275387

FORWARD PORT OF BUG 38616588 - 8.1.2 PREPAYMENT ISSUE AFTER APPLYING THE PATCH # 37344377

 

Functional Changes:

Issue was observed in instrument with tiered interest rate. While switching to the highest rank, the prepayment overflow was not adjusted for the current highest-rank tier account. A code fix has been implemented to address this issue.

13

UI

38272577

FORWARD PORT OF BUG 38233514 - ALM 8.1.2: TRANSACTION STRATEGIES - RUN OUT OF MEMORY FOR LARGE TRANSACTION BATCHES

 

Functional Changes:

Issue is fixed by removing the additional knockout binding for the TS object which was not required on loading the screen.

14

UI

39086107

FORWARD PORT OF BUG 38219496 - PREPAYMENT DETAILS FAIL TO LOAD WITH MULTIPLE FOLDERS AND USER DEFINED TENORS OPTION

 

Functional Changes:

issue was fixed by correcting the IDs of the UI to resolve UI error

15

UI

38325531

FORWARD PORT OF BUG 38263844 - ALL NEW BUSINESS METHODS LISTED WHEN EDITING EXISTING NODE DEFINITION IN FORECAST BALANCE

 

Functional Changes:

Issue is fixed by adding the method in edit mode to get the correct list of methods on user interface.

16

UI

37553723

FORWARD PORT OF BUG 37538353 - ALM 8.1.2.2: CHANGES TO BEHAVIOR PATTERN ARE NOT PERSISTED UPON SAVING

 

Functional Changes:

Update statement was not working as expected due to mismatch in one of the variables. The value was not getting passed correctly when not in use. Same is corrected to fix the issue

17

UI

38847212

ALM 8125 VOLATILE PERCENTAGE NOT APPLIED IN BEHAVIOUR PATTERN WHEN CORE USES SAME TENORS

 

Functional Changes:

In Behaviour Pattern user can define same tenor more than once. There must be validation in BP UI for it. Tenor and Multiplier combination must be unique for non-maturity BP. For Devolvement Recovery and Non-Performing BP, it will be unique for a behaviour sub-type.

This issue is fixed by adding required validations.

18

UI

38862640

STANDARDIZED IRRBB SHOCKS - UI ISSUES

 

Functional Changes:

labels are corrected

19

Data Model

39217876

ASSET LIABILITY MANAGEMENT 8.1.2.11.0 - ERWIN DATA MODEL

 

Functional Changes:

NA

20

Data Model

39217903

ASSET LIABILITY MANAGEMENT ANALYTICS 8.1.2.11.0 - ERWIN DATA MODEL

 

Functional Changes:

NA

21

CALCENG

39527024

FORWARD PORT OF BUG 39226661 - ALM MONTHLY 28TH PAYMENT PATTERN SHIFTS TO EOM

 

Functional Changes:

Rate-tier cash flow generation has been updated to use payment pattern event dates for user-defined payment pattern amortization types instead of advancing the next payment date using payment frequency. This preserves the schedule defined in FSI_PAYMENT_PATTERN_EVENT and prevents monthly 28th payment pattern dates from shifting to month end.

22

SCRIPTS

39565606

FORWARD PORT OF ENH 39292201 - POPULATE DV01 IN ALM REPORTING TABLES VIA STANDARD BI TRANSFORMATION PACKAGE

 

Functional Changes:

The reporting tables FCT_AGG_BASE_CCY_ALM_MEASURES and FCT_AGG_CONS_CCY_ALM_MEASURES have been enhanced to include values for the following attributes: N_DV01, N_CUR_BAS_RISK_COST_RATE, N_CUR_LIQ_PREM_RATE, N_CUR_OTH_ADJ_RATE, N_CUR_PRIC_INCENT_RATE Although these attributes were already being computed as part of the processing workflow, their values were not previously propagated to the above reporting tables. This enhancement ensures that the computed values are now carried forward and made available in the reporting tables.

23

CALCENG

39714279

FORWARD PORT - CONDITIONAL ASSUMPTIONS FOR TP CALCULATION ARE NOT TAKEN INTO ACCOUNT

 

Functional Changes:

Added a conditional assumption evaluation method to the code to support conditional assumptions.

24

CALCENG

39762772

FORWARD PORT TO 8.1.2.11.0 -FOR BUG 39145414 - MISSING INTEREST CASH FLOW WHEN PREPAYMENT DATE COINCIDES WITH SCHEDULED INTEREST DATE

 

Functional Changes:

The issue has been addressed with this patch.The Interest cash flow (FE 430) is calculated and generated up to the prepayment date, even when the interest payment date and prepayment date coincide.

25

CALCENG

39764179

FORWARD PORT - BUG 39131395 - MCS: EARLY REDEMPTION MISCALCULATION WHEN USING MULTI FACTOR PREPAYMENT MODEL

 

Functional Changes:

Early redemption/prepayment events did not refresh PPArgs.RemainingTerm before prepayment table interpolation because they bypass payment_line preprocessing. RemainingTerm was left as 0, causing incorrect rates when the multi-factor prepayment model used Remaining Term as a table dimension. This has now been addressed by refreshing the relevant PPArgs term fields for early redemption and user-defined prepayment events before rate lookup.

26

UI

39594824

ALM 8.1.2.5: INTEREST ONLY OPTION IN DISCOUNT METHOD RULE IS NOT SAVED AND STILL SHOWS PRINCIPAL AND INTEREST

 

Functional Changes:

The UI fixes has been addressed, when trying to select Interest Only option in Discount Method rule and save, actual selection isn't saved. It is still shown as Principal and Interest.

27

CALCENG

39848928

FORWARD PORT - BUG 39847592 - WRONG RESULT GENERATED UNDER TRANSFER RATE CHARGE/CREDIT (FE 450)

 

Functional Changes:

Code fix is done to handle Reprice, Early Redemption, and Prepayment event cash flows while aggregating cashflow for FE450.

28

CALCENG

39890987

FORWARD PORT TO 8.1.2.11.0 OF BUG 39598535 - FE 440 (INTEREST ACCRUED) INCORRECT WHEN USER-DEFINED PREPAYMENT TENORS CREATE MULTIPLE SUB-PERIODS

 

Functional Changes:

Fixed incorrect FE 440 daily accrued-interest values when user-defined prepayment tenors create multiple sub-periods.

Known Issues or Limitations in this Release

There are no Known Issues and Limitations in this release.

Oracle Financial Services Analytical Applications Infrastructure

See the Oracle Financial Services Advanced Analytical Applications Infrastructure Application Pack Readme, for details on the new features, list of bugs fixed, Known Issues, and Limitations.


Oracle Financial Services Software   |   Copyright � 2021, Oracle and/or its affiliates. All rights reserved.   |   Phone: +1.650.506.7000   |   Fax: +1.650.506.7200   |   www.oracle.com/industries/financial-services/index.html