1. How do I find the latest FSG patch that is available?
For the General Ledger Patch List, on MetaLink, click on Top Tech Docs...General Ledger...Patchset Information (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 flex-field 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. 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.
8. How do you enable FSG security?
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.
Flex-field 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.
Prerequisites
- 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 not 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.)
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?
No. That functionality is not available. Enhancement Request 1569021 has been logged for this.
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.
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).
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.
-----------------------------------------------------------------------
Note:1012620.102PROBLEM DESCRIPTION:
You are not getting the results you expected in your Financial Statement Generator (FSG) reports when using parent values.
How is the profile option, 'FSG:Expand Parent Value' used?
PROBLEM EXPLANATION: The Oracle General Ledger documentation (User's Guide and Reference Manuals) describe this profile option, but the explanation is not clear.
Here is the profile option documentation from the manuals:
Control 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 vaue 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.
SEARCH WORDS: summary account, balance, summary flag, rollup group, child range,detail account, financial statement generator, row set, accounting flexfield range, account range, FSG
REFERENCES: Oracle General Ledger Release 10SC, User's Guide, part number A21643-7, pages B-5 through B-6.
Oracle General Ledger Release 10.7 Volume 2, Reference Manual, part number A13113-5, page C-4.
SOLUTION DESCRIPTION: The FSG:Expand Parent Value profile option controls whether FSG expands a parent value into its child ranges or uses the parent value.
The summary flag contols whether FSG looks for summary accounts or detail accounts.
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 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 following are the possible scenarios:
Example 1: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value belongs to a Rollup Group
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 2: FSG:Expand Parent Value = Yes , Summary Flag = Yes
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for summary accounts that have values for this segment that are within these child ranges. (The summary template associated with this summary account would have to have a 'D' for this segment.)
Example 3: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value belongs to a Rollup Group
Result: FSG looks for detail accounts that have this parent value for this segment. It does not expand the parent value into its child ranges. It is never going to be successful.
Example 4: FSG:Expand Parent Value = Yes , Summary Flag = No
Parent Value does not belong to a Rollup Group
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Example 5: FSG:Expand Parent Value = No , Summary Flag = Yes
Result: FSG looks for summary accounts that have this parent value for this segment. It does not expand the parent value into its child ranges.
Example 6:FSG:Expand Parent Value = No , Summary Flag = No
Result: FSG expands the parent value into its child ranges, then looks for detail accounts that have values for this segment that are within these child ranges.
Note:1036437.6PROBLEM DESCRIPTION:
When you run your Financial Statement Generator (FSG) report for the month of July, the amount type YTD-budget (FY End) column prints zeroes.
You have budgets for January through June, but nothing specified for July.
SEARCH WORDS: FSG Financial Statement Generator
SOLUTION DESCRIPTION:
In order for the amount type YTD-BUDGET (FY END) to print, you MUST enter a budget for all periods including the adjusting period. This is documented on page 3-111 of the General Ledger Reference Manual for release 10.7. You can enter a number in the adjusting period and run the report again. This forces the report to print correctly.
Note: If you set up the budget for 12 periods without an adjusting period, you cannot add an adjusting period or change the last period of the budget once the budget setup process is completed.
Note:138143.1
QUESTIONS & ANSWERS:
1. I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?
Answer: Make sure that you have enabled security at both the segemnt and value set levels, it must be enabled at both these levels to work. Also make sure you have switched out and back into the responsibility.
2. My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.
Answer: This functionality is available starting in Release 11i. In Releases 11 and lower, one cannot set security for standard reports. Security Rules will only limit users from a few functions (e.g. Account Inquiry, Budgets, Journal Entries, and FSGs). In addition,in Release 11i there is limited use of the security rule functionality for running standard reports. It appears that your goal is to restrict users from submitting reports for a particular company, this cannot be accomplished using security rules.
3. In Rel 11i with the intercompany segment being used, is it possible to have a security rule on the balancing segment (company) without it affecting the intercompany segment, since they share the same value set?
Answer: Yes it is possible. You would enable security on the value set, but then on the flexfield segment (intercompany) you would not enable security.
4. Is there a way to assign different security rules to a responsibily based on the User ID?
Answer: You cannot apply different security rules to the same responsibility for different users based on the user ID. You will have to create a new responsibility and define its own security rules. Then you can assign the new responsibility to one of the users.
5. Can security rules be used to control the posting of journal entries?
Answer: Security rules apply only with regards to creation/modification of lines within a journal. They do not apply when the journal is posted.
6. Security rules don't seem to work on all forms when performing a query.
Answer: Flexfield Value Security gives you the capability to restrict the set of values a user can use during data entry. With easy-to-define security rules and responsibility level control, you can quickly set up data entry security on your flexfield segments and report parameters. Flexfield Value Security lets you determine who can use flexfield segment values and report parameter values. Based on your responsibility and access rules that you define, Flexfield Value Security limits what values you can enter in flexfield pop-up windows and report parameters.
Security rules for the Accounting Flexfield also restrict query access to segment values in the Account Inquiry, Funds Available, and Summary Account Inquiry windows. In these windows, you cannot query up any combination that contains a secure value. However in all other forms, you will be able to query up a value even if it is restricted to the user.
Reference Oracle Applications Flexfield Guide Release 11, page 5-10.
7. Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?
Answer There is not a way in the same set of books, to prevent users from one operating unit via security rules, from changing cross validation rules for another operating unit. The only way to do this would to be create a separate set of books for each operating unit. Since security rules prevent users from either viewing data or entering data in general, they do not pertain to set up issues such as creating cross validation rules.
Therefore, the only other way to prevent one user from one organization from creating cross-validation rules to the other organization, when in the same set of books, would be to completely remove that menu function from the user.
8. Every Country has a Global Manager or User Responsibility to access Global SOB but it is supposed to limit users to their own Legal Entities. However, an Argentian journal can be posted by the Chilian user. How is this possible?
Answer This is working as intended. Security rules will prohibit a responsibility from being able to ente certain values as well as prohibit the viewing of those values. However security rules will not prohibit the actions above because they are in the same set of books. The system does not determine if a journal has values in it that are blocked by security rules. If it did that, the journal would appear as unbalanced. There would have to be an incredible amount of logic involved, which would further reduce performance, for the posting program to scan the journal for security rules first before posting. Posting does not take into consideration the rules, this is done at the time of journal entry.
9. Forgot to check the security enabled flag for each segment and it is not updatable. How do I correct this?
Answer Check your Accounting Flexfield structure to see if it is frozen. Unfreeze the structure, then you should be able to enable Security for the Segment.
10. In General Ledger, a security rule of a parent with children was set up to include the parent and assigned to a responsibility. However it is not functioning properly.
Answer: The system allows the account the customer wanted but doesn't disallow the ones that are children of the parent values excluded. Review note OSS177300 Titled: Key Flexfield Rollup Hierarchical Security not Working Properly.
11. Is it feasible to delete an Exclude statement in order to resolve a Security Rule issue?
Answer The Security rule should not be modified by deleting an exclude or include as it may corrupt the rule. Instead, delete all rule lines (include and excludes), save and redefine the include and excludes. If the rule still doesn't work, create a new rule and assign it to the responsibilities in place of the original rule.
12. What standard reports have security enabled in Release 11i?
Answer Trial Balance, Account Analysis and General Ledger are the only standard reports in Release 11i for which security rules apply.
13. Is it recommended to use a universal Include when setting up rules?
Answer It is recommended to start each security rule with a universal Include statement and then eliminate each value using Exclude statements.
14. What functions do security rules apply to?
Answer Security rules apply to Account Inquiry, budgets, FSG's and journal entry functions. In Release 11i, this also applies to several standard reports (listed previously). Please note, they do not apply to the posting of journals or the review of journals. When reviewing a journal with security rules, the totals are still displayed, it is only the individual lines that are not visible. This is standard functionality.
15. What is Hierarchical Security?
Answer Please see Note:164769.1 for information regarding this new feature. For addition information go to Metalink:
1. Logon to Metalink.
2. Select Top Tech Docs -> Top Tech Docs button (it says 'Click for the original Top Tech Doc pages') -> ERP Applications -> Financials -> General Ledger
-> Documentation -> Release 11i General Ledger Product Documentation ->Doc Update Oracle General Ledger User's Guide, Hierarchical Security
Note:1083689.6Problem Description
-------------------
Running: RGRXFR - Program - FSG Transfer and receiveing an error.
Responsibility = General Ledger Super User
Navigation = Reports -> Request -> Standard
Report/Program Name = Program FSG - Transfer (RGRXFR)
Running this program completes in error and produces a log file with a error
message much like the following:
Encountered error while transferring report '&REPORT'
Cancelling transfer of this report
DECLARE * ERROR at line 1:
ORA-00904: invalid column name
ORA-06512: at line 147
Program exited with status 1
Cause: The program completed execution -in particular with status 1
Solution Description
--------------------
You are trying to transfer FSG Report Objects from a 10.7 Applications
instance to a Release 11 or 11.5 Apps instance.
You cannot transfer objects from one release to another. In Release 11/11.5, changes have been made to the tables, eg. the addition/removal of columns etc. Therefore when you try to transfer, the process RGRXFR cannot find the column name it is being referred to.
Search Words
------------
rgrxfr, status 1, ora-6512
Financial Statement Generator
Note:1037253.6Problem Description
-------------------
You are trying to run an FSG (Financial Statement Generator) report which
will NOT show segment descriptions on the top of the rows as follows:
Responsibility = General Ledger Super User GUI
GUI Navigation = Reports/Request/Financial
GUI Form Name = RGXGRRST (Run Financial Reports)
1. Navigate to Reports/Request/Financial.
2. Place your cursor in Report field and select the report to run by clicking on Query/Find or the Find icon (flashlight) on the toolbar.
3. After report is selected, place cursor in the Period field and enter or select from list of values (LOV) the desired report period.
4. Click on the [Submit] button to submit this report. When this report is generated, you do not want the header descriptions for particular account segments to be displayed. An example of the report header would be -
Currency: USD
No Specific Company requested
CO REG CC ACCT PRD SUB
--- ---- --- ----- ---- ----
Solution Description
--------------------
You will need to define a Row Order to be used with the FSG in order for the headings to NOT display. The row order must contain all segments of the flexfield. To suppress the header description for particular account segments, set the width to 0 for those segments. Attach the row order to the FSG report.
To do this, sign into Oracle applications as General Ledger Super User GUI and follow the steps listed below:
I. Define Row Order
----------------
GUI Navigation = Reports/Define/Order
GUI Form Name = RGXGDORD (Row Order)
1. Navigate to Reports/Define/Order.
2. Enter a Name and Description for your row order.
3. Place your cursor in the 'Seq' field of the Account Display region and enter a sequence number for the first segment in your account combination.
4. Tab to 'Segment' field and select the segment to display from your list of values (LOV).
5. Tab to 'Order By' field and select the order of segment to be displayed.
6. For all segments segments whose header description you wish to suppress, set the Width field to 0.
7. Repeat this for each segment in your accounting flexfield.
8. Save your work before exiting the form.
II. Define Report
-------------
GUI Navigation = Reports/Define/Report
GUI Form Name = RGXGDREP (Define Financial Report)
1. Navigate to Reports/Define/Report.
2. Place your cursor in the 'Row Order' field of the Optional Components region and query the row order you created in Step I (above).
3. Save your work before exiting the form.
III. Run Report
----------
Run the report as listed in the Problem Description.
Search Words
------------
Accounting Flexfield Segment, Heading, Header
Note:1014255.102Problem Description:
====================
Is reporting on multiple level segment hierarchies possible
using the Financial Statement Generator (FSG)?
Can this be done by defining a single Row Sequence?
Problem Explanation:
====================
You have tried to report on a grandparent segment value and the parents
assigned to that grandparent segment value in an FSG, with a single row
sequence in your row set. The generated report did not provide the
expected hierarchical level of detail. You were expecting to get the
accounts and amounts for the parents. Instead you got the accounts and
the amounts for the lowest level hierarchy - the non-parent children.
Search Words:
=============
parent value, grandparent value, row sequence, row set, FSG:Expand Parent Value , hierarchy , total , subtotal
Solution Description:
=====================
-- In order to report on Multiple Hierarchy levels 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.
Solution Explanation:
=====================
-- To get a report with grandchildren detail, parent subtotals and a
grandparent total, do the following. The example below assumes the
grandparent has 3 children, who are each parents themselves. The 3rd
level contains only low level children.
GP
---------------------
P1 P2 P3
------- ------ -----------
C1 C2 C3 C4 C5 C6 C7
(The YTD amounts posted to the detail level accounts in the example are:
C1 = $1, C2 = $2, C3 = $3, C4 = $4, C5 = $5, C6 = $6, C7 = $7)
Set the Profile Option "FSG: Expand Parent Value" to Yes.
I. Set Up The Account Hierarchy
-------------------------------
1) Navigation = Setup=>Financials=>Flexfields=>Key=>Values
Enter Application = Oracle General Ledger
Title = Accounting Flexfield
Structure =
Segment =
2) Define the low level child accounts values C1 through C7.
3) Define the three parent accounts, P1 through P3. In the Blue
Drop Down box select Hierarchy,Qualifiers. Check the Parent Box
for each of these three values.
Define the child ranges for each parent by clicking the [Define Child Ranges] Button. None of the children are parents, so select Child Values Only in the Include column. Only child values within the range will be picked up.
Example: For P3 Parent
From To Include
----- ----- -------
C5 C7 Child Values Only
4) Define the grandparent account GP. Check the Parent box for this value as well. This time define the child ranges as the parent segment values that you had defined in step 2. Set Range Type ( Include ) to Parent. Only values that are defined as parents within the range will be picked up.
From To Include
----- ----- -------
P1 P3 Parent Values Only
5) Save your work.
The hierarchy assignments will launch a flexfield compilation process. Ensure that this process completes successfully by reviewing it from the Requests form (From the toolbar: Help..View My Requests).
II. Define the FSG
------------------
1) Navigation = Reports=>Define=>Row Set
Enter a Row Set Name.
Enter a Description and a Report Title.
Click on the [Define Rows] button.
Create one row sequence for each of the 3 parent values. Enter account assignments using 'B'oth as the display type, to show both the detail and total for the parent.
Line = 10 Line Item = The amounts for Parent P1
Low High Display
---- ----- --------
P1... P1... B.T.T...
Or use 'T'otal in the Display, if you just want a total for the parent.
Define Lines 20 and 30 doing the same for Parents P2 and P3.
2) Create one row sequence (line) for the grandparent GP. Enter
a calculation sequence that sums the row sequences created for
each parent.
Line = 40 Line Item = The calculated total for GP
Click on the Calculations Radio Button.
Seq Operator Constant Low High Row Name
---- -------- -------- --- ---- ---------
10 + 10 30
Alternatively,
Specify the grandparent value, with 'T'otal for the
display type by entering the following account assignment.
Sign Low High Display
---- ----- ------ --------
+ GP.XXX GP.XXX T.T.T...
Do not check the Summary Box in any of the account
assignments while defining the row set.
You will obtain the following report:
YTD-Actual
P1 The amounts for Parent P1
C1 1
C2 2
TOTAL 3
P2 The amounts for Parent P2
C3 3
C4 4
TOTAL 7
P3 The amounts for Parent P3
C5 5
C6 6
C7 7
TOTAL 18
GP The Calculated Total for GP 28
If you do not get desired results from the FSG run the Standard report
"Chart of Accounts - Rollup Detail Listing" to make sure that the
parent/child relationships and hierarchies are defined correctly.
Note:1014921.6· goal: How to define an FSG percentage calculation column such as percent of · sales· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator· · fix: Problem Description------------------- How can a column (C3) that represents another column (C1)as a percentage of the column (C1) total in FSG's (Financial Statement Generator) be defined? Example-------C3 represents C1 as a percentage of the TOTAL in column C1. C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% Solution Description-------------------- When defining a row, user can enter a value in the 'Percent of Row' field.The value entered in this field is the sequence number of the row, that willbe used as the denominator in the calculation of the percentage column. For the following example: C1 C2 C3 -------------------------------- R1 30 15% -------------------------------- R2 70 35% -------------------------------- R3 80 40% -------------------------------- R4 20 10% -------------------------------- TOTAL 200 100% 1. In the Define Row Set screen, define rows R1, R2, R3,R4 with sequence numbers 10, 20, 30,40 respectively, and define account assignments for each row. 2. Define the TOTAL row as a calculation (i.e., the sum of the rows R1 through R4 as follows: Click on the calculation button in the Define Row Set screen, then enter the data below on the Calculations screen Seq Operator Constant Low High Row Name 50 + 10 49 NOTE: This does not have to be a calculation. You can use account assignment ranges instead to obtain your total amount. 3. In the Row Definitions for R1, R2, R3 and R4 enter the sequence number 50 (i.e., the sequence number of the TOTAL row) in the 'Percent of Row' field. 4. In the Row Definition for the TOTAL row, select the checkbox option 'Override Column Calculations', so that it is checked. (This allows the TOTAL row calculation - the sum of R1 through R4 to be enforced across the entire total row, even if there is a conflicting column calculation, as is the case with the intersection of C3 and TOTAL.) If this row is not a calculation, do not check Override Column Calculations. 5. In the define column set screen, when defining column C3, -- Leave the Amount Type and Offset fields blank -- Select the Calculations button, and define the calculation for column C3 as follows : Seq Operator Constant Low High Column Name 1 % C1
Note:207779.1· goal: How do FSG Segment Overrides, Content Sets, Account Assignment Ranges · and Display Types work together?· · fact: Oracle General Ledger· · fact: RGRARG - Financial Statement Generator · · fact: RGXGDAXS - Define Axis Set· · fact: RGXGDCON - Define Content Set· · fact: RGXGDREP - Define Report· · fact: RGXGRRST - Request Report Set· · fix: Account assignments ranges: Account assignment ranges can be defined in both the row and the column set. If you enter accounts for both rows and columns, FSG only reports on intersecting accounts. You can enter a different set of books for each account assignment range, if the sets of books share the same chart of accounts and calendar as your current set of books. The set of books shown in the list of values are those with the same chart of accounts and calendar as the set of books assigned to your current responsibility. Content sets: Content sets override the account assignments in your row set. When a flexfield assignment is defined in a content set, the values defined there take precedence over the values defined in each row within the row set. This applies to the Display options as well. See <Note:147218.1> for more information. Display Types: Any kind of Expand with multiple account assignments in one row sequence is not supported. You must use a display type of T (Total) for each segment if you assign: - Accounts to a column. - Multiple account ranges to a row. The same rules apply to Content Sets. You can not use a display type that expands, such as RE, RB or PE, if you assign: - Accounts to a column. - Multiple account ranges to a row. If you need to expand, but have multiple account assignments ranges in one row sequence, you can: - Break out those account assignment ranges into separate row sequences. OR - Define a single row that encompasses the ranges needed. If the values are not in sequence, create a parent value that contains the values you want to expand on, the use that one parent value in the account assignment. Segment Override specified on Define Financial Report form: Enter values for the account segments you want to override. When you enter a segment override value, FSG produces a report for that specific value. For example, assume you have a report definition which produces a combined assets report for four companies. If you modify the report definition to add a segment override for company value 01, then FSG will create the report for company 01 only. Segment Override specified at runtime: Enter values for the account segments you want to override. When you enter an override segment value, FSG produces a report for the specific company, cost center, product or other value associated with that segment. If you don't provide a segment override, FSG uses the one specified in the report definition, if any. This will override the assignments even if assignments are made in both the row and column. This will also override segment overrides defined in the column set. NOTE: A segment value that has been disabled cannot be used as a segment override; at runtime or on the Define Financial Report form. However, you can use a segment value that has been end-dated. See <Note:1057153.6> for more information. Override Segment on Column Set: Use the override segment feature to produce reports that show information for each department or company, with one column for each. Define one of your segments as the Override Segment on the Column Set form. Define one column for each of your values in that segment that you want to report on (for example create one column for each department). On each column definition, specify the Override Value that you want to report on (for example, department 01 for Sales). If you define an Override Segment, but do not define an Override Value for a column, FSG will substitute an all encompassing range (e.g. all zeros to all Z's) for that segment in that column. An override segment defined on the column set will take precedence over all other overrides for that same segment (content set, report definition or a runtime override).
Note:141278.1· goal: How to Create a Trace File and Run Tkprof in Applications - Condensed · Version· · fact: SQL Trace· · fact: Oracle Application Object Library· · fix: WHAT TO SET UP BEFORE GENERATING THE TRACE These steps must be performed by the DBA on the database server. 1. Set TIMED_STATISTICS to TRUE. For performance issues, make sure TIMED_STATISTICS is turned on, before attempting to generate the trace. Set the following in the init.ora file: TIMED_STATISTICS=TRUE OR in SQL*Plus: ALTER SYSTEM SET TIMED_STATISTICS=TRUE; 2. Set the location of the trace output. Set the following in the init.ora file: USER_DUMP_DEST =
1 comment:
i AM TRYING TO EXPAND ROW SET FOR NATURAL ACCOUNT BUT SYSTEM IS SHOWING ONLY SOME ACCOUNT I.E. 11 ACCOUNTS BUT I HAVE GIVEN RANGE FROM 00000 TO ZZZZZ
AND I HAVE ALSO CHECKED DISPLAY ZERO CHECK BOX FOR YES
Post a Comment