My Oracle Support Banner

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

Last updated on MARCH 12, 2021

Applies to:

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


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.

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 
5)  In the summary page, select your filter, then View SQL 
    It reflects correct columns, i.e.: 
          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 




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.