Search Results gms_enc_adjustments




Overview
Explore in AI Chat

Overview

The APPS.GMS_ENC_ADJUSTMENTS package is a PL/SQL API within the Oracle E-Business Suite Grants Management (GMS) module. Its principal business function is to manage adjustments, reversals, and structural changes to encumbrances associated with awards and award distributions. Encumbrances in GMS represent committed funds against an award budget, and once these commitments have been created they frequently require correction or reclassification—whether because an award is modified, a distribution is reallocated, or an entire encumbrance group must be undone. This package centralises the logic required to perform those adjustments in a controlled, auditable manner, ensuring the encumbrance, encumbrance group, and encumbrance item records remain consistent with the underlying award accounting. The package is classified as an "OTHER" API rather than a fully published open interface, indicating that it primarily supports internal Grants Management processing. Its status is recorded as VALID in the APPS schema under both Oracle EBS 12.1.1 and 12.2.2, and it depends directly on PA_UTILS for shared project accounting utility routines.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within the package:

  • COPYITEMS — Copies encumbrance item records, supporting the duplication of item-level commitment data from a source context to a target context, typically during adjustments that require the reconstruction of item lines.
  • PREAPPROVED — Handles the pre-approval processing path for encumbrance adjustments, validating that the proposed adjustment meets the conditions necessary to proceed without further approval workflow.
  • REVERSEENCGROUP — Reverses an entire encumbrance group, unwinding the associated committed amounts and restoring the affected distributions.
  • BACKOUTITEM — Backs out an individual encumbrance item, removing or negating a specific commitment line without affecting unrelated items.
  • REVALIDATE_EMPLOYEE — Revalidates the employee information associated with an encumbrance adjustment, ensuring the personnel reference remains valid before processing continues.

Parameter lists are not catalogued in the available metadata and should be confirmed against the deployed package specification.

Tables Accessed

The package accesses several Grants Management encumbrance tables through APPS synonyms. GMS_ENCUMBRANCES and its _S shadow table hold the header-level encumbrance records, while GMS_ENCUMBRANCE_ITEMS_B-style objects—GMS_ENCUMBRANCE_ITEMS, GMS_ENCUMBRANCE_ITEMS_ALL, and GMS_ENCUMBRANCE_ITEMS_S—store the item detail and associated descriptive/translation data. GMS_ENCUMBRANCE_GROUPS maintains the grouping construct used by REVERSEENCGROUP. GMS_AWARD_DISTRIBUTIONS provides the award distribution context against which encumbrances are committed, and PA_TASKS supplies project task validation. DUAL is used for singleton queries, while PLITBLM is the standard Oracle EBS PL/SQL table/array manipulation utility.

Usage Notes

Because this package is not a published open interface, it is typically invoked indirectly by Grants Management forms or concurrent programs rather than by customer-developed extensions. The most common entry points are the award and encumbrance adjustment screens in the GMS responsibility, where user actions such as reversing an encumbrance group or backing out an item trigger the corresponding package routines. Concurrent processes that refresh or revalidate award commitment data may also call these procedures. Custom code should only call GMS_ENC_ADJUSTMENTS after confirming the parameter signatures in the deployed specification, and should respect standard error-handling conventions, since the package relies on PA_UTILS for shared validations. As the package is referenced by no other packages, it sits near the top of its dependency chain and warrants careful testing when applied during upgrades or data-fix scripts.