FSG: Since Database Upgrade FSGs Give Zero Results When Segment Override Is Changed (Doc ID 1479568.1)

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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms