FSG: Since Database Upgrade FSGs Give Zero Results When Segment Override Is Changed

Last updated on MARCH 08, 2017

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
The issue was first noticed  after the Database Upgrade to 11.2.0.2 from 10.2.0.3.
An FSG Report definition contains a Segment Override value. If that value is changed at runtime, the report returns all zeros, although there should be data returned.

The workaround is to set the profile  "FSG: Remove CBO Hint" profile set to YY.
When the profile "FSG: Remove CBO Hint" profile is set to YY, the query will not have nvl for segment <> conditions.
With that, the query returns the data as the function based index was not being picked.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Reports > Request > standard
2. Program - Publish FSG Report
3. Try to change the Segment Override value
4. View the report output
 

Changes

 The database was upgraded to 11.2.0.2.

Cause