Search Results gms_budget_balance




Overview
Explore in AI Chat

Overview

GMS_BUDGET_BALANCE is an Oracle EBS Grants Management (GMS) PL/SQL package owned by the APPS schema. Its role is to maintain and expose award budget balance information so that budget consumption, encumbrance, commitment, and invoiced-quantity positions can be calculated and displayed consistently across the Grants Management subsystem. The package acts as a supporting utility for budget lines, budget versions, encumbrances, and award distributions, and it supplies derived values that appear in GMS concurrent processes, workflow activities, and inquiry views.

Within the EBS 12.1.1 and 12.2.2 releases, GMS_BUDGET_BALANCE is catalogued with an API classification of OTHER, indicating that it is not formally published as an external integration API but functions as an internal component. The ETRM documentation records two documented program units: UPDATE_GMS_BALANCE and GET_PO_QTY_INVOICED. The package is referenced by five other packages, most notably GMS_BUDGET_PUB and GMS_WF_PKG, and by the views GMS_COMMITMENT_BURDEN_V, GMS_COMMITMENT_ENCUMBERED_V, and GMS_STATUS_COMMITMENTS_V. It is marked VALID in the documented environment.

Key Procedures and Functions

  • UPDATE_GMS_BALANCE — The primary maintenance routine. It recalculates and updates the GMS_BALANCES records associated with an award, budget line, or resource assignment so that budget, actual, commitment, and encumbrance amounts agree with the underlying transactions. It is invoked after budget versions are baselined or amended, after encumbrances and invoices are processed, and during reconciliation of award balances.
  • GET_PO_QTY_INVOICED — A retrieval function that returns the invoiced quantity for a purchase order or related distribution line. It supports encumbrance and commitment reporting by comparing ordered quantities against amounts already invoiced through Payables, allowing GMS views and processes to derive open commitment quantities.

The package additionally relies on Oracle's STANDARD package and SYS-level dependencies, as shown in the dependency listing. No parameter lists are published in the available metadata and are therefore intentionally omitted.

Tables Accessed

The documented table access set is broad and reflects the package's balance-reconciliation purpose:

Usage Notes

GMS_BUDGET_BALANCE is an internal utility rather than a public API. It is typically invoked from Grants Management forms and concurrent programs when award budgets are entered, baselined, adjusted, or reconciled; from workflow-driven events through GMS_WF_PKG; and indirectly through GMS_BUDGET_PUB when callers require budget balance maintenance. The dependent commitment and encumbrance views use it to present status information, particularly around purchase order quantities invoiced and open commitments. Custom code should call the supported public packages such as GMS_BUDGET_PUB rather than this package directly, and because it writes to core balance tables, any direct invocation should be performed only under the direction of Oracle Support and within a controlled maintenance window.