Search Results gms_distribution_details




Overview
Explore in AI Chat

Overview

GMS_DISTRIBUTION_DETAILS is a transactional table within the GMS (Grants Accounting) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the detail lines that make up a distribution — the mechanism by which awarded or sponsored amounts are spread across projects, tasks, expenditure types, and organizations. Each row represents a single distribution line, capturing the recipient accounting attributes along with the distributed quantity and monetary amounts.

The table functions as the child of a distribution header (referenced through DOCUMENT_HEADER_ID and DOCUMENT_DISTRIBUTION_ID) and as a dependent of two master entities: the funding patterns and the award. The heuristic Data Vault classification provided in the metadata is standalone, meaning the FK structure does not exhibit a strong multi-parent hub-and-link topology. As a modeling suggestion, this object is best treated as a transaction-level satellite attached to the distribution document, since its grain is the individual distribution line rather than a shared business entity key.

Key Information Stored

The documented physical schema in ETRM 12.2.2 lists 24 columns. The most significant are:

Common Use Cases and Queries

Typical reporting scenarios include reconciling a distribution document to its detail lines, summarizing distributed amounts by award or project, and auditing status transitions. A representative query joins the detail to the parent header on DOCUMENT_HEADER_ID:

SELECT d.DOCUMENT_HEADER_ID, d.DISTRIBUTION_NUMBER, d.PROJECT_ID, d.TASK_ID, d.AMOUNT_DISTRIBUTED, d.ACCT_BURDENED_COST, d.LINE_STATUS FROM GMS.GMS_DISTRIBUTION_DETAILS d WHERE d.AWARD_ID = :award_id ORDER BY d.DOCUMENT_HEADER_ID, d.DISTRIBUTION_NUMBER;

Analysts commonly aggregate AMOUNT_DISTRIBUTED by AWARD_ID or PROJECT_ID to validate funding allocation, and filter on FC_STATUS or LINE_STATUS to isolate lines pending funds-check or processing. Joining FUNDING_PATTERN_ID to GMS_FUNDING_PATTERNS_ALL provides the pattern description for presentation reports.

Related Objects

  • GMS_FUNDING_PATTERNS_ALL — joined via FUNDING_PATTERN_ID; supplies the funding pattern definition for each distribution line.
  • IGF_AW_AWARD_ALL — joined via AWARD_ID; provides award-level context including sponsor and award attributes.
  • GMS_DISTRIBUTION_HEADERS (or equivalent distribution header table) — the parent document, joined via DOCUMENT_HEADER_ID.
  • PA_PROJECTS_ALL / PA_TASKS — referenced through PROJECT_ID and TASK_ID for project and task validation.
  • PA_EXPENDITURE_TYPES — referenced through EXPENDITURE_TYPE to validate the distribution expenditure classification.
  • GL_CODE_COMBINATIONS — indirectly involved when distributed amounts are transferred to general ledger accounting entries using the organization and expenditure attributes.