Financial ReportingOverview of Reporting in General LedgerGeneral Ledger provides you with a variety of reporting capabilities, including the Financial Statement Generator, online inquiries, and standard reports and listings. Show
Overview of the Financial Statement GeneratorFinancial Statement Generator (FSG) is a powerful report building tool for Oracle General Ledger. With FSG, you can:
Related Topics Report Building Concepts Simple Reports Special Format Reports Report Distribution Other FSG Features Using Financial Statement Generator Overview of Average Balance Processing Report Building ConceptsIn Financial Statement Generator, you build a report by defining, then combining, various reusable report objects. Some objects are required for every report you intend to build. You can use others to apply special formatting to reports. Finally, there are objects you can use to control report content, distribution, and scheduling. The objects you need for a specific report depend on the report's complexity. In the next three sections, we discuss report objects in terms of:
FSG features are also introduced under these section headings. Related Topics Simple Reports Special Format Reports Report Distribution Other FSG Features Overview of the Financial Statement Generator Simple ReportsThe simplest reports consist of a few headings to describe the information in the report, followed by the report data, which is often presented in tabular form as a series of intersecting rows and columns. Therefore, simple reports are two dimensional in nature, similar to what you might create in a spreadsheet. The rows and columns determine the values which appear in the body of a simple report, by virtue of the attributes those rows and columns possess. For example, consider a row whose attribute is the balance sheet account named "Inventory" and a column whose attribute is "Sept. 1996." A report "cell" defined by the intersection of row "Inventory" and column "Sept. 1996," will contain the inventory account balance for September 1996. Topics in This SectionRows, Columns, Row Sets, and Column Sets Typical Report Dimensions Standard Reusable Column Sets Defining Rows and Row Sets, and Assigning Accounts Display Types Basic Report Formatting Defining Reports Rows, Columns, Row Sets, and Column SetsWith FSG you use this fundamental row/column concept to build your own financial reports:
FSG further simplifies report building by allowing you to group multiple row or column definitions into "sets." For example, suppose that you've just defined a simple report which uses two columns with the attributes "Year Ended 12/31/95" and "Year Ended 12/31/96." You realize that you might want to use these two columns for many other reports besides the one you've just defined. With FSG, you can define and save a Column Set which consists of these two column definitions. Then, whenever you need a new report based on these two columns, you simply tell FSG to build a report using the column set. You can do the same thing with groups of row definitions, and create Row Sets. Row sets and column sets are the two primary building blocks of FSG reports. These concepts are illustrated in the report shown in the figure below. Basic FSG Report Objects For a text description of this figure, see Text Description of the Basic FSG Report Objects Figure, Oracle General Ledger Reference Guide. Notice that this simple report is built using one row set and one column set. The row set contains many row definitions while the column set contains four column definitions. Here are some other characteristics of rows and columns, as illustrated in the above example:
Typical Report DimensionsThe example in the figure named Basic FSG Report Objects illustrates another important FSG concept: Generally, accounts are assigned to row definitions and amount types are assigned to column definitions. In the example, these typical report dimensions produce an expense listing where each report line is an expense account and the two primary columns are the year-to-date actual expenses as of December 1995 and December 1994. Standard Reusable Column SetsYou may be able to build many of your financial reports by using the fourteen standard column sets we predefine, such as monthly comparative year-to-date or period-to-date variance. For more complex reports, you can define custom column sets. Defining Rows and Row Sets, and Assigning AccountsRows are subcomponents of row sets. They are defined when you create a new row set. Each row definition for a simple report includes, at a minimum:
The following table shows a sample row set for a simple report, using account assignments for a single ledger: Example Row Set Definition
In this example, the report lines generated by the row definition with sequence number 10 will appear first on the report, followed by the report lines for the row with sequence 20, then 30, then 40. The data for these report lines are derived from the Vision US ledger. Display TypesWhen you make an account assignment to a row definition, you also specify one of three display types for each segment of the account structure. The display type controls the level of detail FSG will show on your report for individual report lines: Expand: Your report will include one line for each value of the account segment. For example, assume your last account segment can have one of three values and that the account balance is as follows:
If you choose Expand for the account segment, the FSG report will include one report line for each of the account values listed above. If you choose Expand for the ledger segment and the ledger segment value is a ledger set, the FSG report displays individual rows for the ledgers of the ledger set and shows the ledger short names. The ledgers are listed in order of their ledger short name. If the ledger segment value is a ledger, then the FSG report displays data for the ledger. For example, assume your ledger segment references a ledger set, Vision US ledger. Your ledger set contains two ledgers, Vision East US and Vision West US. When you select the Expand display type, your report includes one report line per ledger and looks similar to the following:
Total: Your report will include only one line for that segment, which is the total of the amounts for all values of the account segment. Using the same example, if your row definition specifies that the last segment of your account be totaled, your FSG report will include only one report line instead of three, as follows:
If you choose Total for the ledger segment and the ledger segment value is a ledger set, the FSG report totals the ledgers in the ledger set and displays rows for the totals without displaying the individual ledgers. For example, using the ledger set example above, when you select the Total display type, your report includes one report line per account per ledger set total and looks similar to the following:
Both: Your report will include both the expanded detail and the total, as follows:
If you choose Both for the ledger segment and the ledger segment is a ledger set or ledger, the FSG report displays both the expanded detail and total rows for the ledger and ledger set. For example, using the ledger set example above, when you select the Both display type, your report includes one report line per ledger, as well as a report line for the ledger set total and is similar to the following:
If you use reporting currencies (journal or subledger level), you can specify a reporting currency in place of a ledger and have all of the functionality described above for your rowsets defined with a reporting currency. Basic Report FormattingIn a simple report, the standard column set you choose determines the basic data item formatting, such as whether to display a currency symbol or how many decimal positions to include. Standard column sets also have predefined column headings. Row labels, as well as the column headings above the row labels, are inserted into your report by FSG automatically. The Report Title, which you specify when you define the report's row set, is also added automatically, along with the date/time the report is printed, page numbers, and the current period. Other formatting which you control for simple reports includes indenting, line skipping between rows, underline characters (for subtotals and totals), and page breaks. For more formatting options such as changing font characteristics, you can use BI Publisher to publish your FSG report with a designed layout and format. Use BI Publisher to apply a basic report template layout and format to your FSG report. For additional information on generating FSG reports with BI Publisher, see FSG Reports Using BI Publisher. No formatting is required for XBRL output. Defining ReportsDefining a simple FSG report is quite easy once you've defined your rows and row set. You only have to give the report definition a name and optional description, then assign your row set and a standard column set to it. That's all there is to it. Once defined, you can generate the report at any time by telling FSG to run it. Related Topics Report Building Concepts Special Format Reports Report Distribution Other FSG Features Overview of the Financial Statement Generator Using Financial Statement Generator Defining Row Sets Defining Column Sets Standard Column Sets Assigning Accounts Row Set Display Types Defining Financial Reports Special Format ReportsFSG lets you add special formatting to your reports and create custom reports which meet specific business needs. You do this by taking a simple report and adding other report definitions and report objects. For example, you can define your own column sets instead of using the standard column sets. FSG also provides you with more formatting options for the design layout and format of your FSG report. Use BI Publisher to apply a report template layout that you design to your FSG report. Publishing FSG reports with BI Publisher allows you to change font characteristics, add logos or images, and insert headers or footers into your report. For additional information on generating FSG reports with BI Publisher, see FSG Reports Using BI Publisher. Topics in This SectionColumn Set Builder Format Masks Column Headings Relative Headings Calculations Row Orders Exception Reports Display Options Rounding Options Override Segments Column Set BuilderTo simplify defining column sets, FSG provides the Column Set Builder-a graphical tool for building report layouts. The Column Set Builder displays column definitions graphically, which makes it easier to lay out your reports, and gives you a good idea of how a report will look after FSG runs it. There are two main areas to the Column Set Builder window. The top half is used to define each column, and the bottom half is used to create custom headings and enter format masks for each column definition. Column Definition AreaFor each column definition, you enter four pieces of information; Sequence number, Name, Amount Type, and Period Offset. Unlike row sequence numbers, column sequence numbers do not control the order FSG displays report columns. Columns are displayed on your reports in exactly the order they appear in the Column Set Builder window. You refer to a column's sequence number when you define calculations in another column (more on this later). Recall that most columns are defined using an amount type. General Ledger provides numerous amount types, which define a period type and balance type. For example, the amount type QTD-Actual specifies a quarterly period type and actual balances. The amount type YTD-Encumbrance specifies a yearly period type and encumbrance balances. FSG uses the Period Offset to determine which specific periods' balances to include on a report. Period offsets are specified relative to the period you specify when you request that FSG run a report. For example, if you want a report of monthly cash balances for January, 1996 through December, 1996, the period-of-interest is DEC-1996. If one of your column definitions has a period offset of -6, FSG will display the cash balances for June, 1996 in that column. Note: For the average balance processing amount types, the Period Offset control value definition returns average balances information from the last day of the period that is referenced. FSG uses the Constant Period of Interest control value definition to determine a specific periods’ balances to include on a report. Unlike period offsets, the constant period of interest is not relative to the period you specify when you request FSG to run a report. The constant period of interest reports on the same accounting period every time you run an FSG report, regardless of the specified period at run time. This is useful for referencing fixed periods in the report, even as the reporting period changes, avoiding the need to constantly modify the report definition. The constant period of interest is determined by two parameters, the period number and the relative year. For example, assume you use a 12 period fiscal year based on a standard monthly calendar. For the column in the report representing the constant period of interest, you specify the period number to be 12 and the relative year to be a –1. When you run the FSG report for any of the periods between January to December 1996, the Constant Period of Interest column displays data for December, 1995. If you run the report for period March 1997, the Constant Period of Interest column displays data for December, 1996. Note: For the average amount types, the Constant Period of Interest control value definition returns average balances information from the last day of the constant period that is referenced. Column Set Builder, Headings Area Other than format masks and relative headings, which are explained in separate sections, the most important thing to note about creating column headings is the positioning of columns across the report. Two factors control this: Left Margin: This is the starting position of the leftmost column, to reserve space for FSG to print your report's row labels. Column Width: Each column has a specific number of print positions defined, know as the column width. The width must be large enough to hold all printable characters, including currency symbols, decimal points, and number separators. There is also a margin area at the left to define the report areas above the row labels and to the left of the column headings, a ruler to help layout headings, and heading definitions for each column of the report. Format MasksA format mask defines how numbers are displayed in your reports. You can specify numbers, decimal places, currency symbols, and other display characters. For example, if you use a format mask of $99,999,999, FSG will display the number 4234941 as $4,234,941. Note: To use all of the available formatting options, additional set up steps may be required in General Ledger. The most important thing to remember when using format masks is to make sure you include enough space in your column definition to print all the numbers and special characters allowed by the format mask you use. Column HeadingsHeadings can include any alphabetic or numeric characters. They may also include special characters, except for the ampersand symbol (&). FSG also provides a default heading option, which you can use as is or modify to build a custom heading. To publish your FSG report using BI Publisher, be aware of the following functionality when building your heading:
Relative HeadingsYou use FSG's Relative Headings feature to define dynamic headings whose content changes depending on some value you provide when you request the report. You define relative headings by combining:
For example, &POI-10 indicates the tenth period before the period of interest. &POI+6 or &POI6 indicates the sixth period following the period of interest. POI0 is the period of interest. For another example, look at the Column Set Builder, Headings Area figure again, the Column Set Builder Headings Area. The example column set produces a rolling monthly report. In other words, the report has twelve columns representing monthly actual balances. The twelfth monthly column, as shown in the table below, is defined to display values for the period of interest. The first monthly column is defined to display values for the period which is eleven months before the period of interest. For illustration purposes, the following table shows how the first and twelfth columns are defined and how the related report columns will be displayed. Note that the column definitions for &POI-10 through &POI-1 are not shown. Period of interest: December 1996 Example Relative Headings
Using relative headings with period offsets or constant periods of interest is a great way to create generic column sets which can be used with numerous FSG report definitions. CalculationsYou can create a row or column definition to calculate values which are then displayed on your report. This is especially useful for adding subtotals, totals, variances, and percentages to your reports. You can also create non-displayed rows or columns to hold the results of intermediate calculations, that are used in other calculations. As with client-based spreadsheet programs, you can use other rows or columns in your calculations. For example, you can define a calculated row which adds a range of other rows to arrive at a subtotal. Or, you can define a calculated column which subtracts one column from another to yield a variance column. FSG provides a wide range of operators you can use in calculations, including functional operators such as Average, Median, and StdDev (standard deviation), Absolute Value, and, of course, your computations can include constant values. For XBRL output, calculations must be performed at the row level only. If you choose a column set that contains calculated columns, the report will complete with a warning and the calculation results will not be present. A log file identifies the columns that could not be processed. Row and Column ConflictsCalculations are one example of where a row definition and a column definition might conflict. For example, consider the following report: Row and Column Conflicts For a text description of this figure, see Text Description for Row and Column Conflicts, Oracle General Ledger Reference Guide. When there are conflicting calculations in a report, FSG will use the column calculation instead of the row calculation, unless you tell FSG (in the row definition) to override any conflicting column calculations. There are other situations besides calculations where row and column definitions might conflict, such as format masks, period offsets, and amount types. FSG follows a set of precedence rules for all such row/column conflicts. For more information, see Row and Column Overrides. Row and Column NamesWhen creating a calculation row which uses another row in the calculation, you refer to the row by its assigned Sequence Number. Optionally, you may give the row a Row Name when you define it, then refer to the name when building a calculation. The same rules apply to columns. If you use the optional row and column names, the names will appear in other FSG windows, making it easier to remember what those rows or columns represent. Also note that if you use row and column names in your calculations, the names must be unique within the row set or column set. If not, your calculations may yield incorrect results. Row OrdersThere are three key things which you can do in your reports, using FSG's Row Orders feature:
Exception ReportsException reports are very easy to build in FSG. When you define a column set, you can also define exception conditions for any or all of your column definitions. FSG will apply these exception conditions to any report which uses the column set. For example, assume you're building a variance report and you want to flag any variance amount which exceeds $50,000. In the variance amount column definition you simply create an exception condition which tells FSG, "if the amount in this column is greater than 50000, print an asterisk character." Display OptionsFSG provides a number of additional display options you can apply to the rows and columns in your reports. These include:
Rounding OptionsYou control how FSG performs any rounding which results from calculations you've defined for your report's columns or rows. In some cases you will want FSG to perform the calculations before any rounding is done. Other times, you may want the rounding to be done before the calculations are made. FSG lets you control this when you define your reports. Note: The rounding option can be saved as part of a report definition, or can be added dynamically at the time you request an FSG report. XBRL output ignores rounding options. Override SegmentsYou use the override segments feature to produce "breakdown" reports. For example, let's say that you've defined a report which produces a corporate income statement. Now you want to create a breakdown version of the same report which shows income statement line items for each department, one report column per department. Department is one of your account segments, and can have one of five values (01 = Sales, 02 = Manufacturing, 03 = Finance, 04 = Administration, 05 = Corporate). The original report definition uses a row set named Income Statement and a column set named Corporate YTD-Actual. To produce the breakdown report, you need to define a new column set with the following properties:
The following table shows your column set definition might look like, when you are done: Column Set Name: Department Breakdown Example Column Set Definition Using Segment Overrides
Now you only need to create a new report definition using row set Income Statement and column set Department Breakdown. At this point, you will have two defined reports which produce different versions of the same report. Related Topics Override Segment Assignments Report Building Concepts Simple Reports Report Distribution Other FSG Features Overview of the Financial Statement Generator Using Financial Statement Generator Using the Column Set Builder Amount Types Creating Column Headings Format Masks Relative Headings Defining Report Calculations Row and Column Overrides Defining Row Orders Defining Column Exceptions Display Options Report DistributionAfter you've created report-building objects and defined various reports, you can use FSG's optional report distribution features to control report production and distribution. With these features you can:
Topics in This SectionContent Sets Display Sets and Display Groups Report Sets Scheduling Reports Content SetsBy assigning a content set to a report request, you can generate hundreds of similar reports in a single run. The content set controls how the numerous reports differ from each other. For example, assume your organization has a ledger with 50 departments and that Department is one of your account segments. Also assume that you already have an FSG report for travel expenses, which you run weekly. By using a content set with your existing report definition, you can print a travel expense report for each department, in one report request. You can then distribute the reports to the 50 department managers for review purposes. Content sets are similar to row sets and actually work their magic by overriding the row set definition of an existing report. The subtle report variations discussed in the previous paragraph are achieved by the content set altering the row set account assignments and/or display options. Note: A content set can be saved as part of a report definition, or can be added dynamically at the time you request an FSG report. You cannot use content sets with XBRL output. If you choose a content set function, such as page expand, the process will error. Display Sets and Display GroupsWith display sets and groups you can produce report variations which omit sensitive information or which include information normally not included in a report. To do this, you simply tell FSG which rows or columns should or should not be displayed. Recall from the section on Special Format Reports, that when you define a row or column, you tell FSG whether to display that row or column. This is available because you might want to hide rows or columns which hold intermediate calculations or whose definition will produce sensitive organization data on the report. With a display set you can easily reverse these definitions when you need to print a special report. Note: If you define a column as hidden, you cannot subsequently display it with a display set. For example, suppose you've defined a payroll expense report that includes a row definition for executive salary detail. Under normal distribution conditions, you don't want this information printed on the payroll expense report, so you defined it as a "don't display" row. However, once per quarter you need to give the Senior V.P. of Finance a payroll expense report which does include this detail executive payroll information. To accomplish this, you define a display set and display group which tells FSG to print the executive salary detail row. Every quarter you simply process the Payroll Expense Report, but add the Show Exec Salaries display set to it before you submit the request. Note: A display set can be saved as part of a report definition, or can be added dynamically at the time you request an FSG report. Report SetsYou will probably want to run many reports at the same time, perhaps in a specific sequential order. With FSG you define a report set to accomplish this. The report set definition includes a name and description, the name of each report to include in the set, and a sequence number for each report. Once you've defined a report set, you can run all of the related reports with a single request. Scheduling ReportsGeneral Ledger includes a program named Run Financial Statement Generator which you can use to run your FSG reports. The primary advantage to running FSG reports this way (rather than using the Run Financial Reports window) is that you can schedule reports to run on specific dates and at specific times. You can also specify how often you want the report requests submitted. Once you set up scheduled report runs, the related reports will be processed automatically, without any further work on your part. Related Topics Report Building Concepts Simple Reports Special Format Reports Other FSG Features Overview of the Financial Statement Generator Using Financial Statement Generator Defining Content Sets Defining Display Sets Defining Display Groups Defining Financial Report Sets Running FSG Reports from Standard Request Submission Other FSG FeaturesAd Hoc ReportsWith FSG you can create ad hoc reports to meet special reporting needs where you don't want to create a permanent report definition. For example, you might get a request from your organization's Controller to produce a one-time analysis report of travel-related expenses. When the ad hoc report is complete, you want to delete it. From the Run Financial Reports window, you select the option to Define Ad Hoc Report. You then specify the row set and column set you want to use to build the report. Optionally, you may need to define a new row set or column set first. When defining the ad hoc report, you can also use any of the other available report objects, such as content sets, display sets, and row orders. You run the ad hoc report the same way you run any other FSG report. You can even rerun the report later, as long as you have not yet deleted it. Once you are finished with an ad hoc report, you should delete it using the Delete Ad-Hoc Report program in FSG. Copying Report ObjectsOften, the only thing you need to do to build a new report is copy a row set and column set, make a few minor edits, then define the new report. For this reason, FSG includes a feature called AutoCopy. With AutoCopy, you can copy row and column sets, reports and report sets, row orders, display sets, and content sets. Downloading to SpreadsheetsIf you want to download a report into a spreadsheet program, FSG provides the option to produce your output as a tab-delimited file. Such files are easily imported into a spreadsheet, where you can do additional customizing, analyze the financial information in the report, produce financial graphs, or upload the report information to some other tool. XBRL OutputeXtensible Business Reporting Language (XBRL) is an open specification for software that uses Extensible Markup Language (XML) data tags, together with a taxonomy, to describe business reporting, including financial information. An XBRL taxonomy is a standard description and classification system for the contents of accounting reports. FSG supports XBRL and allows you to produce XBRL instance documents as output. For more information, see: XRBL FSG PerformanceYou can enhance FSG performance by enabling the profile option, FSG: Enable Search Optimization. This profile option improves the performance of FSG reports that retrieve a large number of rows which meet the report definition criteria by optimizing the process of searching for detail child values associated with each parent account value. Reports that benefit have account assignments with the following characteristics:
The degree of performance improvement is relative to the number of child ranges for the parents used in account assignment definitions in the FSG reports. FSG Reports Using BI PublisherYou can generate Financial Statement Generator (FSG) reports with BI Publisher to publish FSG reports with custom layouts. XML stands for eXtensible Markup Language, which is a report format used as input for BI Publisher to create reports with your own custom layout design. For example, you might want to share a financial report with a board of directors, so you might want to add your company logo to the report or highlight information with color. When you choose to generate your FSG report with BI Publisher, you create this type of report formatting using your word processing or spreadsheet application. Note: You cannot use content sets with the Parallel processing type to publish FSG reports with BI Publisher. The Parallel processing type is not supported when using BI Publisher to publish FSG reports. Use a word processing application's formatting features to create report templates that can be used with your FSG reports to take advantage of a fuller scale of formatting options and transform your FSG report into boardroom-quality financial reports. Formatting and layout options include the following:
The use of BI Publisher with FSG also allows FSG reports to support bi-directional languages. Overview of Publishing FSG Reports with BI PublisherTo publish a FSG report, perform the following high-level steps:
Related Topics Report Building Concepts Simple Reports Special Format Reports Report Distribution Overview of the Financial Statement Generator Using Financial Statement Generator Defining Ad Hoc Reports Copying Report Objects Downloading Financial Reports Tips and Techniques for Using FSGUsing Financial Statement GeneratorThe diagram below named FSG Report Building Process, as well as the steps below, describe the FSG report building process. Please note that many of the steps are optional. The Financial Statement Generator Report Building Process
Optional Report Objects
Related Topics Overview of the Financial Statement Generator Suggestions for Specific Financial Reports Tips for Designing FSG Reports Frequently Asked Questions About FSG FSG Tasks FSG Reference Information Suggestions for Specific Financial ReportsYour reporting needs depend on a number of factors, including your type of business, your business size, your organizational structure, and management preferences. Here are some suggestions for financial reports that apply to most organizations. You may want to define these same report formats for your own organization. You may also want to define custom reports which are specific to your organization or the industry in which you operate. Income StatementsIncome statements present the results of operation for an organization for specific periods of time. Income statements report revenues, expenses, net income, and earnings per share. The most common income statement formats are:
The following table displays the row and column set considerations for each of these income statement formats:
Report Definition Considerations for all Income Statements:
Balance SheetsBalance sheets present the financial position of an organization at a specific point in time, usually the end of a period, such as month-end, quarter-end, or year-end. Balance sheets report assets, liabilities, and owners' equity. The most common balance sheet formats are:
The following table displays the row and column set considerations for these balance sheet formats:
Report Definition Considerations for all Balance Sheets:
Statement of Changes in Financial PositionA statement of changes in financial position analyzes changes in an organization's financial position between two specific points in time. Essentially, the statement explains why an organization's balance sheet has changed from one point in time to another. There are two different types of statements of changes:
Either of these statements of changes might be prepared for the current year or for comparative time periods. The following table shows the row and column set considerations for these report formats:
Report Definition Considerations for all Statements of Changes:
Consolidating ReportsConsolidating reports present financial statement information for each company in your consolidated entity in side-by-side columns, together with the consolidated total. A consolidating report can be prepared for virtually any type of financial report, but is most often used for income statements, balance sheets, and statements of changes in financial position. The following table shows the row and column set considerations for consolidating reports:
Report Definition Considerations for all Consolidation Reports:
Operational ReportsOperational reports serve many different reporting needs. Here are some of the more common operational reports:
The following table displays the row and column considerations for these reports: Related Topics Overview of Financial Statement Generator Using Financial Statement Generator Tips for Designing FSG Reports Frequently Asked Questions About FSG Defining Row Sets Defining Column Sets Copying Report Objects Defining Financial Reports Global Consolidation System Defining Consolidation Definitions Overview of Encumbrance Accounting Viewing Funds Available Tips for Designing FSG ReportsYou can define any of the financial reports we just discussed, regardless of your chart of accounts. The tips and techniques listed below will make it easier for you to plan and define your financial reports. The tips will also help you maximize FSG's flexibility and minimize your report maintenance activities. Draft reports on paper first. Before you define a report in FSG, draft it on paper. This will help you plan the report's format and content, saving you time later. Define a logical chart of accounts. You can significantly reduce report maintenance activities if you use account ranges and/or parent segment values in your row sets, column sets, and content sets. For example, say one of your rows is total salary expense and you assigned it an account range of 5500 to 5599. If you add a new salary account segment within that range, the new account is automatically included in your reports. Define generic row sets. You can minimize report maintenance by using generic row sets with the least number of options defined. For example, suppose you need to produce detail expense reports for all of your departments, but they all use different expense accounts. You can use one row set to generate all of these reports. When you define the row set:
Define reusable reports for different ledger sets, ledgers, or reporting currencies. Rather than specifying the ledger segment value for your row set or column set, leave it undefined so that when you run the FSG report, you can specify it at runtime so that the ledger segment value applies for that report generation. Use existing column sets. Before you define a new column set, review FSG's standard column sets and any custom column sets you've already defined to see if there is one that meets your reporting needs. You can use any existing column set as is, or make a copy then revise it. We recommend two generic column sets that are particularly useful in managing any organization. One consists of multiple columns, defined to use actual amount types, for consecutive reporting periods (months, quarters, or years). Reports using this type of column set are very useful for determining and analyzing trends. Another useful column set includes multiple columns defined with actual, budget, and variance amount types. Reports using this type of column set are useful for planning purposes, as well as controlling your business. The standard column sets we provide with FSG include several versions of these two column set types. Use content sets. Content sets are a powerful and useful FSG feature, which you can use to generate hundreds of similar reports in a single report run. For example, you can use a content set to generate 50 departmental reports from one master report definition. Content sets work their magic by overriding the row set definition of an existing report, by altering the account assignments and/or display options. Simplify row set and content set definitions. Rather than defining extremely long row sets, take advantage of the Expand and Both display types:
Use AutoCopy. Copy any existing row set, column set, content set, row order, report, or report set. For example, you can:
Define a report template to publish your FSG report. Publishing your FSG reports with BI Publisher is a powerful feature in controlling the layout and format of your FSG reports. You can create presentation-quality financial reports by defining report templates that have the layout and design you want for your report. BI Publisher applies the design of your template to your FSG report so you have more control over how data is presented. You can define a new report template or you can take an existing report template and modify it to give your report the look you want and save it as a new report template. General Ledger provides you with basic report template to use or modify as a new report template. For additional information on using report templates with XML, see BI Publisher Basic Report Templates. For detailed information on creating report templates, see the Oracle Business Intelligence Publisher Report Designer's Guide. Related Topics Suggestions for Specific Financial Reports Overview of the Financial Statement Generator Using Financial Statement Generator Frequently Asked Questions About FSG Defining Row Sets Defining Column Sets Defining Content Sets Defining Row Orders Defining Display Sets Copying Report Objects Defining Financial Reports Setting General Ledger Profile Options, Oracle General Ledger Reference Guide. Frequently Asked Questions About FSGThis section includes the answers to many of the frequently asked questions about the Financial Statement Generator. Question: Can I display account descriptions on my report in addition to the account segment values? Absolutely. You simply have to define a Row Order, then assign it to your report. In the 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 description. Row Orders need to include all segments. For those segments you do not want displayed, set the width to 0. Note: To print the description without the account segment values, select Description as your segment display method. Question: I've built a report which uses several row and column calculations. However, I'm not getting the results I expected. What might be causing this? There are several reasons why calculations might not yield the results you expect. Here are some areas to explore:
Question: How do I print credit amounts on my report as positive instead of negative numbers? For the 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. Warning: Selecting this option will also make any debit amounts generated by this row or column print as negative values. Therefore, when using this feature, be attentive to the accounts which you assign to the row or column definition. Question: How do I suppress printing of "plus" signs for the numeric values in my report? Change the General Ledger profile option Currency:Positive Format. This option determines how General Ledger and FSG display positive numbers. For example, if your positive format profile option is currently +xxx, FSG will print a positive number with a plus sign in front of it. If you change the profile option to xxx, FSG will print the number without the plus sign. Question: Is there a way to suppress zero amounts on my 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 not checked on the appropriate Rows or Columns windows. Question: How do I review my reports online? Reports can be viewed online from the Concurrent Request Summary window. To view a report, first select it then choose Request Output from the Special menu. Your report will appear in a new window. Note: This feature may not be available in your version of Oracle General Ledger. If it is available in your version, the feature must be enabled by your System Administrator before you can use it to view reports. Question: How do I download my FSG report to a file which I can then open in my PC's spreadsheet? First, make sure your report definition uses the Spreadsheet output option. Optionally, you can specify this option when you run the report. Second, after you run the report, view it online, as described above. While the report is displayed in the view window, select Copy File from the Special menu. You must then enter a path name and filename to store the output file. Once saved, you can open the file in your spreadsheet. Note: This feature may not be available in your version of Oracle General Ledger. Question: I'm having trouble getting a complicated report definition to work correctly. Are there any tools I can use to help find the problem? Yes. You can review the error message log files. If there is not enough detail in the log, you can increase it by changing the user profile option FSG:Message Detail. See: Error Message Log Files. Related Topics Overview of Financial Statement Generator Using Financial Statement Generator Suggestions for Specific Financial Reports Tips for Designing FSG Reports FSG TasksThis section discusses the various tasks you perform to define and generate financial reports with FSG. Tip: If you are not familiar with the Financial Statement Generator, it's report building concepts, and FSG terminology, we suggest you read Overview of the Financial Statement Generator before you begin using the FSG tasks. Defining Row SetsA Row Set defines the format and content of the rows in an FSG report. In FSG, the commonly assumed attribute for a row definition is an account assignment, whereas the attribute for a column definition is a time period (amount type). When you define a row set, you can:
You can define a new row set, or use FSG's AutoCopy feature to copy an existing row set, which you can then modify as needed. To define a row set:
Related Topics Row Set Format Options Row Set Advanced Options Display Options Assigning Accounts Defining Report Calculations Defining Financial Reports Copying Report Objects Balance Control Options Overview of the Financial Statement Generator Securing Row SetsYou can secure your row set definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to row sets:
Assigning AccountsAssign accounts to a row or column to print monetary or statistical account balances. You assign accounts by entering one or more account ranges. Optionally, enter a ledger, ledger set, or reporting currency in the ledger segment of the account assignments. You can also provide the ledger segment value at runtime. Typically you assign accounts to rows. However, if you enter accounts for both rows and columns, FSG only reports on intersecting accounts. Warning: You should only define ledger segment assignments on either the row set or column set. If ledger assignments exist for both, FSG can produce unexpected results. Note: If you assign accounts to a row or column, you cannot define a calculation for that same row or column. You can do one or the other, but not both. To assign accounts to a row or column:
Related Topics Row Set Display Types Row and Column Overrides Defining Row Sets Overview of the Financial Statement Generator Setting General Ledger Profile Options, Oracle General Ledger Reference Guide Defining Report CalculationsYou can define formulas to calculate row or column amounts. For example, you can define a row calculation which sums all of the rows above it in the report. Or, you can define a column calculation which calculates the difference between two previous columns. Note: General Ledger stores credit balances as negative numbers and debit balances as positive numbers, so you should define your calculations accordingly. For example, if you want to calculate a gross margin row, add (rather than subtract) your cost of sales row to your sales row. Use the Absolute Value function to display only positive numbers. You can apply the Absolute Value function to balances or calculation results regardless of the underlying debit or credit balance. Note: You can assign either accounts or calculations to a row or column set, but not both. Calculations and XBRL OutputWhen a column contains a calculation that operates on other columns, the XBRL output will be generated but the calculation results will not be present in the output. For calculated rows with divide operations, ensure the divisor is not zero or determine an alternative for the row. If the divisor is zero for a calculated row with divide operations, the report will be generated but the result of this calculation will not be present in the output. To define a calculation:
Related Topics Entering Formulas with EasyCalc Defining Row Sets Overview of the Financial Statement Generator Defining Column SetsA column set defines the format and content of the columns in an FSG report. In FSG, the commonly assumed attribute for a column definition is a time period (amount type), whereas the attribute for a row definition is an account assignment. Therefore, typical column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals. When you define a column set, you can:
You can define a new column set or use FSG's AutoCopy feature to copy an existing column set, which you can then edit as needed. You can also define column sets graphically, using the Column Set Builder. Column Sets and XBRL ReportsFor XBRL output, columns are used to show the Amount Type, Period, Offset, and Currency. For the Entity (or Company Name) part of the numeric content, enter the name as a Column Description. For XBRL output, calculations must be performed at the row level only. If you choose a column set that contains calculated columns, the report will complete with a warning, A log file identifies the columns that could not be processed. To define a column set:
Securing Column SetsYou can secure your column set definition using definition access sets. Definition access sets are an optional security feature that enables you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to column sets:
Report WidthFSG has no restrictions on report width. You can create a large report and use ADI to download the report to an Excel spreadsheet. FSG uses rules to determine page width and print style depending on the width of your report. Keep these rules in mind as you create column sets which affect the overall width of your reports. Page Width RulesFSG sets the width of your report based on:
If the width of the report is less than or equal to 255 characters, FSG will match your report width to one of the pre-defined categories below.
If the width of the report exceeds 255 characters, the report width will be set to the widest of the above two factors. Print Style RulesIf the width of your report is less than 255 characters, FSG will follow the rules below to determine print style.
Related Topics Balance Control Options Column Set Advanced Options Display Options Defining Report Calculations Assigning Accounts to a Report Defining Column Exceptions Creating Column Headings Standard Column Sets Defining Financial Reports Copying Report Objects Overview of the Financial Statement Generator Overview of Average Balance Processing Using the Column Set BuilderWith the Column Set Builder, you can define a column set by laying it out graphically. You can also modify existing column sets. Column Set Builder is primarily a layout and design tool. It does not include all of the options available from the Columns window. As a result, you cannot assign accounts, calculations, or exceptions within the Column Set Builder. However, you can add these things from the Columns window after you've designed your column set with the Column Set Builder. The number of columns the Column Set Builder can view depends on the character width of each column. You can view a maximum of 20 columns with a limited character width. However, the Column Set Builder can view only one column with a character width of 500. Tip: You can use Applications Desktop Integrator's Report Wizard to edit or build FSG reports in a spreadsheet, displaying unlimited columns. Note: If you define a non-displayed column from the Columns window, it will not be visible in the Column Set Builder. To define a column set using Column Set Builder:
To change a column set layout using the Column Set Builder:
To undo changes to your column set:
Related Topics Column Set Builder Toolbar Defining Column Sets Format Masks Creating Column Headings Defining Column Exceptions Column Set Advanced Options Display Options Relative Headings Assigning Accounts Defining Report Calculations Creating Column HeadingsYou define the column headings for a report within the related column set. You can create custom column headings or modify default headings to meet your specific reporting needs. Your column headings can be static, or you can use relative headings to create dynamic column headings whose content changes depending on the period you specify when you run the report. Note: You can also create and edit column headings with the Column Set Builder. To create column headings:
Related Topics Using the Column Set Builder Defining Column Sets Overview of the Financial Statement Generator Relative Headings Defining Column ExceptionsDefine exceptions for your column if you want to highlight information in your report that requires immediate attention. For example, you can define an exception to "flag" the rows in your report where actual expenditures exceed your budget by $1,000 or more. When you request your report, you can choose to display only the exceptions To define a column exception:
Related Topics Defining Column Sets Using the Column Set Builder Overview of the Financial Statement Generator Defining Content SetsBy assigning a content set to a report request, you can generate hundreds of similar reports in a single run. The content set controls how the numerous reports differ from each other. For example, assume your organization has 50 departments and that Department is one of your account segments. Also assume that you already have an FSG report for travel expenses, which you run weekly. By using a content set with your existing report definition, you can print a travel expense report for each department, in one report request. You can then distribute the reports to the 50 department managers for review purposes. Content sets are similar to row sets and actually work their magic by overriding the row set definition of an existing report. The subtle report variations discussed in the previous paragraph are achieved by the content set altering the row set account assignments and/or display options. Note: A content set can be saved as part of a report definition, or can be added dynamically at the time you request an FSG report. You cannot use content sets with XBRL output. If you choose a content set function, such as page expand, the report will error. To define a content set:
To define a content set that generates multiple reports:
Related Topics Content Set Display Types Row and Column Overrides Copying Report Objects Defining Row Sets Defining Financial Reports Setting General Ledger Profile Options, Oracle General Ledger Reference Guide Overview of the Financial Statement Generator Securing Content SetsYou can secure your content set definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to content sets:
Defining Row OrdersYou can use a row order to control how detail rows appear in your report. You can:
Prerequisites
To create a new row order:
To sort detail rows by amounts displayed in a column (Rank by Column information):
To sort detail rows by ranking, the ledger segment’s ledger short name or ledger name, or by account segment values or segment value descriptions (Account Display information):
To rearrange the sequence of your account segments (Account Display information):
To suppress header descriptions for particular account segments:
Related Topics Row Set Display Types Display Options Defining Content Sets Defining Financial Reports Copying Report Objects Overview of the Financial Statement Generator Securing Row OrdersYou can secure your row order definition using definition access sets. Definition access sets are an optional security feature that enables you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to row orders:
Defining Display SetsWith display sets and groups you can produce report variations which omit sensitive information or which include information normally not included in a report. To do this, you simply tell FSG which rows or columns should or should not be displayed. Prerequisite
To define a display set:
Defining Display GroupsA display group defines a range of rows in a row set or columns in a column set. Display groups are assigned to display sets to control which rows and columns appear on a report. To define a display group:
Related Topics Defining Financial Reports Overview of the Financial Statement Generator Copying Report ObjectsYou can copy existing row sets, column sets, content sets, row orders, display sets, reports, and report sets to create new report objects. You can even copy report objects across multiple ledgers if they share the same account structure. After you copy a report object, you can modify the new object to meet your reporting needs. Note: The definition access set security of the report object is not copied. All new objects will automatically not have definition access set security enabled. You can modify this as needed. When you use FSG Autocopy, the XBRL taxonomy links are copied with the row set. To copy a report object:
Related Topics Defining Row Sets Defining Column Sets Defining Content Sets Defining Row Orders Defining Financial Reports Defining Financial Report Sets Overview of the Financial Statement Generator Defining Financial ReportsA report is defined by specifying the report objects FSG should use to build the report. You can only assign report objects that you have Use privileges to through your definition access sets. The simplest reports are defined by a row set and a standard column set. Optionally, you can specify your own custom column set. Also, you can add a content set, row order, and/or display set to enhance the report or refine the information in the report. You can also specify the budget, encumbrance types, currencies, and constant periods of interest to include on a report. Once you define and save a report, you can use it any time - to run the report, define a report set, or copy and save it as a new report. Note: You can also define ad hoc financial reports, as necessary, to meet one-time reporting needs. You create ad hoc reports from the Run Financial Reports window. Prerequisites
To define a financial report:
Related Topics Running Financial Reports Defining Financial Report Sets Defining Row Sets Defining Column Sets Copying Report Objects Defining Ad Hoc Reports Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in `an FSG Report Defining Content Sets Defining Row Orders Display Groups Defining Display Sets Standard Column Sets Overview of the Financial Statement Generator Securing ReportsYou can secure your report definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to reports:
When you submit reports that have definition access set security enabled and if you have at least use privileges to the report, the definition access set privileges you have for the report take precedence over the privileges you have for the individual report object definitions assigned to the report. Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in an FSG ReportTo include budgets, encumbrance types, currencies, and constant periods of interest in a report, your report definition must specify a row set or column set that has control values specified in the Balance Control options. When you use such row sets or column sets in a report definition, you assign the control values to specific budgets, encumbrances, currencies, or constant periods of interest. When you assign a Budget to a control value number, FSG automatically prints the appropriate budget amounts in the budget-related rows or columns that are assigned that control value number. For example, if you assigned the number 1 to a column with the PTD-Budget amount type and the number 3 to a column with the PTD-Encumbrance amount type, you must assign a budget to the control value number 1 and an encumbrance to the control value number 3. Similar logic applies to encumbrances, currencies, types, and constant periods of interest. Notes:
To assign a budget or encumbrance to a financial report:To assign a budget or encumbrance to a financial report, perform the following steps.
To assign a currency to a financial report:To assign a currency to a financial report, perform the following steps.
To assign a constant period of interest to a financial report:To assign a constant period of interest to a financial report, perform the following steps:
Related Topics Currency Control Value Options Defining Financial Reports Balance Control Options Row Set Advanced Options Column Set Advanced Options Copying Report Objects Overview of the Financial Statement Generator Defining Financial Report SetsUse financial report sets to group FSG reports that you run together frequently. You can only assign predefined reports to a report set. You can only select those reports that do no have definition access set security enabled or that you have use privileges to from your definition access sets. You can copy a financial report set that you have already defined, then modify the new report set as needed. Note: If the Run Financial Statement Generator program is assigned to your responsibility, you can also combine predefined FSG reports with standard reports, listings, and programs in request sets. To define a report set:
Related Topics Defining Financial Reports Copying Report Objects Running Financial Report Sets Running FSG Reports from Standard Request Submission Overview of the Financial Statement Generator Securing Report SetsYou can secure your report set definition using definition access sets. Definition access sets are an optional security feature that allows you to control use, view, and modify access to your General Ledger definitions. The following describes what Use, View, and Modify access mean as it pertains to report sets:
When you submit report sets that have definition access set security enabled and if you have at least use privileges to the report set, it does not matter what definition access set privileges you have to the reports assigned to the report set definition. The definition access set privileges you have for a report set takes precedence over the privileges you have for the individual reports assigned to the report set. Copying Report Objects From Another Database (FSG Transfer Program)Run the FSG Transfer program to copy report objects from one General Ledger database to another. You can copy row sets, column sets, reports, report sets, content sets, row orders, display sets, and display groups. Note: The definition access set security of the report object is not copied. All new objects will automatically not have definition access set security enabled. You can modify this as needed. For example, when you implement General Ledger, you might also define all of your FSG objects in a test database. Once your production database is fully functional, you can easily copy the FSG objects from your test database by using the FSG Transfer program. If you are transferring a Row Set to a database instance of the same code set and that Row Set is linked to an XBRL taxonomy and elements, the Row Set and the linked taxonomy and elements will all be transferred. If the taxonomy has imports (taxonomies linked to the main taxonomy) they will also be transferred. Note: Transferring Row Sets linked to an XBRL taxonomy to a database instance with a different code set is not supported. Prerequisites
To run the FSG Transfer program:
TroubleshootingThe report produced by the FSG Transfer concurrent request identifies any warnings and error messages which occurred when the program ran. Some of the reasons for warnings include:
If you submit an FSG Transfer and receive an error message in the log file indicating that maximum open cursors have been exceeded, review the following possible cause:
If you submit an FSG Transfer and receive an error message indicating there is a buffer overflow, review the following possible causes:
If the FSG Transfer program is interrupted, you can resubmit the program with the same parameters. Note that the program will produce warning messages for any report objects that were successfully transferred during the interrupted run. You can ignore these warnings. Related Topics FSG Transfer Program Parameters Copying Report Objects Running Reports and Programs, Oracle Applications User's Guide FSG Transfer Program ParametersWhen you run the FSG Transfer program, you specify the following parameters:
Related Topics FSG Transfer Program Copying Report Objects Running Reports and Programs, Oracle Applications User's Guide Running Financial ReportsTo generate FSG reports you must request that FSG run them. You can request an individual report, all or part of a report set, or several report sets. If you request an individual report, you can either run a predefined report or request that FSG run an ad hoc report. For ad hoc reports, you select report objects and other report parameters during the report submission process. When you request a predefined report, you can either run the report with the parameters you saved in the report definition, or you can change the parameters at runtime. However, if you change the parameters at runtime, FSG will not save them in the stored report definition. You can also re-use FSG reports and components so that you can run them for different ledgers, ledger sets, or reporting currencies that share the same chart of accounts by specifying the ledger parameter at run time. The ledger value you specify fills in as the ledger parameter should this not be specified in the report definition. You can request reports from the Run Financial Reports window or through standard request submission (Submit Requests window). The advantage of requesting reports through standard request submission is that you can schedule the reports to run automatically. You can also combine FSG reports with standard reports, listings, and programs. The disadvantage is that you cannot run report sets through standard request submission. To publish FSG reports using BI Publisher, you must run the FSG program to generate your FSG report in XML output and then run BI Publisher to apply the layout and formatting of a report template to your FSG report. You can do this from the Run Financial Reports window or from the Submit Requests window. You can also generate the XML output and publish your FSG report’s XML output through the Submit Requests window from a single submission request. After your FSG report has been published the first time, you can republish your FSG report using a different report template to acquire a different look for the same financial report without having to run the FSG program again to create the XML output. For additional information on generating financial reports with BI Publisher, see Running Financial Reports with BI Publisher. Prerequisites
To run an individual report:
To run an ad hoc report:
Running FSG Reports from Standard Request SubmissionTo run a defined FSG report from the Submit Requests window, perform the following steps:
Running Financial Report SetsTo run all or part of a report set, perform the following steps.
To run multiple report sets:
Error Message Log FilesYou can easily control the degree of detail which appears in the error message log file during your report runs. General Ledger divides error messages into three categories: Catalog I: Includes all detail memory figures, detail timings, and SQL statements which are useful for report and program debugging. Catalog II: Includes all file and function names, and all messages which give process information. This is useful for finding out where a process failed. Catalog III: Only includes error messages and other important messages, giving the least amount of information for report and program debugging. You specify the level of detail for your error message log file by setting the user profile option FSG:Message Detail to one of the following values: None: No messages. Minimal: Catalog III messages. Normal: Catalog II and III messages. Full: Catalog I, II, and III messages. Related Topics FSG Report Parameters Defining Financial Reports Defining Ad Hoc Reports Deleting Ad Hoc Reports Setting General Ledger Profile Options, Oracle General Ledger Reference Guide Running Reports and Programs, Oracle Applications User's Guide Overview of Average Balance Processing Running Financial Reports with BI PublisherYou can use BI Publisher to generate FSG reports that open in your word processing application or spreadsheet application. To generate financial reports with BI Publisher, you have several options:
To publish your FSG report in one step:
Note: When you select data in a report created with a drill down template, General Ledger opens the data referenced by that report. To publish your FSG report from the Run Financial Reports window:
To publish your FSG report from the Submit Requests window:
FSG Security RulesIf you have System Administrator responsibility, you can define security rules to control what financial information specific users can print when they run FSG reports. To enable FSG security rules:
Data Access Set SecurityData access sets control which ledgers, balancing segment values, or management segment values can be accessed by responsibilities. Each responsibility is assigned one data access set, which determines what privileges a responsibility allows you to have for a ledger or for parts of a ledger. The FSG report output takes into account data access set security and only shows the data accessible for your responsibility. You must have at least read access to the data to view it on the report. To enable data access set security:To enable data access set security, perform the following steps.
Definition Access Set SecurityDefinition access set security enables you to secure FSG report or report object definitions so that users are allowed to use, view, or modify FSG definitions through definition access sets assigned to them. You can directly apply definition access set security to the following FSG objects:
To enable definition access set security:To enable definition access set security, perform the following steps.
Related Topics Definition Access Sets, Oracle General Ledger Implementation Guide Defining Security Rules, Oracle Applications Flexfields Guide Assigning Security Rules, Oracle Applications Flexfields Guide Overview of Flexfield Value Security, Oracle Applications Flexfields Guide Setting General Ledger Profile Options, Oracle General Ledger Reference Guide FSG Report Parameters Defining Financial Reports Defining Ad Hoc Reports Deleting Ad Hoc Reports Running Reports and Programs, Oracle Applications User's Guide Overview of Average Balance Processing Creating a Report Template Using Report ManagerOracle Report Manager is an online report distribution system that provides a secure and centralized location to produce and manage reports.You can use Report Manager to create a report template from an FSG report definition. After you generate the report you can drill into detail pages to perform account analysis. Prerequisites: Before you create a report template using Report Manager, you must create a report in FSG. See Defining Financial Reports. To create a report template using Report Manager:
Reporting AttributesSetting Up Reporting AttributesNote: The following section is applicable to customers who wish to extend their Financial Statement Generator reporting capability to include the use of additional attributes associated with the individual segment values in their Accounting Flexfield. These attributes can be used to provide the additional data on a line in a report, as well as in sorting and subtotaling an FSG report. Reporting attributes are typically used by public sector customers to meet various management and regulatory reporting requirements. This feature is currently only available in public sector installations. Set up reporting attributes in General Ledger to capture additional descriptive information with accounting flexfield segments and to report on this information using the Financial Statement Generator. For example, you might want to associate Fund Manager names with Fund values and design reports that print Fund Manager names alongside Fund segment values. You can create reporting attributes two ways, depending on how you validate the value set of the key accounting flexfield segment in question. If the validation type of the value set of your key Accounting Flexfield is Independent, you must define one or more context-sensitive descriptive flexfield segments to capture the additional information in the Segment Values window. For example, you might define two descriptive flexfield segments to capture Fund Manager and Fund Sponsor for the Fund segment, and two more segments to capture Project Manager and Grant Number for the Project segment. If the validation type of the value set of your key Accounting Flexfield segment is Table, you must define the reporting attributes as additional columns in the key accounting flexfield segment table. Reporting attribute values are values in the table. Do not add new attributes after the initial setup. Doing so invalidates all existing Financial Statement Generator definitions. The setup steps below outline the procedure to create reporting attributes when the validation type of value set of your key accounting flexfield is Independent. The steps include how to create a context-sensitive descriptive flexfield for the Segment Values window and how to specify descriptive flexfield segments as reporting attributes. Each general step is detailed in a step-by-step procedure. In using value sets, reporting attribute descriptive flexfields have the same restrictions as do accounting flexfields. Prerequisites
To set up reporting attributes:
Related Topics Value Set Windows, Oracle Applications Flexfields Guide Segment Values Window, Oracle Applications Flexfields Guide Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide Key Flexfields Segment Window, Oracle Applications Flexfields Guide Reporting Attributes Examples Running Reports and Programs, Oracle Applications User's Guide Defining Reporting Attribute Value Sets and ValuesBefore you can define a reporting attribute descriptive flexfield segment, you must define a value set and its values. Each reporting attribute name must be distinct and never repeated. For example, you might define a value set called FUND_MANAGER_VS to capture all possible Fund Manager values or names. To define a value set for reporting attributes:
To define values for a reporting attributes value set:
Related Topics Value Set Window, Oracle Applications Flexfields Guide Defining Segment Values, Oracle Applications Flexfields Guide Setting Up Reporting Attributes Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes Defining Context-Sensitive Descriptive Flexfields for Reporting AttributesBefore you can enter reporting attribute values when you enter accounting flexfield segment values, you must define a context-sensitive descriptive flexfield. This flexfield captures the reporting attribute values in the Segment Values window. For example, to enter Fund Manager values when you enter Fund segment values, you must define a context sensitive descriptive flexfield to capture the Fund Manager values in the Segment Values window. The context for the new descriptive flexfield is the Segment Values window, and the context values are the accounting flexfield segment value set names with which reporting attributes will be associated. To associate reporting attributes with the Fund segment of your accounting flexfield, you must define a descriptive flexfield segment whose context value is the name of the Fund segment value set. Thus if the fund segment value set is called FUND_VS and you define a context-sensitive descriptive flex segment to capture Fund Manager, whenever you enter values for FUND_VS in the Segment Values window, you can also enter values for Fund Manager. To define a context-sensitive descriptive flexfield for an accounting flexfield segment:
Related Topics Descriptive Flexfield Segments Window, Oracle Applications Flexfields Guide Defining Reporting Attribute Value Sets and Values Assigning Reporting Attribute Values to Account Segment Values Specifying Descriptive Flexfield Segments to Use as Reporting Attributes Assigning Reporting Attribute Values to Account Segment ValuesHaving defined a context-sensitive descriptive flexfield for the Segment Values window, you can now assign reporting attribute values to account segment values. For example, you might enter Joe Smith as the Fund Manager for Fund 12345. To assign reporting attribute values to account segment values:
Related Topics Segment Values Window, Oracle Applications Flexfields Guide Defining Reporting Attribute Value Sets and Values Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes Specifying Descriptive Flexfield Segments to Use as Reporting Attributes Specifying Descriptive Flexfield Segments to Use as Reporting AttributesOnce you associate reporting attribute descriptive flexfield segments with accounting flexfield segments, you must select the segments that will be reporting attributes in your key accounting flexfield. For example, you might have associated a Fund Manager and a Fund Type descriptive flexfield segment with the Fund segment, but you want to use only Fund Manager as a reporting attribute. When you select a segment to be a reporting attribute, you can disable it later. If you do so, you must run the Reporting Attributes Preparation program. To enable descriptive flexfield segments as reporting attributes:
Related Topics Key Flexfields Segment Window, Oracle Applications Flexfields Guide Defining Reporting Attribute Value Sets and Values Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes Assigning Reporting Attribute Values to Account Segment Values Running the Reporting Attribute Preparation ProgramRun the Reporting Attribute Preparation program whenever you add an account segment or segment attribute or when you disable a segment or segment attribute. When you run the preparation program, the Financial Statement Generator recognizes the new attributes as segments. Running the Reporting Attribute Preparation program creates the Reporting Attributes:Accounting key flexfield (GLAT). We recommend that you do not try to modify this structure manually. Prerequisites
To run the reporting Attribute Preparation Program:
Related Topics Setting Up Reporting Attributes Running Reports and Programs, Oracle Applications User's Guide Specifying Descriptive Flexfield Segments to Use as Reporting Attributes Reporting Attributes Examples Running the Reporting Attribute Historical ProgramThis program automatically updates account segment values and reporting attribute values when you modify a reporting attribute. You can run this program for one segment and attribute value or you can run it for all segment and attribute values. Prerequisites
To run the reporting Attribute Historical Program:
Related Topics Setting Up Reporting Attributes Submitting a Request, Oracle Applications User's Guide Reporting Attributes Examples Reporting Attributes ExamplesThis section describes examples for setting up and using reporting attributes. You set up your Accounting Flexfield as follows: FUND-DEPARTMENT-ACCOUNT-PROJECT You then define your reporting attributes and associate them with your Accounting Flexfield segments as shown in the table below.
You associate the attribute values with each segment value in your chart of accounts. The table below shows how you might associate Fund segment values with Fund Type and Fund Source values.
The table below shows how you might associate Dept values with Division and Manager values.
The table below shows how you might associate Account values with Funding and Activity values.
The table below shows how you might associate Project values with Sponsor, Research Type and Overhead values.
You use your reporting attributes just as you use your Accounting Flexfield segments to create custom reports with the Financial Statement Generator. ExampleYour controller needs a funds available report on all revenue funded accounts listing budget, encumbrance and actual balances. Using the Financial Statement Generator, you define the content set for your report using your reporting attribute Fund Source and your reporting attribute value Revenue. Funds Available Report Example For a text description of this figure, see Text Description of the Funds Available Report Example, Oracle General Ledger Reference Guide. Example The Department of Energy (DOE) requires a monthly report of all projects related to Nuclear or Applied Research with their status by project. You want to report on original funding, expended to date, and available funding. When defining your content set, you select the reporting attribute of Sponsor and the reporting attribute value of DOE. When defining your column sets, you select the Accounting Flexfield segment of Project, and the reporting attribute of Research type. Monthly Project Status Report Example For a text description of this figure, see Text Description of the Project Status Report Example, Oracle General Ledger Reference Guide. Related Topics Setting Up Reporting Attributes Defining Reporting Attributes Value Sets and Values Defining Context-Sensitive Descriptive Flexfields for Reporting Attributes Assigning Reporting Attribute Values to Account Segment Values Specifying Descriptive Flexfield Segments to Use as Reporting Attributes Running the Reporting Attribute Preparation Program Running the Reporting Attribute Historical Program Defining Ad Hoc ReportsYou can define ad hoc financial reports as necessary to meet special reporting needs. An ad hoc report is one you define at the time you run financial reports. You do not assign a name to an ad hoc report. Instead, General Ledger automatically names ad hoc reports as follows: FSG-AD HOC-<Sequence Generated Number>. Tip: We recommend that you delete ad hoc reports periodically to improve system performance. Prerequisite
To define and run an ad hoc financial report:
Related Topics Running Financial Reports Deleting Ad Hoc Reports Defining Financial Reports Running FSG Reports from Standard Request Submission Deleting Ad Hoc ReportsAd hoc reports are not deleted automatically. Therefore, it is a good idea to periodically do so manually. When you run the Delete Ad Hoc Reports program, you instruct FSG to delete any ad hoc reports which haven't been run in a specified number of days. If you run this program as the System Administrator, FSG deletes all specified ad hoc reports, regardless of who last requested the reports. If you run this program from a user responsibility, FSG deletes only those specified ad hoc reports that were created under your responsibility. To delete ad hoc reports:
Related Topics Defining Ad Hoc Reports Running Reports and Programs, Oracle Applications User's Guide Defining Financial Reports Downloading Financial ReportsYou can download your Financial Statement Generator reports into a spreadsheet on your personal computer. When you define the report, or when you run the report, choose Spreadsheet as the output option. FSG produces the report in a tab-delimited format, which facilitates formatting when you load the report information into a spreadsheet. Note: This feature may not be available in your version of the Financial Statement Generator. Prerequisite
To download financial reports:
FSG Reference InformationThis section contains information you will want to refer to throughout the process of building FSG reports and report objects. The following reference information is included: Row Set Format Options Downloading Financial Reports Row Set Display Types Content Set Display Types Standard Column Sets Amount Types Column Set Builder Toolbar Format Masks Balance Control Options Row Set Advanced Options Column Set Advanced Options Display Options Relative Headings Row and Column Overrides FSG Report Parameters Row Set Format OptionsWith row set format options, you can set basic formatting for your report rows, including indentation, line spacing, underline characters and page breaks. Indent: Every report line generated by the row definition will be indented this number of spaces from the left margin of your report. Lines to Skip: Number of blank lines that FSG will place on your report Before and After the row. Note: This applies to the entire row, not to the individual lines which are generated by the row definition. Note: This option is not supported for published FSG reports. Underline Character: You can specify an underline character to print on your report Before and After the row. For example, if your row definition is a calculation that sums all of the rows above it, you can specify that FSG print an underline of single dashes above the total and an underline of double dashes below the total, as follows: ------------ Total $ 3,254,000 ============Page Break: Check the Before or After checkboxes to indicate whether FSG should insert a page break before and/or after printing the row. Note: This option is not supported for published FSG reports. Row Set Display TypesYou can assign one of three display types to your account segments in an account assignment. You can override these display types with a content set. E: (Expand) Expand the range and display all segment values, creating multiple rows from a single row definition. If you enter a parent segment value for your range, FSG displays all child values for that parent. Do not select summary reporting to display all the child values in your report. Note: Use the profile option FSG:Expand Parent Value to control the expansion of parent segment values when requesting summary balances. If you choose Expand for the ledger segment and the ledger segment value is a ledger set, the FSG report displays individual rows for the ledgers of the ledger set and shows the ledger short name. The ledgers are listed in order of their ledger short name. If the ledger segment value is a ledger, then the FSG report displays data for the ledger. T: (Total) Total the range and display only a total balance for the segment values, limiting the number of rows that appear on your report. If you enter a parent segment value for your range, FSG totals all of the child values for that parent. If you choose Total for the ledger segment and the ledger segment value is a ledger set, the FSG report totals the ledgers in the ledger set and displays rows for the totals without displaying the individual ledgers. Note: If you assign accounts to a column, you must use a display type of T (Total) for each segment. You must also specify a display type of T for all segments if you assign multiple account ranges to a row. Do not enter multiple account ranges for a row containing display types other than T. B: (Both) Expand and total the range and display all segment values and a total balance for the segment values. This option lets you display both detail rows and total rows. If you enter a parent segment value for your range, FSG totals all of the child values for that parent. Do not select summary reporting to display all the child values in your report. If you choose Both for the ledger segment and the ledger segment is a ledger set or ledger, the FSG report displays both the expanded detail and total rows for the ledger set or ledger. Note: For XBRL output, choose Total only. If you choose Expand or Both while linking XBRL elements to the rows and then generate XBRL output, the process will ignore the E or B and process those rows as if they were T. The log file will contain a warning listing the rows that were processed as T instead of E or B. Related Topics Display Types Setting General Ledger Profile Options, Oracle General Ledger Reference Guide Content Set Display TypesUse the following content set display types to override row display types: N: (No override) Use the display option from the row set definition. RE: (Row/Expand) Expand the range and display all segment values, creating multiple rows from a single row definition. If the ledger segment value is a ledger set, this display type expands the ledger set and displays all ledgers, creating multiple rows from a single row definition. RT: (Row/Total) Total the range and display only the total balance for the segment values. For example, assume you've defined a report to print project expenses, and that Project is one of your account segments. Your report definition uses a row set containing a single row definition with account assignments for all related project expense accounts. To review expenses for all projects for each department, use the Row/Expand option for the department segment and the Row/Total option for the project segment. If the ledger segment value is a ledger set, this display type totals the ledger set and displays only the total balance for the ledger set. RB: (Row/Both) Expand and total the range, displaying each segment value and the total balance for the segment values. Using the same example above (under RT), if you want to produce a report showing individual project revenues with a subtotal of all project revenues for each department, use the Row/Expand option for department and the Row/Both option for project. If the ledger segment value is a ledger set, this display type expands the total ledger set, displaying each ledger and the total balance for the ledger set. CT: (Column/Total) Total the range and display only a total balance for the segment values. If the ledger segment value is a ledger set, this display type totals the ledger set and displays only the total balance for the ledger set. This result is the same as the RT display type. PE: (Page/Expand) Expand the range and create a separate report for each segment value in the range. You can only use this option for one segment in your account, including the ledger segment, and you must enter a range of values for that segment. If you assign this option to a parent account segment value, FSG will generate a separate report for each child account value. FSG will also generate a separate report for the parent if you include a parent segment value in the child range. If the ledger segment value is for a ledger set, this display type expands the ledger set and creates a separate report for each ledger in the set. PT: (Page/Total) Override the row set ledger or account segment value range but retain the row set Expand, Total, or Both display type for each segment. This differs from content display type N since N ignores any new range values you specify for your content set. Standard Column SetsYou can use the following predefined standard column sets. You can also modify these column sets to meet your reporting needs. Tip: We suggest that you do not modify standard column sets directly, since other reports may depend on the standard definitions. Instead, use AutoCopy to make a copy of the standard column set whose definition you want to change. Then, modify the copy as needed before using it in your report definition. PTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current period only. QTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current quarter only. PTD, QTD, YTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current period, quarter-to-date, and year-to-date. Amounts are in thousands. PTD, QTD, YTD ACTUAL: Includes actual current period, quarter-to-date, and year-to-date. MONTHLY ACTUAL: Includes monthly actuals for each month of the fiscal year plus a year-to-date total. Amounts are in thousands. MONTHLY BUDGET: Includes monthly budget amounts for each month of the fiscal year plus a year-to-date total. Amounts are in thousands. QUARTERLY ACTUAL: Includes quarterly actuals for each quarter of the fiscal year plus a year-to-date total. QUARTERLY BUDGET : Includes quarterly budget amounts for each quarter of the fiscal year plus a year-to-date total. ROLLING MONTHLY: Includes actual amounts for the current month and the preceding 11 months. Amounts are in thousands. ROLLING QUARTERLY: Includes actual amounts for the current quarter and the preceding 4 quarters. Amounts are in thousands. MONTHLY COMPARATIVE YTD: Includes current year-to-date and prior period year-to-date. QUARTERLY COMPARATIVE YTD: Includes year-to-date balance for the current quarter and the previous three quarters. ANNUAL COMPARATIVE QTD, YTD : Includes actual amounts for the current quarter, prior year same quarter, variance, and variance percentage. Also includes actual amounts for current year-to-date, prior year-to-date, variance, and variance percentage. FUNDS AVAILABLE: Includes year-to-date funds available based on posted actuals, budgets, and encumbrances. Also includes total budget for year and the percentage of total budget remaining. You can use this column set to show your obligations for encumbrance reports. Related Topics Copying Report Objects Amount TypesGeneral Ledger provides the following amount types, which can be specified in the Balance Control region of a FSG row or column definition: BAL-Actual (FY Start): Balance sheet balance at start of fiscal year EOD: End-of-day balances PATD: Period Average-to-date balances PTD-Actual: Period-to-date actual balances PTD-Budget: Period-to-date budget balances PTD-Encumbrance: Period-to-date encumbrance balances PTD-Variance: Period-to-date variance (budget - actual) PTD-Variance%: Period-to-date variance percentage (variance/budget) Project-Actual: Project-to-date actual balances Project-Budget: Project-to-date budget balances Project-Encumbrance: Project-to-date encumbrance balances Project-Variance: Project-to-date variance (budget - actual) Project-Variance%: Project-to-date variance percentage (variance/budget) QATD: Quarter Average-to-date balances QTD-Actual: Quarter-to-date actual balances QTD-Budget: Quarter-to-date budget balances QTD-Encumbrance: Quarter-to-date encumbrance balances QTD-Variance: Quarter-to-date variance (budget - actual) QTD-Variance%: Quarter-to-date variance percentage (variance/budget) YATD: Year Average-to-date balances YTD-Actual: Year-to-date actual balances YTD-Actual (FY End): Fiscal Year-end actual balances YTD-Budget: Year-to-date budget balances YTD-Budget (FY End): Budget for full fiscal year. You should first budget to all periods in your fiscal year, including an adjustment period if you have defined one. YTD-Encumbrance: Year-to-date encumbrance balances YTD-Encumbrance (FY End): Encumbrance balances for full fiscal year. YTD-Variance: Year-to-date variance (budget - actual) YTD-Variance%: Year-to-date variance percentage (variance/budget) Column Set Builder ToolbarThe Column Set Builder toolbar provides pushbutton shortcuts for various layout commands, as follows: Pushbutton Shortcuts for Layout Commands Related Topics Using the Column Set Builder Format MasksFormat masks, which are specified in your row and column definitions, define how FSG prints numerical values on your reports. With a format mask, you can control:
Format Mask Control CharactersA format mask is comprised of control characters representing the various formatting features you can control. These control characters are: Number Indicator: This is always the numeric digit "9". For each 9 which appears in the format mask, FSG will print one number of a value. For example, a format mask of 9999 will print four numbers. Decimal Symbol: The actual symbol used for the decimal point is controlled by Oracle Applications. If you want to use a different symbol in FSG and Forms, contact your system administrator. Currency Symbol: You can specify whatever symbol you need for currency values. For example, to display U.S. dollars, you can specify a dollar sign. To display British pounds, you can specify a pound sign. Other Characters: You can include any other leading and/or trailing characters in a format mask. For example, you could have each number print with the phrase "(estimated)" immediately following it. Thousands Separator Symbol: There are two elements that influence the thousands separator symbol:
Example Format MasksThe table below shows how the number 4234941 would be displayed using different format masks: Example Format Masks
Column WidthSince format masks affect how FSG displays values on your reports, you must take your format masks into consideration when determining the widths of the columns in your column sets. If you define both a row and column format mask, FSG uses the smaller of the column format width or position width for printing report values. The row format width is ignored.
Printing RulesIf the column width is too small to accommodate a formatted amount (including any leading and trailing characters), FSG will try to alter the formatting so the value can be printed on your report. FSG follows these printing rules, in order, when trying to alter the amount format:
Currency FormatsCurrency formats override any formatting options you specify in your row and/or column sets, except for precision, leading characters, and trailing characters. You specify a currency format by setting:
Accordingly, when you create format masks and determine column positions for your FSG reports, you should consider how you defined your currency formats. Related Topics Setting General Ledger Profile Options, Oracle General Ledger Reference Guide Balance Control OptionsAmount Type: Defines the types of values to include in a row or column. General Ledger provides numerous amount types, such as actual, end-of-day, average-to-date, budget, or encumbrance; or calculated amounts, such as variances, for single or multiple periods. The amount type is typically assigned to column definitions. Note: If you enter a budget, encumbrance, or variance amount type, you should enter a Control Value to assign budgets and encumbrance types to the report definition. Amount Type, Period Offset, Control Value, and Currency must all share the same column or row. If you assign an amount type to a row or column, you must also assign an offset. Tip: Use the amount type, YTD-Actual (FY End) to report on fiscal year-end actual balances. Calculate the offset in relation to your accounting calendar and enter the offset value in the Balance Control Region (for example, -12 for a 12 period calendar). Label the column directly (for example, June-1999) instead of using the Period of Interest (&POI) token. Re-use this column set definition indefinitely. Update the column label when your fiscal year changes. You can also use the constant period of interest control value feature to report on a fixed reporting period for each accounting year and use the Constant Period of Interest (&CPOI) token to automatically label the column. Currency: To report total account balances for a ledger currency, enter the balance control currency. You can also choose STAT as a balance control currency. If you want to report on converted, entered, total, or the statistical currency amounts, enter a control value number. When you define your report, assign the currency type, entered currency, and ledger currency to that control value number. The currency you enter when you define or request a report serves as the default currency for columns without a currency in the column set definition. If you use reporting currencies, you can select the currency of your reporting currency for this field. Tip: For column sets, if you assign a different currency to each of your columns, put the currency code in each column heading so you can correctly identify the currencies on your report. Control Value: Used to include budgets, encumbrance types, currencies, and constant periods of interest in a report. Offset: Enter the relative Offset if you want to report on a period or effective date before or after your runtime period or effective date. If your specified Amount Type refers to a period, such as PTD-Actual, then the Offset will be in number of periods. However, if your specified Amount Type refers to days, such as PATD, then the Offset will be in number of days. FSG determines the amounts to display based on the offset and the period or effective date you enter at runtime. For example, enter 0 (zero) to display amounts for the runtime effective date or enter -1 to display amounts one day before the runtime effective date. Note: You must specify offsets at the same level (row or column) at which you specified amount types and control value numbers. Related Topics Amount Types Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in an FSG Report Overview of Average Balance Processing Currency Control Value OptionsThe following are currency control value options: Control Value: The control value reference number. Currency Type: The type of currency balance to report on, including Converted, Entered, Statistical, or Total. Entered Currency: The applicable entered currency for the Converted or Entered currency types. For the Statistical currency type, the statistical currency is defaulted. For the Total currency type, this field is disabled. Ledger Currency: The ledger currency for the Converted, Entered, and Statistical currency types. If it is not entered for these types, it will be defaulted from the Currency parameter specified on the report or entered at run time. This field is required for the Total currency type. If you use reporting currencies ), you can select the currency of your reporting currency for this field. The following table describes how currency account balances are retrieved from the currency control value information. Retrieval of Currency Account Balances from Currency Control Value Information
Deriving the Currency ParameterThe currency parameter of a FSG report is derived from the currency information provided in the report definition as well as the currency information from report runtime currency parameters. The following lists the order of precedence of the currency information provided for your FSG report:
The currency specification for the following play a role, along with the ledger/ledger set specified for the report, in establishing from which ledger or reporting currency (balances, journal or subledger) the report retrieves the balances:
Row Set Advanced OptionsYou can assign advanced options to a row. Note that the balance control options are typically defined in column sets. Row Name: Use this name to reference this row when defining calculations or using other forms. This name does not appear on any reports. Note: If you plan to use row names in calculations, make sure the row names are unique within the row set. Percent of Row: Enter a value for a percentage column. This value is the sequence number of the row you want to use as the percentage denominator. For example, if you want to define the report below, enter the sequence number of the total sales row (40) in the Percent of Row field for every row. Then in your column set, define a calculation column which calculates percent on the sales column, using the operator % and the column sequence 10.
XBRL Element: If applicable, choose an XBRL Element for the row. Rows without an assigned XBRL element are not present in XBRL output. Override Column Calculations: Select this option if you want your row calculation to take precedence over any conflicting column calculations. For example, you may define a column that is the sum of the other columns in your column set and a row set that has a gross margin percentage row. However, since the gross margin percentage in the total column is not the sum of the percentages in each column, you should override the column calculation. Related Topics Column Set Advanced Options Defining Row Sets Defining Report Calculations Including Budgets, Encumbrances, Currencies, and Constant Periods of Interest in an FSG Report Column Set Advanced OptionsColumn Name: Use this name to reference this column when defining calculations or using other forms. This name does not appear on any reports. Note: If you plan to use column names in calculations, make sure the column names are unique within the column set. Description: Column descriptions appear in other FSG windows, making it easier to remember what the column represents. Percent of Column: The sequence number of the column you want to use as the denominator for a percentage column. Override Value: If you assigned an override segment to your column set, you enter the segment value here. For example, if you entered Department as your override segment, enter a segment value to select the specific department you want displayed in this column of your report. See: Override Segments. Tip: If you report consolidated financial results, we recommend that you define a consolidating column set. By entering Company as your override segment, you can produce a column set with a column for each company, a column for eliminating entries, and a consolidated total. Override Row Calculations: Select this option if you want your column calculation to take precedence over any conflicting row calculations. Related Topics Row Set Advanced Options Defining Column Sets Defining Report Calculations Override Segment AssignmentsUse the override segments in the Column Set, Define Financial Report, and Run Financial Report windows to override account assignments on a segment basis. The Column Set form provides a single segment level override where you choose the segment value to override with for each column. All segments are available with the exception of the Ledger segment. If any of the account segments is selected as the override segment and the override value is not defined for certain columns, then the undefined value, signifying all values, is substituted as the segment value for the override segment. Important: You must specify an override value for each column in a column set with a segment override to produce a meaningful report. In the Define Financial Report and Run Financial Report windows, you can override multiple segment values simultaneously by providing an override value for each and every segment. However, it is suggested that for any given report, that you limit your segment override specification to any one of these three dimensions--Column Set, Report Definition or at report runtime--to better manage the outcome of the generated report. Should segment overrides be specified simultaneously for any combination of the Column Set, Report Definition and at report runtime, and the override segments are the same segments, the following lists the order of precedence of the override value that will be applied to your FSG report:
If the override segments are exclusively assigned to each of these three dimensions, the override values for each segment will be applied together to the report. The Content Set feature also provides another mechanism of applying overrides to the report’s account assignments and display options. The same suggestion applies to Content Sets to exclusively employ only one overriding mechanism in your report to better manage the outcome of the generated report. Display OptionsUse display options to specify how you want to display rows and columns. Since display options can affect how a number is going to appear on your report, make sure you allow enough printing positions when you define your columns. Format Mask: Enter a format mask for displaying row values, if you want to override the column level format mask. Factor: The factor (Billions, Millions, Thousands, Units, or Percentiles) determines how to display numeric values. The row set factor overrides the column level factor. Level of Detail: You assign level of detail for individual rows and columns, as well as for a report. When you run the report, FSG prints only those rows and columns whose level of detail matches that specified for the report. There are three options that control the level of detail FSG prints on your report: Financial Analyst:Includes all levels of detail. Supervisor: Includes only rows and columns defined for Supervisor or Controller level of detail. Controller: Includes only rows and columns defined for the Controller level of detail. Note: If you do not enter a level of detail for a row or column, the system will assume the level of detail is Financial Analyst. Display Row or Display Column: If a column is defined but not displayed, FSG still prints your column heading description and does not reposition other columns or their headings on your report. However, that column will not be visible in the Column Set Builder. For rows that are defined but not displayed, FSG hides the rows and repositions all other rows. Display Zero: Use to print the row or column when it has a zero balance. If you do not choose this option, the row or column is suppressed on reports when it has a zero balance. Change Sign: Use to change the sign on balances for display purposes only. General Ledger stores credits as negative amounts and debits as positive amounts. Therefore, change the sign for rows or columns with credit balances to print the credit balances as positive numbers. This option is typically defined for rows. Change Sign on Variance: Use to change the sign on balances with a variance amount type for display purposes only. Note that variance is calculated as budget minus actual. This option typically applies to rows. Relative HeadingsYou use relative headings to create dynamic column headings whose content changes depending on the period you specify when you run the report. You define relative headings by combining:
Here are the relative headings you can use in a report: &POI: Enter &POI (period of interest), followed by a number from -999 to +999 that refers to the relative period offset of your column. For example, enter &POI0 to display amounts for the period you specify at runtime, enter &POI-1to display amounts one period before the period you specify at runtime, and so on. Generally, the relative period offset you use to define a &POI heading corresponds to the period offset of the column. &CPOI: Enter &CPOI (constant period of interest), followed by a number that refers to a constant period of interest control value representing a period number and relative year for that column. For example, enter &CPOI2 to refer to the constant period of interest as defined in control value number 2 to label the column with the name of the constant period selected. &DOI: Enter &DOI (day of interest), followed by a number from -999 to +999 that refers to the relative offset of your column. For example, enter &DOI0 to display amounts for the effective date you specify at runtime, enter &DOI-1to display amounts one day before the effective date you specify at runtime, and so on. Generally, the relative offset you use to define a &DOI heading corresponds to the offset of the column. &CDOI: For average amount types, enter &CDOI (constant day of interest), followed by a number that refers to a constant period of interest control value representing a period number and relative year for that column. It returns the last date of the period, as opposed to just the period name. Since average amount types in the constant period context references the period, quarter, or year average at the last day of the selected constant period, this token gives users more flexibility and provides clearer labels. &BUDGET: Enter &BUDGET followed by a budget control value number to print the budget name assigned to the control value number when you define your report. &ENCUMBRANCE: Enter &ENCUMBRANCE followed by an encumbrance control value number to print the encumbrance type assigned to the control value number when you define your report. &CURRENCY: Enter &CURRENCY followed by a currency control value number to print the currency assigned to the control value number when you define your report. If you define multiple relative column headings and enter text for a particular column set, and there is insufficient space to print all the values, FSG applies the following rules:
Row and Column OverridesIf you enter different values for the same option in both your row set and column set, there is a conflict. Use the following table to determine which report object takes precedence, or to determine the behavior of the objects when a conflict exists: Row Set vs. Column Set Override Summary
FSG Report ParametersReport: Select your report. Ledger: Enter a ledger, ledger set, or reporting currency. This parameter fills in when the ledger segment is undefined in the report. Period: Enter the accounting period for which you want to run your report. FSG prints the accounting period name at the top of your report with your ledger or reporting currency name and report title. If you don't specify a period, FSG will print a report for the latest open period for your ledger or reporting currency. Note: The period you specify has a direct effect on any relative headings and period offsets which are defined as part of your report. For example, assume your report has two columns - one defined as &POI0 and one defined as &POI-6. If you enter DEC-96 as the Period, your report will include one column of values for December 1996 and one column of values for June 1996. Currency: Enter the currency to use for the report. If you do not enter a currency, FSG uses the currency you assigned when you defined the report. If you did not assign a currency when you defined your report, FSG uses the ledger currency of the ledger selected at report runtime. If you use reporting currencies (journal or subledger level) and if you did not assign a currency when you defined your report, FSG uses the currency of the reporting currency selected at report runtime. Rounding Option: Choose the rounding option you want FSG to use for calculations in your report. FSG defaults in the rounding option you specified in the report definition. Segment Override: Enter values for the account segments you want to override. When you enter an override segment value, FSG produces a report for the specific ledger, company, cost center, product or other value associated with that segment. FSG defaults in the one specified in the report definition, if any. Content Set: Choose the content set for your report. Leave this entry blank if you want to use the content set stored with the report definition or if you don't want to use a content set. Row Order: Choose a row order for your report. Leave this entry blank if you want to use the row order stored with the report definition or if you don't want to use a row order. Display Set: Choose a display set for your report. Leave this entry blank if you want to use the display set stored with the report definition or if you don't want to use a display set. Output Option: Choose your report output. Text:Produces a report in standard format for printing or viewing online. Tab-Delimited: Produces a report whose columns are delimited by tabs, making it easier to import the report into a spreadsheet. Spreadsheet: Produces a report designed specifically for Microsoft Excel and can be used with Applications Desktop Integrator. XBRL: Generates XBRL output and creates an XRBL instance document. At least one XBRL Taxonomy must be loaded in the system for this option to appear. Exceptions: Enter Yes if you want your report to display only the rows that meet the exceptions you defined in your column set. If you enter No or leave this field blank, FSG displays a complete report with your exception rows flagged. XML: Generates an XML output file used as input to BI Publisher so the report formatting of a report template is applied to the FSG report. Level of Detail: Enter the display detail level you want in the report. If you enter a level of detail, only those rows and columns with that level of detail and higher appear on the report. Note: The level of detail option only appears if you request your report by using the program named Program - Run Financial Statement Generator. Date: Enter the effective date for your report. Related Topics Running Financial Reports Running FSG Reports from Standard Request Submission XBRLImportant: The Financial Statement Generator's support for XBRL is based on version 2.0a of the XBRL specification. This has been superseded by version 2.1. If you intend to submit XBRL reports to any external regulatory bodies or other audiences, please be sure to confirm the appropriate version of the specification. If you need 2.1, please contact your Oracle sales representative to discuss alternatives. eXtensible Business Reporting Language (XBRL) is an open specification for software that uses Extensible Markup Language (XML) data tags, together with a taxonomy, to describe business reporting, including financial information. An XBRL taxonomy is a standard description and classification system for the contents of accounting reports. You can load taxonomies by launching the Submit Request Window and choosing the XBRL - Load Taxonomy program. See: Loading/Removing XBRL Taxonomies. When you create a row set in FSG, you can choose a taxonomy from a list of loaded XBRL taxonomies in the Row Set window. When you create a row definition, you can specify an XBRL element for that definition in the Rows window. To create reports as XBRL report output, specify XBRL as the report output. This option does not appear unless at least one XBRL taxonomy has been loaded. You can still run the same report with any of the output options. Note: XBRL output is produced in the code set of the database instance. Using Autocopy and FSG TransferWhen you use FSG Autocopy, the XBRL taxonomy links are copied with the row set. If you are using FSG Transfer to transfer a Row Set to a database instance of the same code set and that Row Set is linked to an XBRL taxonomy and elements, the Row Set and the linked taxonomy and elements will all be transferred. If the taxonomy has imports, taxonomies linked to the main taxonomy, they will also be transferred. Transferring Row Sets linked to an XBRL taxonomy to a database instance of a difference code set is not supported. TroubleshootingPlease note the following when you are creating XBRL output. XBRL Elements XBRL Element Item Types affect how data is characterized in report output. Be sure to use the appropriate item type for the data in your report. For example, if you use the incorrect item type for the data, the XBRL report will be generated but analysis tools downstream may not recognize the data due to incorrect characterization.
Other
Loading/Removing XBRL TaxonomiesTo generate XBRL output with the Financial Statement Generator, you must load one or more taxonomies into your Oracle instance. Once loaded, you select the taxonomy to use for a row set then assign XBRL elements to FSG row definitions. Taxonomies are available from a number of sources, for example at www.xbrl.org. To Download a Taxonomy to Your Oracle Instance
Loading XBRL TaxonomiesLaunch the XBRL - Load Taxonomy program from the Submit Request window. The program has three parameters: Taxonomy Name: Enter a unique name for the taxonomy. Taxonomy xsd File Name: Enter the file name, with or without the .xsd extension. Taxonomy Description: Enter a description for the taxonomy. If a taxonomy has imports (links to other taxonomies), you must load the imports first then load the parent taxonomy. Removing XBRL TaxonomiesTo remove an XBRL taxonomy, launch the XBRL - Remove Taxonomy program from the Submit Request window. The program has one parameter: Taxonomy Name: Enter the taxonomy name or choose from the List of Values. Remove a parent taxonomy before you remove its imports (links to other taxonomies). If you remove a taxonomy already linked to a row set, the program will complete with a warning and the log file will list the relevant row sets. You must manually remove all links to the row sets first then rerun the program to remove the taxonomy. Tip: If you are loading a new version of an existing taxonomy, consider removing the old taxonomy before loading the new version to avoid user confusion. BI Publisher Basic Report TemplatesGeneral Ledger provides basic report templates for you to use for your FSG reports:
You may use the formatting provided in these report templates for your FSG reports or you can modify the templates and save them as new templates or create a completely new template. The templates are formatted for a dynamic number of columns, since the number of columns will vary for every FSG report. Note: The templates use the Arial font. If your FSG reports use the Arial font and they use row orders or the display types of Expand or Both, the row descriptions may be misaligned. To avoid misalignment, create a template that uses a fixed width font, such as Courier. The figure below shows an example of an XML output file that is created when you generate an FSG report with the XML output option. XML output files are composed of elements. Each tag set is an element. For example, in the figure above, <fsg:SOBName></fsg:SOBName> is the Ledger Name element. The data between the brackets is the value of the element. In the figure above, the value for the Ledger Name element is Vision Operations (USA). When a report template is designed, you define placeholders for the elements. The placeholder maps the data field to an element in the XML output file. The figure below shows the layout of the FSG: Basic Template that General Ledger provides for an FSG report. Placeholder Syntaxes Provided in FSG: Basic TemplateThe table below lists the placeholder syntaxes provided in the FSG: Basic Template. Placeholder Syntaxes Provided in the FSG: Basic Template
For detailed information on defining template layout, please see the Oracle Business Intelligence Publisher's Designer's Guide. Country-Specific ReportsThe following lists show which country-specific General Ledger reports are documented in regional user's guides for Oracle Financials, Americas - The following report is documented in the Oracle Financials for the Americas User's Guide: Note: The documentation for these reports applies to Europe, as well as the Americas.
Asia/Pacific - The following report is documented in the Oracle Financials for Asia/Pacific User Guide:
Europe - The following reports are documented in the Oracle Financials for Europe User's Guide: Note: The documentation for these reports applies to the Americas, as well as Europe.
Which of the following describes a general ledger?Which of the following describes a general ledger? The general ledger is a record containing all accounts used by a company.
Which of the following statements is the best definition of an asset quizlet?Which of the following statements is the best definition of an asset? Assets are resources owned or controlled by a company and that have expected future benefits.
Which of the following statements best explains the posting reference in a journal and a ledger?Which of the following statements best explains the posting reference in a journal and a ledger? The posting reference creates a link between the journal and the ledger.
Which of the following is the best definition of the chart of accounts?A chart of accounts (COA) is a financial organizational tool that provides a complete listing of every account in the general ledger of a company, broken down into subcategories.
|