FSG Reports With Duplicating STAT Balances
Last updated on SEPTEMBER 27, 2017
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Financial Statement Generator
Stat Totals for all months are not displayed on the FSG Report
1) The Stat Account has the actual headcounts entered in Journals for the periods . All Journals are posted.
2) The FSG Column Set is a rolling 12 months plus ADJ with YTD Amount Types set in each Columnset Column.
3) The Rowset has no Amount Types, except the STAT Account Rows, which have PTD in order to override and display the monthly balances.
Tried putting both STAT in the Currency field of the Rowset and using a control number to set the STAT Account, neither work as required
The output shows the monetary amounts correctly with their YTD Balances in USD (controlled by the ledger i.e not setting currency at run time).
The STAT rows display the latest period balances loaded in ALL MONTHS, the prior period balances never appear and months that have no STAT balances show the latest period balances.
Stat Totals are not displayed
The issue can be reproduced at will with the following steps:
1. GL Superuser
3. Report -->Run
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