Search Results submit_funds_check_enc

Overview

GMS_FC_SYS is an Oracle Grants Management (GMS) system package owned by the APPS schema. Its purpose is to perform funds checking against encumbrance items recorded in Grants Management. In Oracle EBS, funds checking validates whether sufficient authorized budget exists before an expenditure or encumbrance is committed. Within the Grants Management module, this check is applied specifically to encumbrance items linked to awards, encumbrance groups, projects, and organizations. The package exposes two public program units, FUNDS_CHECK_ENC and SUBMIT_FUNDS_CHECK_ENC, both of which accept an encumbrance group, project identifier, end date, and operating unit identifier as selection criteria. The package is classified as OTHER in the ETRM registry, meaning it is not a published open interface or standard callable API, but rather an internal utility supporting the funds check workflow. The stored source header indicates a build date of 2005, reflecting its origin in the earlier Grants Accounting code line that remains embedded in the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package defines two documented program units. The parameter lists are not reproduced here; their documented purposes are as follows.

• FUNDS_CHECK_ENC — A procedure that performs the funds check over encumbrance items. It accepts optional selection criteria for encumbrance group, project, end date, and organization, and returns the standard concurrent program error buffer and return code through its OUT parameters. This signature pattern indicates the procedure is designed to be invoked as a concurrent program, with the runtime engine supplying errbuf and retcode.
• SUBMIT_FUNDS_CHECK_ENC — A function that submits the funds check encumbrance process. It returns a NUMBER, conventionally a concurrent request identifier, allowing the calling form to launch the check as a background concurrent request rather than executing it synchronously. The source comments explicitly state this function is called from GMSTRENE.fmb, the Grants Management encumbrance entry form.

Tables Accessed

The package references a broad set of tables through APPS synonyms, spanning Grants Management, Oracle Projects, and General Ledger:

• GMS_ENCUMBRANCE_ITEMS_ALL, GMS_ENCUMBRANCES_ALL, GMS_ENCUMBRANCE_GROUPS_ALL — the core encumbrance data being funds checked, including the grouping structure used to scope the run.
• GMS_BC_PACKETS, GMS_BC_PACKETS_S, GL_BC_PACKETS_S — budget and encumbrance balance packets that hold the summarized funds check results.
• GMS_BUDGET_VERSIONS — identifies the applicable budget version against which availability is validated.
• GMS_AWARD_DISTRIBUTIONS — award distribution lines that tie encumbrances to funded award amounts.
• GL_PERIOD_STATUSES — determines whether the accounting period is open for the encumbrance entries being checked.
• PA_EXPENDITURE_TYPES, PA_IMPLEMENTATIONS — expenditure type definitions and Projects implementation configuration used to classify and validate encumbrance lines.
• DUAL and PLITBLM — PL/SQL utility references; PLITBLM is the standard EBS table-type used in bulk processing constructs.

Usage Notes

GMS_FC_SYS is invoked internally rather than through public APIs. Its principal entry point is the Grants Management encumbrance entry form GMSTRENE.fmb, which calls SUBMIT_FUNDS_CHECK_ENC to launch the check as a concurrent request; FUNDS_CHECK_ENC then executes within the concurrent manager, writing results to the balance packet tables. Because the ETRM record shows zero referencing packages, the package is effectively a leaf-level utility within the GMS stack. In 12.1.1 and 12.2.2, customization should be avoided: the package body is not designed for extension, and its behavior depends on the integrated state of encumbrances, budget versions, and open GL periods. Any troubleshooting of funds check failures should begin with these underlying tables rather than with the package itself.