My Oracle Support Banner

FSG Reports With Duplicating STAT Balances (Doc ID 1614434.1)

Last updated on OCTOBER 10, 2022

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
2. Reports-->Define-->Rowset
3. Report -->Run


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.