Incorrect Results Using OFSAA Filters With Terms in the Conditions (Doc ID 1203343.1)

Last updated on FEBRUARY 28, 2011

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.1 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.1

Symptoms

In OFSAA 5.1, when attempting to use a Filter with a Term field as one of the conditions, the process does not appear to use the correct filter condition and incorrect results are returned.

The View SQL for the Filter appears to be correct however, the FS Debug generated SQL shows AMRT_TERM_MULT instead of the correct term.

STEPS
The issue can be reproduced at will with the following steps:
1)  Master Maintenance > Filters > Add 
2)  Filter Definition: 
    - Filter Name = AnyValidName 
    - Data Element Selection:  Search 
3)  Data Element Selection: 
    - Entity Name = any instrument, e.g. Mortgages 
    - select any term or freqquency field, e.g. Repricing Frequency 
      click OK 
4)  Filter Definition: 
    Specific Values:  Value = 12, Multiplier = Months; Add 
    Save 
5)  In the summary page, select your filter, then View SQL 
    It reflects correct columns, i.e.: 
      ((((FSI_D_MORTGAGES.REPRICE_FREQ = 12 AND 
          FSI_D_MORTGAGES.REPRICE_FREQ_mult = 'M')))) 
6)  Query the database to see how it stores the data: 
    Select * from rev_data_filter 
    where filter_sys_id = 
      (select object_definition_id from fsi_m_object_definition_tl 
       where short_desc = 'AnyValidName'); 

BUG:  rev_data_filter.related_field = 'AMRT_TERM_MULT' instead of 
          'REPRICE_FREQ_MULT' 

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