My Oracle Support Banner

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.

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

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.