Oracle e-Business Financial

Mahmoud Elemam – blog

FSG Functional FAQ

Posted by Mahmoud Elemam on January 2, 2011

Questions and Answers

1. How do I find the latest FSG patch that is available?

For the General Ledger Patch List, on MetaLink, click on Knowledge…From The Knowledge Browser tab, quick find Note:159239.1.

2. Is there a way to suppress zero amounts on the FSG Report?

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.

3. How do you print credit amounts on the FSG Report as positive instead of negative numbers?

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.

4. Can I display account descriptions on the FSG Report in addition to the account segment values?

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.

5. Is there a limit on how large a FSG Report can be?

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.)

6. What is the profile option ‘FSG: Expand parent value’ used for?

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.

8. How do you enable Flexfield Security Rules for FSG?

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.

9. How can you add/define/create your own new amount types in FSG reporting?

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.

10. Where should the period offset and the amount type be specified?

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.

11. On a calculation column, can I enter an amount type?

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.

13. What FSG enhancements are introduced in Release 11i ?

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.

14. Can I remove the ‘No specific Company requested’ text from the FSG heading?

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.

15. Can I remove the segment header descriptions from the top of the FSG reports?

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.

17. How can I display USD and STAT amounts on the same FSG report?

On the Define Rowset form:
Make sure you have the following set up:
STAT Accounts
— Set the ‘Currency’ field to STAT for accounts that are STAT only.
— Set the ‘Control Value’ field to 1 for accounts that are STAT.

USD Accounts
— 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.

18. How can I report on a multiple level account hierarchy in an FSG?

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.

19. How can I define an FSG percentage calculation Column such as percent of sales?

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.

20. Can an FSG output be created in PDF format?

This functionality is available in 11.5.10 but not earlier versions. Please see note:220761.1 for more information.

21. What is the meaning of ‘n/m’ on my FSG?

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.

25. When hiding data using a Display Group/Set in FSG the underline under that data still appears.

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).

28. Why can some column sets be viewed/used with different sets of books and others cannot?

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.

29. How do I see the SQL code behind the FSG report?

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.

30. How do I show the YTD amount for the end of the fiscal year on an FSG?

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.

31. Can I create an FSG in html format?

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.

32. How can I run an FSG from the Standard Request Submission form?

Add the program ‘Program – Run Financial Statement Generator’ to your Request Group. See Note:1060806.6 for detailed instructions.

33. When using a content set, sometimes the amounts are duplicated (doubled or tripled).

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.

34. How Can You Print A Parent Account Description In The Row Set ?

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.

35. Can I make the same FSG report work for both my sets of books ?

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.

36. How do I find which FSG patches I have applied. ?

See Note:549289.1 How To Determine Which FSG Patches Have Been Applied

37. How can I increase the size of the description displayed on the report ?

>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.

39.  (R12) How can you report on a budget entered in a foreign currency?

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.



11 Responses to “FSG Functional FAQ”

  1. Yasir said

    (R12) how can i display opening qtd balances in fsg

  2. Veera said

    I am getting a blank page after the report. I didn’t give any page breaks/.
    I noticed that there is a special character at the end of the report.


  3. sql wildcard,sql wildcards,sql rollback,rollback sql,sql copy table,sql sum,sql mirroring,sum sql,sql cluster,sql server performance,truncate in sql,backup sql,backup sql database,backup sql server,sql performance,date functions in sql,sql over,trunc…

    […]FSG Functional FAQ « Oracle Application Financial[…]…

  4. Jesus Rivera said

    I am a little confused. I keep hearing that FSG report are not going to be supported when if we upgrade to R12 in the near future.

    Is that the case.

    I was under the impression taht ADI was not going to be supported and BI Publisher will be the tool to excute FSG reports in the future.

    Which one is correct and are FSG executable reports in Oracle R12.

  5. Wrong number texts…

    […]FSG Functional FAQ « Oracle Application Financial[…]…

  6. Jung Lee said

    How can I separate an account value and its description at the row level? When I create a row order, I am able to select display type value, description, or value and description. One idea I had was to select this account, and display value, and then select it again, and display description, effectively putting the two fields in different columns, but once I select this account segment, I cannot re-select it. Please help Thanks.

  7. This is very interesting, You are a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more of your wonderful
    post. Also, I have shared your web site in my social networks!

  8. I’m not positive where you’re getting your information, however good topic.
    I must spend some time studying much more or understanding more.

    Thanks for fantastic information I used to be looking for this info for my mission.

  9. I am now not sure where you’re getting your info, however
    great topic. I needs to spend a while learning more or understanding more.
    Thank you for excellent info I used to be
    looking for this info for my mission.

  10. headach said

    Is possible to bring in beginning balance for each period ( report has 12 periods) in FSG?

  11. A.Manivannan said

    unable to see parent values in FSG parameters for specific responsibilites

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: