My Oracle Support Banner

FSG: Report Row Set 'Percent Of Row' Calculates Wrong Precedence (Doc ID 1068122.1)

Last updated on SEPTEMBER 18, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Program: RGRARG - Financial Statement Generator (FSG)


Symptoms

When defining a FSG Row Set and the 'Percent of Row' field is defined for a row with calculations, the calculation takes the precedence which is not expected.

For Example,
Create a Row Set with 4 rows.
10 Accounts receivable
20 Furniture
30 Vehicles
40 Total
Here row 40 has a calculation which is the addition of all three rows above. And for the rows 10, 20 and 40, gave percent of row as 40; row 30 has the percent of row as 10.
Create a Column Set with the following columns
30 PTD-Actual
60 Percent of row
Column 60 has a calculation which does a percentage of column 30.
The output is as below.
Accounts    10,000.00               40.00 
Furniture    7,500.00               30.00 
Vehicles     7,500.00               75.00 
Total exp   25,000.00              145.00 
The Percent of Row column is the addition of all the above rows. 

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
 Still Have Questions?
References


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