General Ledger provides basic report templates for you to use for your FSG reports:
FSGXML: Basic Template
FSGXML: Basic Drilldown Template
FSGXML: Basic Excel Drilldown Template (Raw Amounts)
FSGXML: Basic Excel Template (Raw Amounts)
FSGXML: Basic Excel Drilldown Template
FSGXML: Basic Excel Template
The first two templates (RTF) are most commonly used to generate PDF output.
The last four templates (spreadsheet) are most commonly used to generate spreadsheet output.
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.
Additional Information: The FSGXML: Basic templates are designed for a maximum of 30 columns by default. If you have more than 30 columns you must modify the template to fit your requirements.
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.
The table below lists the placeholder syntaxes provided in the FSG: Basic Template.
Placeholder Syntaxes Provided in the FSG: Basic Template
| Placeholder | Syntax | Meaning |
|---|---|---|
| FSG Namespace | <?namespace:fsg=http://www.oracle.com/fsg/2002- 03-20/?> | Identifies the elements associated with FSG. This placeholder does not display anything on the published report. |
| FSG Report Name | <?fsg:ReportName?> | Inserts the FSG report name. |
| Ledger Name | <?fsg:LDGName?> | Inserts the ledger name entered for your run-time Ledger parameter. |
| Report Period | <?concat(MasterReport/fsg:PeriodLabel,'')?> <?fsg:RepCurPeriod?> | Inserts the Current Period label and the period. |
| Date: | <?MasterReport/fsg:DateLabel?> | Inserts the Date label. |
| DD-MMM-YYYY hh:mm:ss | <?MasterReport/fsg:RepSysDate?> | Inserts the system date and time when the report was created. |
| Page: | <?MasterReport/fsg:PageLabel?> | Inserts the Page label. |
| Body Start | <?start:body?> | Indicates the beginning of the body area of your report. Anything above this tag is considered the header and is repeated on every page. |
| <?for-each:fsg:RptDef?> | Loops through the elements of the RptDef group, which is a group of elements in the XML output file representing report data. | |
| Currency Label | <?/MasterReport/fsg:CurrencyLabel?> | Inserts the Currency label. |
| Currency | <?/MasterReport/fsg:ReportCurr?> | Inserts the currency code of the report. |
| Segment Value Overrides | <?./@RptDetName?> | Inserts the specified segment value overrides (segment name, value, and description). RptDetName is an attribute of the RptDef group. |
| Column Wrapping | <?horizontal-break-table:1?> | Indicates that if the number of columns exceeds the page width, then repeat the next column on the next page. This enables the template to handle a dynamic number of columns since the number of columns can vary between reports. |
| Column Headers and Widths | <?split-column-header://fsg:ColContext?> <?split-column-width:fsg:ColWidth?> <?split-column-width-unit:number(6)?> | Determines the column headers and the width of each column. |
| Report Alignment | <xsl:if test="position()=1" xdofo:ctx="inblock"><xsl:attribute name="text- align">start</xsl:attribute></xsl:if> | Aligns the report based on the language. For example, English reports read from left to right, while Arabic reports read from right to left. Note: Be sure that if you plan to modify the syntax for a new template, that you do it for all the placeholders with this placeholder name. |
| Column Heading Line 1 | <?value-of:fsg:ColHeadLine1?> | Inserts column heading line 1. |
| Column Heading Line 2 | <?value-of:fsg:ColHeadLine2?> | Inserts column heading line 2. |
| Column Heading Line 3 | <?value-of:fsg:ColHeadLine3?> | Inserts column heading line 3. |
| Report Data | <?for-each:fsg:RptLine?> <?split-column-data:fsg:RptCell[3]?> <?value-of:.?> | Inserts report data. |
| Page Break; | <?xsl:if xdofo:ctx="inblock" test="position()<count(//fsg:RptDef)"><xsl:attribute name="break before">page</xsl:attribute></xsl:if> | Inserts a page break. |
| Body End | <?end for-each?><?end body?> | Indicates the end of the body area of your report. Anything below this tag is considered the footer and is repeated on every page. |
For detailed information on defining template layout, please see the Oracle Business Intelligence Publisher's Designer's Guide.