Search Results igi_cec_dist_summary_all




Overview
Explore in AI Chat

Overview

IGI_CEC_DIST_SUMMARY_ALL is a transactional table owned by the IGI schema (Public Sector Financials International) in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores distribution-level detail derived from Oracle Purchasing purchase order distributions. In the ETRM metadata, the object description states simply that it "Contains details of PO_DISTRIBUTIONS," reflecting its role as a summarized or staging copy of purchasing distribution information used by IGI's commitment control, encumbrance, and funds-checking logic. The physical definition documented at 12.2.2 contains 95 columns, spanning key identifiers, quantity and amount measures, encumbrance state, accounting flexfield references, project and WIP attributes, tax and recovery amounts, and descriptive flexfield segments.

From a data modeling perspective, the mined Data Vault classification for this table is standalone — a heuristic suggestion that the table is not decomposed into hub, link, or satellite constructs. The absence of foreign keys pointing to this table (only outgoing references) reinforces this classification. Downstream consumers should treat it as a self-contained summary entity sourced from Purchasing rather than a normalized master or relationship table.

Key Information Stored

The table carries a full column set of 95 attributes. The most operationally significant columns are grouped below.

The metadata does not document a named surrogate primary key or unique index beyond PO_DISTRIBUTION_ID, which functions as the business-key candidate given its direct correlation to PO_DISTRIBUTIONS.

Common Use Cases and Queries

IGI_CEC_DIST_SUMMARY_ALL is queried primarily to reconcile purchasing distributions against encumbered and unencumbered balances, to trace funds-check failures, and to feed commitment-control reporting. A typical pattern joins the summary to Purchasing and GL:

  • List distributions with unreleased encumbrances: SELECT po_distribution_id, encumbered_amount, unencumbered_amount FROM igi.igi_cec_dist_summary_all WHERE encumbered_flag = 'Y' AND gl_closed_date IS NULL;
  • Trace failed funds checks by distribution: join to CODE_COMBINATION_ID and FAILED_FUNDS_LOOKUP_CODE to isolate distributions rejected during budget validation.
  • Project encumbrance rollups: aggregate by PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE for project costing reports.
  • Award reporting (IGF): join AWARD_ID to IGF_AW_AWARD_ALL for grant and award commitment reporting.
  • Multiple reporting currency reconciliation: compare AMOUNT_BILLED with BASE_AMOUNT_BILLED and the MRC_* columns.

Related Objects

The documented foreign keys reveal the principal dependencies of this table.

  • PO_RELEASES_ALL via PO_RELEASE_ID — links a distribution back to the release from which it originated.
  • MTL_KANBAN_CARDS via KANBAN_CARD_ID — supports Kanban replenishment sourcing.
  • IGF_AW_AWARD_ALL via AWARD_ID — connects distributions to award and grant tracking.
  • PO_DISTRIBUTIONS_ALL — the presumed source table given the object description "Contains details of PO_DISTRIBUTIONS"; joined on PO_DISTRIBUTION_ID.
  • PO_HEADERS_ALL / PO_LINES_ALL / PO_LINE_LOCATIONS_ALL — reached via PO_HEADER_ID, PO_LINE_ID, and LINE_LOCATION_ID for full purchasing context.
  • GL_CODE_COMBINATIONS — resolved through CODE_COMBINATION_ID and related account columns for accounting validation.

These relationships make the table a central reference point for IGI commitment control and encumbrance reporting in EBS 12.1.1 and 12.2.2.