1. Asset Liability Management User Guide
  2. Formula Results

34 Formula Results

This module describes the procedure for working with and managing Formula Results rules.

The Formula Results rule enables you to model a product/currency leaf using the results of the cash flow, Liquidity Gap, Repricing Gap, and Market Value processes to recalculate and change the system-generated data. This allows you to model a product/currency leaf beyond results produced by the cash flow engine, using the formulas to create financial element values. The new FEs will be displayed to you, based on the Financial Type selection.

The types of Formula Results are following:

  • Cash Flow
  • Repricing Gap
  • Liquidity Gap
  • Market Value

Note:

The Formula Result assumptions are applicable only for Deterministic Process. Only leaf level assumptions will be supported. Default currency and Preview options are not available in UI.

Here, engine picks up the assumptions and writes the results into the Result Detail and Result Master tables (including all the forecast rates scenarios). Process Cash Flows table is not populated. Consolidated Detail and Consolidated Master tables are populated with Formula Results for Result Type Code=2 (indicating Formula Results Data) if the Consolidation flag is selected.

The Formula Results rule works only for the first dynamic start date for IRR Gap and liquidity buckets, and for As of Date (Start Date Index=0) and all the dynamic start dates for Market Value.

Note:

Auto balancing has result type code 3, so the Auto balancing will be applicable post Formula Results are applied.

The procedure for working with and managing Formula Results rules is similar to that of other Oracle Asset Liability Management business rules. It includes the following steps:

  • Searching for Formula Results rules. For more information, see Searching for Rules section.
  • Creating Formula Results Rules. For more information, see Creating Rules section.
  • Viewing and Editing Formula Results rules. For more information, see View and Edit the Rule section.
  • Copying Formula Results rules. For more information, see Copy the Rule section.
  • Deleting Formula Results rules. For more information, see Delete the Rule section.

As part of creating and editing Formula Results rules, you can assign Formula Results to applicable products.

Figure 34-1 Process Flow of Formula Results


Process Flow of Formula Results