My Oracle Support Banner

General Ledger FAQ for FSG Functional (Doc ID 108236.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle General Ledger - Version 11.5 to 12.1 [Release 11.5.0 to 12.1]
Information in this document applies to any platform.
Executable:RGRARG - Financial Statement Generator
Form:RGXGDORD.FMB - Define Row Order
Form:RGXGDCON.FMB - Define Content Set
Executable:RGRXFR - Program - FSG Transfer


To aid users and support analysts in problem resolution.

Questions and Answers

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
Questions and Answers
 1. How do I find the latest FSG patch that is available?
 2. Is there a way to suppress zero amounts on the FSG Report?
 3. How do you print credit amounts on the FSG Report as positive instead of negative numbers?
 4. Can I display account descriptions on the FSG Report in addition to the account segment values?
 5. Is there a limit on how large a FSG Report can be?
 6. What is the profile option 'FSG: Expand parent value' used for?
 7. I am trying to display budget amounts in my reports but they are not showing up or are incorrect. What is wrong?
 8. How do you enable Flexfield Security Rules for FSG?
 9. How can you add/define/create your own new amount types in FSG reporting?
 10. Where should the period offset and the amount type be specified?
 11. On a calculation column, can I enter an amount type?
 12. Is there a quick and supported method of transferring FSGs between environments, so that users do not have to key them in twice?
 13. What FSG enhancements are introduced in Release 11i ?
 14. Can I remove the 'No specific Company requested' text from the FSG heading?
 15. Can I remove the segment header descriptions from the top of the FSG reports?
 16. Can I customize or move the 3 heading lines that appear at the top of the FSG (set of books, report name, period)?
 17. How can I display USD and STAT amounts on the same FSG report?
 18. How can I report on a multiple level account hierarchy in an FSG?
 19. How can I define an FSG percentage calculation Column such as percent of sales?
 20. Can an FSG output be created in PDF format?
 21. What is the meaning of 'n/m' on my FSG?
 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?
 23. Can FSG reports and components be secured/protected so only certain people can modify or run them?
 24. How do segment overrides, content sets, account assignment ranges and display types work together?
 25. When hiding data using a Display Group/Set in FSG the underline under that data still appears.
 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?
 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?
 28. Why can some column sets be viewed/used with different sets of books and others cannot?
 29. How do I see the SQL code behind the FSG report?
 30. How do I show the YTD amount for the end of the fiscal year on an FSG?
 31. Can I create an FSG in html format?
 32. How can I run an FSG from the Standard Request Submission form?
 33. When using a content set, sometimes the amounts are duplicated (doubled or tripled).
 34. How Can You Print A Parent Account Description In The Row Set ?
 35. Can I make the same FSG report work for both my sets of books ?
 36. How do I find which FSG patches I have applied. ?
 37. How can I increase the size of the description displayed on the report ?
 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?
 39.  (R12) How can you report on a budget entered in a foreign currency?
 40. Is it possible to create FSG Components using Web ADI? 
 41. Why is Ledger name different on column set form and column set detail  listing report? 
 42. Can FSG reports be printed in foreign languages instead of base language? Is there any such setup?
 43. Community Discussions

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