Skip Headers

Oracle Public Sector Financials User Guide
Release 12.1
Part Number E13449-04
Go to Table of Contents
Go to previous page
Go to next page

Funds Available Inquiry Procedures


General Ledger Funds Inquiry enables drilldown from account budget status inquiry to accounting entry components and then to subledger transaction detail.

Funds Available Inquiry (FAI) in General Ledger is the principal budget management tool for organizations using budgetary control. For a given account code combination, FAI displays budget status, consisting of budget, encumbrance, and actual balances, and the available funds for the specified period range.

The Fund Available Inquiry can be used as a fully integrated budget monitoring tool including the following features:

The diagram below shows the additional windows accessible from the General Ledger Funds Available Inquiry window, as described in the accompanying text.

Funds Available Inquiry with Drilldown Functionality Process

the picture is described in the document text

Funds Available Inquiry Process

After performing a standard General Ledger funds inquiry, users can select an account code combination for further drilldown. If this account is a summary account, there are two options available: viewing the detail accounts for the summary account, or viewing the period balances. Both options are available from the Tools menu. The period balances for the displayed detail accounts can then be accessed from the Detail Accounts window. If the selected account is a detail account, users can display the period balances for that account.

On the Period Balances window, users can select a period and use the Tools menu to access either the budget, actual, or encumbrance accounting lines for that period in the Accounting Entries Detail window. From there, drilldown to subledger accounts is available.


For information on the FAI process, see Viewing Funds Available, Oracle General Ledger User's Guide.

Viewing Funds Available Details Procedure

To drilldown to funds available details:

  1. In General Ledger, navigate to the Funds Available Inquiry window.

  2. In the Ledger field, select the ledger.

    Note: The list of values include ledgers assigned to the GL: Ledger Name profile options.

  3. In the Budget field, select a budget from the list of values.

  4. In the Amount Type field, select whether to display amounts for period to date, project to date, quarter to date, or year to date from the drop-down list.

  5. In the Period field, select a period from the list of values.

    Note: The default value is the accounting period associated with the system date if the selected budget includes that date. Otherwise, the value is the first accounting period within the selected budget.

  6. In the Encumbrance Type field, select an encumbrance type from the list of values.

  7. In the Account Level field, select All, Detail, or Summary from the drop-down list.

  8. Navigate to the Funds Available region and query a partial or complete account.

  9. Select an account.

    If the account is a detail account, go to step 10. If the account is a summary account, go to step 12.

  10. To view period balances for the detail account, go to Tools - Period Balances.

    The Period Balances window appears.

  11. Go to step 17.

  12. To view period balances for the summary account, go to Tools - Period Balances.

    The Period Balances window for summary accounts appears.

  13. Close the Period Balances window.

  14. To view detail accounts for the summary account, go to Tools - Detail Accounts.

    The Detail Accounts window appears.

  15. Select a detail account.

    Note: The Encumbrance Amounts fields display the encumbered amounts for purchase order and requisition encumbrance types and all other encumbrance types if:

  16. To view period balances for the detail account, click Period Balances.

    The Period Balances window for detail accounts appears.

  17. Select a period.

  18. To view accounting entries for the selected period, do one of the following:

    The Accounting Entries Detail window appears.

  19. To drilldown to subledger details, click Drilldown.