ALMBI Product Characteristics Analysis Report Only Displays Products Which Are Configured at Child Level (Leaf Level), Node(Parent) Level is Not Displayed (Doc ID 2276319.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 8.0.2 and later
Information in this document applies to any platform.
ALMBI - Asset Liability Management Business intelligence
ALM - Asset Liability Management

Symptoms

ALMBI Assumptions Tab -- ALM Product Characteristics report.

In current instance, 90% of ALM product characteristics are configured at Product Node (Parent) Level.
In the table FSI_M_PROD_CHARACTERISTICS, product_id column has node values & leaf values [only configured leaf values].

In ALMBI 8.0.2, ALM Product Characteristics Analysis Report only displays products which are configured at Child Level (Leaf Level). Configuration which is done at Node(Parent) level is not displayed.

The following query can help in better analysis:

 from DIM_PRODUCT T11170 /* Dim Product */,
  DIM_CURRENCY T11146 /* Dim Currency */,
  FSI_M_PROD_CHARACTERISTICS T20430 /* Fact Product Characteristics */,
  FSI_M_OBJECT_DEFINITION_TL T18138 /* Dim Object Definition (Leaf Characteristics) */,
  FSI_M_OBJECT_DEFINITION_B T20088 /* Dim Object Definition Base(Folder) */
 where (T11146.V_ISO_CURRENCY_CD = T20430.CCY_CD and
  T11170.N_PRODUCT_ID = T20430.PRODUCT_ID and
  T18138.OBJECT_DEFINITION_ID = T20088.OBJECT_DEFINITION_ID and
  T18138.OBJECT_DEFINITION_ID = T20430.PROD_CHAR_SYS_ID and
  T20088.FOLDER_NAME = 'OFSALMSEG'

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms