Search Results tax_recovery_rate

Overview

IGI_CEC_DIST_SUMMARY is an APPS-owned, VALID database view in the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environments. It belongs to the IGI — Public Sector Financials International product family, which provides U.S. federal government-specific extensions to standard Oracle Purchasing, Payables, and General Ledger functionality. The view exposes distribution-level commitment control (encumbrance) information that originates from the purchasing distribution model. Its primary role is to present a flattened, reporting-friendly projection of purchase order and requisition distribution data together with the encumbrance, accrual, and funds-check attributes that federal financials users rely on.

The user search term "encumbered_flag" corresponds directly to the ENCUMBERED_FLAG column exposed by this view. That column indicates whether a given purchasing distribution has been encumbered in the general ledger, making the view a natural entry point for queries that audit or reconcile encumbrance status across purchasing documents.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, IGI_CEC_DIST_SUMMARY is defined over a single referenced base object: the synonym IGI_CEC_DIST_SUMMARY_ALL. In practice this synonym resolves to the underlying purchasing distribution table that stores the "ALL" or master distribution records for the federal commitment control (CEC) extension. Because the view selects from a synonym rather than a base table directly, the physical source may vary by environment or patch level, but the logical structure — the full column list shown in the view text — is stable.

The view text reveals a straightforward SELECT projecting the complete column set from the synonym. It does not perform joins, aggregations, or filtering in the definition itself, so it behaves as a thin, read-only presentation layer over the underlying distribution data.

Key Columns

The view exposes an extensive column set covering purchasing distribution, encumbrance, accrual, tax, project, and multi-reporting-currency attributes. Notable columns include:

• PARENT_DIST_ID / PO_DISTRIBUTION_ID / SOURCE_DISTRIBUTION_ID — identify the distribution and its hierarchical relationships.
• PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, PO_RELEASE_ID — foreign keys back to the purchasing document structure.
• ENCUMBERED_FLAG, ENCUMBERED_AMOUNT, UNENCUMBERED_QUANTITY, UNENCUMBERED_AMOUNT — the encumbrance state and remaining balances for the distribution; ENCUMBERED_FLAG is the specific attribute most commonly queried.
• GL_ENCUMBERED_DATE, GL_ENCUMBERED_PERIOD_NAME, GL_CANCELLED_DATE, GL_CLOSED_DATE — General Ledger timing attributes for the encumbrance entry.
• ACCRUED_FLAG, ACCRUE_ON_RECEIPT_FLAG, PREVENT_ENCUMBRANCE_FLAG, FAILED_FUNDS_LOOKUP_CODE — accrual and funds-control behavior indicators.
• AMOUNT_BILLED, QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED — quantity and amount tracking across the procurement lifecycle.
• MRC_RATE, MRC_ENCUMBERED_AMOUNT, MRC_UNENCUMBERED_AMOUNT, MRC_BASE_AMOUNT_BILLED — multi-reporting-currency equivalents.
• PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, AWARD_ID — project and grant accounting attributes; AWARD_ID is particularly relevant to federal award management.
• ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF (descriptive flexfield) context columns.

Common Use Cases and Queries

The most frequent use of this view is to report on which purchasing distributions have or have not been encumbered, and to reconcile encumbered amounts against the general ledger. A representative query filtering on the searched attribute is:

• SELECT PO_DISTRIBUTION_ID, ENCUMBERED_FLAG, ENCUMBERED_AMOUNT, UNENCUMBERED_AMOUNT, GL_ENCUMBERED_PERIOD_NAME FROM APPS.IGI_CEC_DIST_SUMMARY WHERE ENCUMBERED_FLAG = 'Y' AND GL_ENCUMBERED_PERIOD_NAME = :p_period;

Additional scenarios include identifying distributions that failed funds checking (FAILED_FUNDS_LOOKUP_CODE), joining to PO_HEADERS_ALL and PO_DISTRIBUTIONS_ALL via the exposed foreign keys for detailed document reporting, and aggregating unencumbered amounts by award or project for grant-budget monitoring. Because the view is a thin projection, any restrictive predicate must be applied by the query author; the view itself returns all rows from the underlying synonym.