Oracle Build a Template for GXL

Click the drop-down list, and select the ERP or General Ledger to report from.

Click the drop-down list, and select the balance type. Valid values are:

• A (Actual)
• B (Budget)
• E (Encumbrance)
• P (Project)

Note: If Balance Type is set to P, Format must be PER. Balances retrieved are to date (running totals). Additionally, drill down is only available to account balances, not to journals.

If Balance Type is B or E, click the drop-down list, and select the budget or encumbrance name.

Click the drop-down list, and select the reporting year.

Click the drop-down list and select the time range for which to retrieve data. Valid formats are:

• PER
• QTR
• DQTR
• YTD
• LTD
• RANGE

Click the drop-down list, and select the corresponding period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Click the drop-down list, and select whether to display entered or translated currency balances. Valid values are:

• E (Entered)
• T (Translated)
• M (Multiple Reporting Currencies)

Specify a valid currency code.

Click the drop-down list, and, select the ledger, or set of books for which to retrieve data.

Click the drop-down list, and, select which account types to use. Valid values are:

• NA (use the Summary Accounts option from Spreadsheet Server Settings > Ledger Specifics to determine whether to include Summary Accounts with Non-Summary Accounts)
• Y (include only Summary Accounts)
• N (include only Non-Summary Accounts)

If desired, select the check box and click the drop-down list to select an FSG report for which to create a Spreadsheet Server report. If this option is selected, various fields in the panel will be disabled.

If FSG Templates is selected, this option becomes enabled. If selected, missing single segment values are converted to parent hierarchies when the Spreadsheet Server report is created.