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