Date Ranges in Data Filter Include More Records than Specified
(Doc ID 2538350.1)
Last updated on OCTOBER 11, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.6 version, Filters
Date Ranges in Data Filters includes more records than specified. User observed that SQL_QUERY population in REV_DATA_FILTER for dates is incorrect therefore wrong data is being pulled into allocations that use filters with date ranges.
Steps To Replicate:
1. Create Data Filter with Ranges Filter Method for Loan Contracts Issue Date >= 10/01/1995 and <= 10/31/1995
2. Check View SQL and found below:
Ran the SQL and found ISSUE_DATES outside specified ranges ie:
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