FSG: Since Database Upgrade FSGs Give Zero Results When Segment Override Is Changed
(Doc ID 1479568.1)
Last updated on FEBRUARY 19, 2019
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 220.127.116.11 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 18.104.22.168.
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