FSG: Drilldown From Report Shows Account Assignment Range From Row/Column Set Assignments (Doc ID 1154432.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Report Manager - Version 11.5.0 and later
Oracle General Ledger - Version 11.5 and later
Information in this document applies to any platform.

Symptoms

Find when drilling down on an amount in an FSG report published from Report Manager, the Drilldown window shows the full range of accounts from the Row Set Definition, rather than just the account that the amount on the FSG line is for.
    Account from: 000000
    Account to: 999999

The Row is defined with a Display Type of Expand for the account range of 000000 to 999999 but the line being drilled on is for account 010012.

It is expected that the drilldown page would only show Account From/To as 010012 instead of the full range that was defined in the Row Set account assignment.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Publish an FSG via Report Manager using the Generic FSG Drill Template
2. View the output in Report Manager
3. Click on a cell to drill down on.
The FSG Drilldown - Drill Account Balances window is shown.
Account from /to range shows 01.0000000... to 01.999999....

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