My Oracle Support Banner

ALM Process Performance Slow When Running Non-maturity BP and Multi Repricing with Adjustable Type 250 (Doc ID 2358433.1)

Last updated on MARCH 25, 2019

Applies to:

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


On ALM 8.0.2, when attempting to run ALM static deterministic process with non-maturity Behavior Pattern (BP) and multi repricing notice longer to complete.

Expected Behavior
The process took 20 minutes, expect closer to 1 minute.

Steps to Replicate
1. ALM static deterministic process having as source instrument records (from FSI_D_LOAN_CONTRACTS) modeled with non-maturity Behavior Patterns (AMRT_TYPE_CD>70000) and multi repricing (Reprice Frequency being more granular than the Payment Frequency).
Most of the records are adjustable with Type Code 250, Repricing Frequency Daily, Payment Frequency 1M / 3M/ 12M. There are about 300 thousand records and the process is completed in 25 minutes.
2. When running similar process on FSI_D_CASA with Adjustable Type Fixed, it takes 1 minutes.


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

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