RGRARG FSG Column Set Calculation Results in Unexpected Values When Column Name is Used in Calculations Formula

(Doc ID 1920381.1)

Last updated on APRIL 08, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:RGRARG - Financial Statement Generator


On : 12.1.3 version, Financial Statement Generator

Column Set Calculation produces unexpected Values.

Computed values in FSG report from Column Set Calculation should be the correct ones as defined in the Calculation Formula



The Column Set has been defined using parameters similar to the following:
Navigation: Reports/Define/Column Set

a. Create 5 columns with the following data:

Sequence Column Name
20 Actuals
30 Calculation1
40 Actuals
50 Calculation2

b. Create Calculation formula for sequences 30 and 50 (Column names: Calculation1 and Calculation2):


Calculation for sequence 30 (column name: Calculation1)
Seq Operator Constant Low High Column Name
10 +       Actuals
20 +       TEST



Calculation for sequence 50 (column name: Calculation2)
Seq Operator Constant Low High Column Name
10 -       Actuals
20 +       TEST

When running the FSG report with this Column Set Setup, the Application mixes calculation amounts from the 2 Columns(Sequences 20 and 40) named "Actuals"


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