Results for “gms_award_dist_eng”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.GMS_AWARD_DIST_ENG package is a core distribution engine within the Oracle E-Business Suite Grants Management (GMS) module. Its primary business function is to generate, buffer, and persist award distribution records — the allocation of sponsored award expenditures, encumbrances, and budget amounts across funding sources according to defined funding patterns. In the grants accounting model, an award is typically funded from one or more sources (sponsor, cost share, program income), and each expenditure charged to a project must be distributed across those sources in the proportions established by the applicable funding pattern. GMS_AWARD_DIST_ENG is the engine that performs this proportional calculation and writes the resulting lines into the distribution tables.

The package is classified as OTHER in the ETRM API classification and resides in the APPS schema with VALID status in both 12.1.1 and 12.2.2. It maintains a narrow dependency footprint at the database level, referencing only SYS.STANDARD, while it operates on a broad set of GMS and Oracle Financials tables through APPS synonyms.

Key Procedures and Functions

The documented interface exposes three entry points:

• PRE_IMPORT — A preparatory routine invoked before distribution records are imported or generated. It establishes the working context for a distribution run, validating the award, funding pattern, and period environment so that subsequent processing proceeds against a consistent state.
• PROC_DISTRIBUTE_RECORDS — The principal processing procedure. It drives the distribution of source amounts (expenditures, encumbrances, or budget balances) across the applicable funding sources, applying funding-pattern percentages and producing the distribution output.
• FUNC_BUFF_RECORDS — A function that buffers distribution records, providing a staging or aggregation mechanism used during distribution processing before records are committed to the persistent distribution tables.

No parameter lists are documented; the procedure and function signatures should be confirmed against the package specification in the target environment.

Tables Accessed

The package reads and writes a substantial set of tables through APPS synonyms:

• Award and funding definition: GMS_AWARDS_ALL, GMS_FUNDING_PATTERNS_ALL — the award header and its funding pattern definitions that govern proportional allocation.
• Distribution output: GMS_AWARD_DISTRIBUTIONS, GMS_DISTRIBUTIONS, GMS_DISTRIBUTION_DETAILS, GMS_FP_DISTRIBUTIONS — the persistent distribution and detail records produced by the engine.
• Budget and encumbrance context: GMS_BUDGET_VERSIONS, GMS_ENCUMBRANCES_ALL, GMS_ENCUMBRANCE_ITEMS_ALL — budget version control and encumbrance lines subject to distribution.
• Cost and interface tables: AP_INVOICE_DISTRIBUTIONS_ALL and AP_SELF_ASSESSED_TAX_DIST_ALL — Payables cost distribution lines that feed grants distribution.
• Interface and period control: GMS_BC_PACKETS, GMS_BC_PACKETS_S, GL_BC_PACKETS_S — burden/interface packet storage — and GL_PERIOD_STATUSES, which enforces open-period validation.

Usage Notes

GMS_AWARD_DIST_ENG is referenced by the GMS_POR_API and GMS_POR_API2 packages, indicating that it is called during Purchase Order and requisition-related award processing, and it is self-referenced, confirming internal recursion across its own routines. It is typically invoked indirectly by these higher-level APIs, by Grants Management concurrent programs that generate award distributions and encumbrances, and from forms-driven processing during award funding setup and cost distribution. Custom code should not call this package directly unless the calling context has already established the required award, funding pattern, and period environment that PRE_IMPORT expects; direct invocation without that context risks incomplete or inconsistent distribution records.