Incorrect Results Using OFSAA Filters With Terms in the Conditions
(Doc ID 1203343.1)
Last updated on MARCH 12, 2021
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.
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
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 = 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!