My Oracle Support Banner

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)

Symptoms

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:
12-OCT-97
04-OCT-96
01-OCT-96
...etc



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.