My Oracle Support Banner

FSG: How To Interpret FSG Reports Completed with Warnings in FSG Log File (Doc ID 397668.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle General Ledger - Version 11.5.10.0 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Executable:RGRARG - Financial Statement Generator

Goal

All warnings issued in the log file are about potential problems that can corrupt processing of the report. How do I find out more about these errors?

The FSG (RGRARG) log file can show  several warnings:

1) Warning :Total width from all rows in the Row Order <number> exceeds the Column Set Margin <number>

2) Warning : there is more than one row assignments for row sequence:  <row sequence #>

3) Warning : calculations use further columns for column/row sequence :  <column/row sequence #>

4) Warning : row order should not be used as definitions do not use Display options E/B.

Many of these issues are caused by setup of a particular FSG layout.

These issues are described in Unpublished Bug 4449474 FSG: RGRARG SIGNAL 11 AFTER COLUMN HEADER ADDED TO REPORT, as well as Unpublished Bug 4016808 RGRARG: REPORTS ERRORS WITH SIGNAL 10/11.

These warnings are used in 11.5.10 onwards to indicate the kind of misuse of the FSG technology that commonly cause performance issues. Due to the complexity of FSG these cannot be enforced on the form without causing problems. They also can be used to identify the source of signal11 or signal10 errors.

The issues indicated  do not always cause an immediate problem as it depends on whether the data itself can be handled correctly by the report generator but as data changes over time they will cause a problem eventually.

Solution

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
Goal
Solution
 1) Warning :Total width from all rows in the Row Order <number> exceeds the Column Set Margin <number>
 2) Warning : there is more than one row assignments for row sequence:  <row sequence #>
 3) Warning : calculations use further columns for column/row sequence :  <column/row sequence #>
 4) Warning : row order should not be used as definitions do not use Display options E/B
Run the FSG without the Row Order. As the message indicates, the Row Order should only be used when you use the 'E' or 'B' Display Types.
 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.