Financial Statement Generator - Oracle EBS R12: July 2015

http://financialstatementgenerator.blogspot.com

Financial Statement Generator (FSG) Definition

Row Order

Row Order modify the order of detail rows in a report

• We use Row Order to control how expanded detail rows are displayed in our report.

• Sort detail rows by account segment values, account segment description or by amount displayed in a column.

• Rearrange the sequence of our chart of account segments to fit specific reporting needs.

Display Set

With Display Sets and Groups, we can produce report variations that omit sensitive information

Content Set

Content Set overrides segment values and produce multiple versions of a same report.

Content set works by overriding the row set definition of an existing report and replacing the row set account assignments and/or display options.

By assigning a content set to a report request, we can generate hundreds of similar reports in a single run.

Row Set and Column Set Override Summary

Row overrides Column

Amount Type, Period Offset, Control Value, Format Mask, Factor,

Display Zero, Level of Detail

Column overrides Row

Override Row/Column Calculations (Conflict exists only if the same value (yes/no) is entered at both the row and column set levels), Activity

Other Conflicts

Accounts (Report uses intersecting accounts).

Summary (Must assign same summary option at the row and column). Currency (Must assign same currency at the row and column).

Change Sign (Yes overrides No)

Change Sign on Variance (Yes overrides No)

Financial Statement Generator - Oracle EBS R12