Search Results tot_cmt_quantity




Overview
Explore in AI Chat

Overview

APPS.GMS_COMMITMENT_BURDEN_V is a reporting view in the Oracle E-Business Suite Grants Management (GMS) module that presents commitment transactions with both raw (unburdened) and burdened cost amounts. It is designed to expose committed expenditure against awards, projects, and tasks in a form suitable for cost reporting, indirect cost application, and grant financial analysis. The view consolidates two distinct data streams through a UNION ALL: encumbered commitment records drawn from GMS_COMMITMENT_ENCUMBERED_V, and computed indirect (burden) cost rows derived by applying compiled multipliers from Oracle Projects to burdenable raw cost on commitment transactions.

Because it merges both the raw commitment amount and the calculated burdened amount, the view serves as a single source for burdened commitment reporting — a common requirement in sponsored-programs accounting, where indirect costs must be applied to direct committed expenditures. In Oracle EBS 12.1.1 and 12.2.2, this view is typically consumed by Oracle Grants Accounting reports, cost analysis screens, and custom extracts that require a commitment position including facilities and administrative (F&A) burdens.

Underlying Base Objects

The view is defined primarily over the GMS_COMMITMENT_ENCUMBERED_V view, which supplies the base commitment rows (document type, transaction source, commitment number, project/task/award identifiers, expenditure type, organization, vendor, quantity, and raw cost). Burden amounts are generated by joining commitment data to Oracle Projects cost-schedule objects:

  • PA_IND_COST_CODES — provides the indirect cost code linkage to compiled multipliers.
  • PA_COST_BASE_EXP_TYPES — identifies valid expenditure types for the indirect cost base, filtered to cost_base_type = 'INDIRECT COST'.
  • PA_COMPILED_MULTIPLIERS — supplies the compiled multiplier applied to burdenable raw cost to derive the burdened amount.
  • PA_IND_COMPILED_SETS — resolves the compiled set and organization-scoped rate assignment.
  • PA_IND_RATE_SCH_REVISIONS — confirms the rate schedule revision applicable to the cost-plus structure.

Additional referenced objects include GMS_BUDGET_BALANCE, PA_CMT_UTILS, and PO_INTG_DOCUMENT_FUNDS_GRP, which support budget-balance logic and commitment utility processing elsewhere in the surrounding reporting framework.

Key Columns

The view exposes the following principal columns:

  • document_type, transaction_source, cmt_number — identify the commitment document and its origin system.
  • project_id, task_id, award_id — the grants and projects context for the commitment.
  • expenditure_type, expenditure_item_date — classification and effective date of the commitment line.
  • organization_id, vendor_name, unit_of_measure, unit_price — organizational and purchasing attributes.
  • pa_period, gl_date — the accounting period and general ledger date associated with the transaction.
  • tot_cmt_quantity — summed committed quantity across grouped rows.
  • acct_raw_cost — the summed raw (unburdened) cost. For the encumbered stream this equals the commitment raw cost; for the burden stream it is zero.
  • acct_burdened_cost — the summed burdened cost. For the encumbered stream this mirrors raw cost; for the burden stream it equals burdenable_raw_cost multiplied by the compiled multiplier.

Common Use Cases and Queries

The view is most frequently queried to report total commitment exposure on an award including applied indirect cost. A typical query sums raw and burdened cost by award and period:

SELECT award_id, pa_period, SUM(acct_raw_cost) raw_cost, SUM(acct_burdened_cost) burdened_cost FROM apps.gms_commitment_burden_v GROUP BY award_id, pa_period;

Analysts also filter by project and task to reconcile commitment balances against budgets retrieved via GMS_BUDGET_BALANCE. Because grouping is performed on the outer query, the view returns aggregated cost and quantity totals by document, award, and period, which suits summarized grant financial statements as well as detailed extracts feeding downstream cost reconciliation or period-close reporting.