FSG: Since Database Upgrade FSGs Give Zero Results When Segment Override Is Changed
Last updated on MARCH 08, 2017
Applies to:Oracle General Ledger - Version 12.0.6 and later
Information in this document applies to any platform.
The issue was first noticed after the Database Upgrade to 18.104.22.168 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.
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
The database was upgraded to 22.214.171.124.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms