FSG Functional FAQ
Posted by Mahmoud Elemam on January 2, 2011
Questions and Answers
For the General Ledger Patch List, on MetaLink, click on Knowledge…From The Knowledge Browser tab, quick find Note:159239.1.
You cannot suppress individual zero amounts in FSG. However, when all the values in a row or column are zero, you can have FSG suppress them all. To do this, make sure the Display Zero option is unchecked on the appropriate Rows or Columns window.
For a related row or column definition, check the Change Sign checkbox. Credit amounts for this row or column will now print as positive numbers. Negative credits will print as negative numbers. Note that this changes the sign for display purposes only.
Yes. You simply have to define a Row Order, then, assign it to your report. In your Row Order, set the Account Display options of the account segments for which you want to print descriptions. Select Value and Description as your segment display method. Also, make sure that you set the printing width, so there is enough room to print both the segment value and the description.
Yes. The column set width of an FSG report cannot exceed 255 characters. In release 11i, the column set width can exceed 255 characters. (However, while printing, there is still a limit of 255 characters.)
This profile option controls the expansion of parent values when requesting summary balances. The following values are available to you:
Yes: FSG uses the rollup group to determine whether to expand a parent value into its child ranges. If the parent value belongs to a rollup group, FSG does not expand the parent value into its child ranges. If the parent value does not belong to a rollup group, FSG expands the parent value into its child ranges.
No: FSG uses the summary flag associated with the flexfield assignment to determine whether to expand a parent value into its child ranges. If the summary flag is set to Yes, FSG does not expand the parent value into its child ranges. If the summary flag is set to No, FSG expands the parent value into its child ranges.
The default value for this profile option is No.
Note:1012620.102 provides more information regarding this profile option.
7. I am trying to display budget amounts in my reports but they are not showing up or are incorrect. What is wrong?
Since Oracle GL allows you to define multiple budgets, you must indicate what budget you want displayed in the row or column. You do this by first assigning a Control Value in the Balance Control section of the Row or Column window. The control value is any numeric value. Next, you must tell FSG what budget relates to the Control Value. You do this in the Define Report form. When you define a control value for either your Row
Set or Column Set in your report, the Control Value button will be activated. By selecting the Control Value button you can assign budgets to your control values.
Another reason you may not be seeing your amounts is if you are using the YTD-Budget (FY End) amount type, but have not budgeted to every period in the fiscal year. See Note:1036437.6.
Also, make sure you have defined your Amount Types, Offsets and Control Values in the Column Set or Row Set, but not both. Typically these are specified in the Column Set.
First, you define security rules for specific account segment values. Then, you assign your security rules to specific responsibilities. Lastly, you set the profile option ‘FSG: Enforce Segment Value Security’ to YES.
Flexfield value security has been enhanced in Release 11.5, with hierarchical security. Instead of having to create security rules for a range of segment values, you can assign security rules at the parent level and have the rules automatically apply to all of the child values within the parent hierarchy. To use this, choose the Security Type of Hierarchical for the value set, on the Value Sets form. See Note:138143.1 for more information.
Oracle comes with seeded amount types, which can be specified in the Balance control region of a FSG row or column definition. You cannot create your own.
The period offset and amount type must both be specified in the row set or both be specified in the column set. You cannot have a period offset in the row set and an amount type in the column set, or vice versa.
You should not define rows or columns that contain both calculation information and an amount type. If you do, the amount type will override and this may cause errors.
12. Is there a quick and supported method of transferring FSGs between environments, so that users do not have to key them in twice?
Run the FSG Transfer program (under Report/Request/Standard) to copy report objects from one General Ledger database (or instance) to another. You can copy row sets, column sets, reports, report sets, content sets, row orders, display sets, and display groups.
– You or your System Administrator must define database links.
– The chart of accounts in the set of books in your source database must be identical to the chart of accounts in the set of books in your target database.
– Any currencies and sets of books referred to by the row sets and column sets being copied must exist in the target database.
– Report details, such as budgets and encumbrance types, referred to by copied reports must exist in the target database.
– You must be logged into General Ledger and connected to the target database.
– The target and source apps releases must be the same. See Note <<1083689.6>> for more information.
If any of the prerequisites are nt met, you will not be able to use FSG Transfer to copy the report objects. You will have to enter them manually in the target set of books.
Unlimited Width Reports.
Oracle General Ledger now allows you to create FSG reports with an unlimited number of columns. FSG will pick the widest of the column set header or the total width of all the columns to determine the width of the report. However, while printing, there is still a limit of 255 characters.
Absolute Value Function in Reports
To ease reporting, you can now use the absolute value function in row set definitions to display amounts as positive numbers, regardless of their debit or credit balances. This function is helpful for defining income statements, balance sheets, and other financial reports in which amounts are generally displayed as positive numbers.
The text ‘No specific Company requested’ will appear as long as no content set is used for the report. A content set must be specified for this text not to appear. Depending on the content set parameters the actual segment value description or the text ‘No specific Company requested’ will appear. For example, when Display is set to ‘PE’ a separate report is generated for each value and the specific value’s description is displayed, rather than ‘No specific Company requested’.
This text will also change if you enter a Segment Override for Company (segment) at runtime on the Run Financial Reports form. By doing this, you are running the FSG for only the Company value you specified.
The accounting flexfield segment headings (CO, REG, etc.) can be removed with the use of a Row Order. See Note:1037253.6 for instructions on how to do this.
16. Can I customize or move the 3 heading lines that appear at the top of the FSG (set of books, report name, period)?
The first line of the FSG report heading contains the set of books name. This information can not be changed.
The second line of the FSG report heading contains the report name. For Release 10, this is the Row Set name that is used in the FSG. For Release 11 and 11i, this report name is defined in the Report definition (Navigation = Reports/Define/Report).
The third line contains the period that the FSG is being run for. This can not be changed.
The date and time in the upper right corner indicates when the report was created. The page number appears here also. This can not be changed.
ADI can be used to publish the FSG report, using a theme that you customize to make some of these changes. See the Application Desktop Integrator User’s Guide for more information.
On the Define Rowset form:
Make sure you have the following set up:
— Set the ‘Currency’ field to STAT for accounts that are STAT only.
— Set the ‘Control Value’ field to 1 for accounts that are STAT.
— Set the ‘Currency’ field to USD.
— Leave the ‘Control Value’ field blank for USD accounts.
On the Define Column Set form:
Under Balance Control Option – Do not input any Currency or Control values (i.e. leave fields blank). (If you enter a Currency on the Column also, FSG will report 0 in intersection of the row and column.)
Note that the currency entered at runtime (specified at the report level) is used only for rows and columns to which you did not assign a currency when you defined your row and column sets.
To report on Multiple Hierarchy levels (child, parent, grandparent, etc.) in FSGs you have to have as many sequences in the row set as the number of parents/grandparents/great-grandparents that you wish to report on.
You can not report on all levels by defining a single row sequence. See Note:1014255.102 for more information on how to do this.
When defining a row, you can enter a value in the ‘Percent of Row’ field. The value entered in this field is the sequence number of the row, that will be used as the denominator in the calculation of the percentage column.
See Note:1014921.6 for detailed instructions.
This functionality is available in 11.5.10 but not earlier versions. Please see note:220761.1 for more information.
The means ‘no meaning’. FSG displays this when there is a calculation that is attempting a divide by zero. You cannot remove this, or change it to any other value (other than changing the calculation itself so it doesn’t result in a divide by zero).
22. I used column set builder to set the width of the last column in my report. After saving and requerying the column set, the width has changed. Why?
The width of the last column can only be controlled through the format mask. Define the format mask of the last column to be as wide as the desired width of the column.
23. Can FSG reports and components be secured/protected so only certain people can modify or run them?
No. You can only restrict/protect the data that is reported on in the report. You cannot restrict access to the reports and components themselves.
24. How do segment overrides, content sets, account assignment ranges and display types work together?
For a detailed explanation, see Note:207779.1.
The underline character is part of the format option and is not affected by the display set definition, which only hides the actual data. The work around is to remove the underline from the row definition prior to running the report.
26. I’m using a Content Set with a range of cost centers. There are some inactive cost centers within that range. How can I suppress the creation or printing of the reports for those inactive cost centers, or for disabled or inactive accounts?
There is no way to exclude particular values that are included in the range you defined in the content set, or in an account assignment range in a row or column set. You must define new ranges that do not include those inactive cost centers or accounts.
27. How can I define a column to be for a specific or constant period, such as January of the current year, or dynamically change the period?
This functionality is not available.
FSG uses the period Offset, and the runtime period you enter, to determine which periods to report on. Use a negative number to report on periods prior to your runtime period, and a positive number to report on periods after your runtime period. For example, a column with an offset of 0 will contain amounts for the period you entered at runtime. A column with a -1 offset will contain amounts for the prior period, a -2 will contain amounts for a period 2 earlier than the runtime period. An offset of 1 will give you amounts for the period following the runtime period (providing that period has been opened before).
If account assignments have been defined in the column set, then that column set is only available to sets of books that use that same chart of accounts. If there are no account assignments in them, and the same chart of accounts (accounting flexfield structure) is used between sets of books, then they should be available to all of those sets of books.
The FSG reports are created from a program written in ‘C’ code, not from Oracle Reports, as is the case with standard reports. Many modules and tables are used to create reports based on the definition and component of a particular FSG. This would make looking at code for an FSG report (as you would a standard report) almost impossible. One approach is to turn the profile FSG: Message Detail to FULL and run the report. The logfile will contain some of the SQL. A session level trace will provide all of the SQL. See Note:141278.1 for information on how to get the trace.
In Release 11i, there is a patch available (2650861) that will allow you to use an amount type called YTD-Actual (FY End). Used without a period offset, FSG will give you the YTD balance for the fiscal year the report is run for. This amount type only pertains to the very last period of the current fiscal year and the status of that period must be Open or Closed. Current fiscal year means the year the period you are running the FSG for falls into.
If you use a period offset with the YTD-Actual (FY-End) amount type, and the resulting period falls into another fiscal year, it will get the year to date balance for that year. The offset is in whole year chunks so for example: -12 would be last year -24 the year before.
In release 11.0 and 10.7, you must still use the YTD-Actual amount type and the offset for the last period of the year.
Not from the standard application. In the applications you have a choice of 3 output options: 1) Text, 2) Tab-delimited – for importing into a spreadsheet, or 3) Spreadsheet – for downloading to ADI.
You can create an FSG in html format in ADI (Applications Desktop Integrator). In 11.5.10 FSG’s can now be published using xml formatting. Please see note:220761.1 for further information.
Add the program ‘Program – Run Financial Statement Generator’ to your Request Group. See Note:1060806.6 for detailed instructions.
The values defined in a content set override the values defined in the row set account assignments. Depending on how your account assignments are structured, this may result in duplication of the account assignment ranges. See Note:147218.1 for an explanation and workaround.
A Row Name has been specified but this is not printed on the report. This becomes the row identifier in the row calculations window. To display a parent account description, enter your description in the LINE ITEM field. This will be the description that is printed on the report output.
No, currently this functionality does not exist. Enhancement request bug:812503 has been raised requesting this functionality. The workaround is to copy and modify the FSG report for each Set of books.
See Note:549289.1 How To Determine Which FSG Patches Have Been Applied
>There are two ways you can increase the display size of the account description.
– increase the size of the display width in the row order.
– increase the POSITION of the description column in the column set.
You will need to change the POSITION on all the other columns to allow for the increase. See also the size limitations in question 5 and question 20 above.
38. (R12) The Ledger List of Values on the Run Financial Reports form shows all possible ledgers. How can this be limited to only ledgers the responsibility should access?
The Data Access Set assigned to the Responsibility (via the profile GL: Data Access Set) controls which ledgers you can actually update or view data for.
Even if there is a ledger name in a LOV, you should not be able to see the data for that ledger in the FSG if the Data Access Set does not have that access.
Assign a control value to each of the Budget, Variance and Variance % columns. In the FSG Report Definition, assign the control value to the appropriate budget and currency.