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

Symptoms

On : 12.1.3 version, Financial Statement Generator

ACTUAL BEHAVIOR
---------------
Column Set Calculation produces unexpected Values.

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

 

STEPS:

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
10 TEST
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)
      Sequence  
Seq Operator Constant Low High Column Name
10 +       Actuals
20 +       TEST

 

 

Calculation for sequence 50 (column name: Calculation2)
      Sequence  
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"

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