My Oracle Support Banner

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

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
Symptoms
Cause
Solution


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