Search Results gms_fp_distributions_u1

Overview

GMS.GMS_FP_DISTRIBUTIONS is a transaction table in the Oracle E-Business Suite Grants Management (GMS) schema that stores the funding pattern distribution details for each funding pattern defined in the system. A funding pattern allows a sponsored project to be charged across multiple awards according to predefined percentage splits. GMS_FP_DISTRIBUTIONS holds those splits, one row per award participating in a given funding pattern, and is the mechanism by which the applications automatically distribute a single transaction across several awards.

The table is owned by the GMS schema, resides in the APPS_TS_TX_DATA tablespace with PCT Free 10, and carries FND Design Data registration under GMS.GMS_FP_DISTRIBUTIONS. In heuristic Data Vault terms, its structure — a composite key of FUNDING_PATTERN_ID and AWARD_ID with a dependent measure column, DISTRIBUTION_VALUE — suggests a satellite-leaning classification, attached to the funding pattern hub. This classification is a modeling suggestion derived from the foreign key topology rather than a documented Oracle construct.

Key Information Stored

The table comprises nine documented columns. The most significant are:

• FUNDING_PATTERN_ID (NUMBER, 15) — System-generated identifier of the funding pattern to which the distribution belongs. This is the primary foreign key and, together with AWARD_ID, forms the composite primary key GMS_FP_DIST_PK.
• AWARD_ID (NUMBER, 15) — Identifier of the award that receives a share of the distributed transaction.
• DISTRIBUTION_NUMBER (NUMBER, 15) — Sequence number that orders the distribution lines within a funding pattern.
• DISTRIBUTION_VALUE (NUMBER) — Percentage value applied to the award for the funding pattern; the set of values across a pattern is expected to total 100 percent.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who columns providing audit and concurrency information.

Two indexes are documented. GMS_FP_DISTRIBUTIONS_U1 is a UNIQUE NORMAL index on (FUNDING_PATTERN_ID, AWARD_ID) in the APPS_TS_TX_IDX tablespace, making this pair the business-key candidate and enforcing that an award appears only once per funding pattern. The composite primary key GMS_FP_DIST_PK covers the same two columns. DISTRIBUTION_NUMBER and DISTRIBUTION_VALUE function as descriptive attributes rather than identifiers.

Common Use Cases and Queries

The primary use case is validating and reporting funding pattern allocations prior to transaction charging. Grants administrators query this table to confirm that distributions reconcile to 100 percent, to identify awards receiving automatic charges, and to trace how a transaction originated on one award was split to others.

A typical query joins the table to GMS_FUNDING_PATTERNS_ALL on FUNDING_PATTERN_ID. A basic extraction follows the ETRM query text:

• SELECT FUNDING_PATTERN_ID, DISTRIBUTION_NUMBER, AWARD_ID, DISTRIBUTION_VALUE FROM GMS.GMS_FP_DISTRIBUTIONS WHERE FUNDING_PATTERN_ID = :pattern_id;
• Reconciliation check: SELECT FUNDING_PATTERN_ID, SUM(DISTRIBUTION_VALUE) FROM GMS.GMS_FP_DISTRIBUTIONS GROUP BY FUNDING_PATTERN_ID HAVING SUM(DISTRIBUTION_VALUE) <> 100;
• Index-driven lookup using GMS_FP_DISTRIBUTIONS_U1: SELECT * FROM GMS.GMS_FP_DISTRIBUTIONS WHERE FUNDING_PATTERN_ID = :p AND AWARD_ID = :a;

Reporting use cases include award-level funding composition analysis, audit of distribution changes via the Who columns, and feed queries for downstream cost allocation logic.

Related Objects

The documented dependency information establishes the following relationships:

• GMS.GMS_FUNDING_PATTERNS_ALL — Referenced by the foreign key GMS_FP_DISTRIBUTIONS.FUNDING_PATTERN_ID. This is the parent entity holding the funding pattern header; every distribution row must resolve to one pattern.
• APPS.GMS_FP_DISTRIBUTIONS — The APPS-layer synonym or view through which the table is normally accessed by application code and reports; GMS_FP_DISTRIBUTIONS is documented as referenced by the APPS schema.
• Award tables (GMS_AWARDS_ALL and related award views) — The AWARD_ID column joins to award definitions to resolve the awards receiving distributions, supporting allocation reporting.

The ETRM metadata records no other objects referencing GMS_FP_DISTRIBUTIONS and states that the table itself references only GMS_FUNDING_PATTERNS_ALL. Query text supplied in the documentation selects all nine columns from GMS.GMS_FP_DISTRIBUTIONS and should be edited to include a WHERE clause when used against production volumes.