|Oracle U.S. Federal Financials User Guide|
Part Number E13551-04
The Budgetary Control Results report provides detailed information about the funds check failure or success, reporting on transactions funds checked in Purchasing, Payables, Federal Financials, Projects, Grants, and General Ledger.
Budgetary Control Results report can be generated from the transactional windows or from the Standard Request submission window.
To generate the Budgetary Control Results report from the transactional windows:
Select the View Results button in the Funds Check or Funds Reservation Message window.
From the Tools menu, select the View Results option from the Transactional window.
To generate the Budgetary Control Results report from Standard Request window:
Navigate to the Submit Request window.
In the Name field, select Federal Budgetary Control Results Report.
In the Ledger field, select the ledger.
In the Period From and Period To field, select the period names for calendar assigned to the ledger selected.
In the Funds Result Status field, select the status.
Note: If left blank all funds check transactions for the ledger, period and any status will be displayed.
In the Order By field, select a field name to sort the data.
Note: If left blank the data will be order by account combination within a given transaction.
The following table describes the report headings of the Federal Budgetary Control Results report.
|Ledger||The ledger value from report parameter from the submit request window.|
|Currency||This is the functional currency of the ledger displayed.|
|Order By||The field on which the report is sorted.|
|Funds Result Status||Funds Result Status
Note: The funds results status is defaulted to F (Failed), when the report is submitted through the Submit Request window. However, the user can change it to other values.
|Templates||The list consists of Oracle’s predefined Budgetary Control Results template but in addition users can define their own template and therefore the list could expand.|
|Report Format||The output format of the report such as HTML or PDF.|
|View Report||Click View Report to see the impact on the data if you change the parameters for Order By or Budgetary Control Status.|
|Export||When the user selects Export the body of the report is displayed in the format selected in Report Format.|
The following table describes the values on which the Federal Budgetary Control Results report is grouped by.
|Batch Reference||Batch reference; the value displayed is derived from the transaction(s) that has been funds checked.|
|Document Reference||Document reference; the value displayed is derived from the transaction(s) that has been funds checked.|
|Supplier||The supplier name for the relevant the Purchasing or Payables transaction.|
|Site||The supplier site for the relevant transactions in the Purchasing or Payables transaction.|
The following table describes the column headings of the Budgetary Control Results report.
|Account Combination||Account combination|
|Period||The period name for the specific transaction line/journal line.|
|Line Reference||Line reference|
|Result Status Type||Result status type|
|Result Message||The detailed funds check message for each transaction line/journal line.|
|Previous Funds Available||This is the funds available for the particular account combination at the Budgetary Control occurred.|
|Base Amount||This is the transaction line amount that has undergone funds check.|
|Current Funds Available||The funds available for the particular account combination at the time the Budgetary Control occurred which includes the transaction amount.|
|Amount Type||The Amount Type determines the cumulative balance to use for the Budgetary Control interval.|
|Boundary||The Boundary defines the end point of a Budgetary Control interval.|
|Treasury Symbol||Treasury symbol of the budget execution transaction.|
When the Federal Budgetary Control Results Report is submitted from the standard report submission window in either General Ledger or subledgers:
For each document reference within the Budgetary Control Results Report, multiple lines may have been funds checked. Some lines may have failed and some lines may have passed the funds check or funds reservation.
If you are reviewing the General Ledger transaction lines for a given journal, and some lines had a Failed Check status and some lines had a Passed Check for a funds check, it means the overall GL journal failed funds check.
If all the GL journal lines, for a given GL Journal, had an Approved status then the overall GL Journal passed and funds were reserved.
If some GL journal lines, for a given GL journal, had a Rejected status and some lines had an Approved status for a funds reservation, it means the overall GL journal failed and no funds were reserved.
If you are reviewing the subledger transaction lines for a subledger transaction, and some lines had a Failed Check status and some lines had a Passed Check status for a funds check, it means that some lines passed funds check and some lines failed funds check.
If some subledger transaction lines, for a given subledger transaction, had a Rejected status and some lines had an Approved status for a funds reservation, it means some subledger transaction lines were reserved (Approved status) and some were not reserved (Rejected).
A profile option for 'Budgetary Control Results Template' allows you to default the template used to display Budgetary Control Results, and it is available at all levels: Site, Application, Responsibility and User.
The default template is the 'Budgetary Control Results Template'. If Oracle Federal Financials is enabled, the default template is the ‘Federal Budgetary Control Results Template’.
This profile option enables you to define your own Budgetary Control Results Report template and associate it with the profile option. When you perform a funds check, funds reservation, or run the Budgetary Control Result report from the Standard Request Submission window, the report matches the Budgetary Control Results Report template set in the profile option.
If you want to modify existing templates and add new columns, you can see what columns are available by viewing the XML file.
The XML file produced by the Budgetary Control Results Report can be viewed:
Run the Budgetary Control Results Report concurrent request from the Submit Request window.
After successful completion, click Diagnostics>View XML.
Oracle XML Publisher Administration and Developer's Guide
Copyright © 1999, 2010, Oracle and/or its affiliates. All rights reserved.