Search Results igi_cec_dist_summ_n1

Overview

IGI.IGI_CEC_DIST_SUMMARY_ALL is a table owned by the IGI schema within Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, it is a replication of the standard Oracle Purchasing table PO_DISTRIBUTIONS, extended with one additional column, PARENT_DIST_ID, which stores the PO_DISTRIBUTION_ID of the parent distribution. The table resides in the APPS_TS_ARCHIVE tablespace with PCT Free of 10, reflecting its role as an archival or summary-oriented structure.

In the Oracle EBS landscape, this object supports charge-back and cost-allocation style processing by capturing a summarized view of purchasing distribution activity, including quantity ordered, delivered, billed, and cancelled amounts per distribution. Because it mirrors the PO_DISTRIBUTIONS column set, it can be queried with the same column semantics familiar to purchasing developers, while the parent-child structure introduced by PARENT_DIST_ID allows summary-level rollups of underlying distributions.

Using a heuristic Data Vault modeling lens, this object is best classified as a standalone structure, a classification mined directly from its foreign key footprint. It does not sit within a classic hub/link/satellite chain; instead it behaves as a denormalized transactional summary table. This classification should be treated as a modeling suggestion rather than a definitive architectural statement.

Key Information Stored

The table contains 95 documented columns. The most operationally significant include:

• PO_DISTRIBUTION_ID — the original DISTRIBUTION_ID replicated from PO_DISTRIBUTIONS, serving as the principal business-key candidate and natural join path back to the source table.
• PARENT_DIST_ID — the IGI-specific extension column storing the PO_DISTRIBUTION_ID of the parent distribution, enabling hierarchical rollup of distributions.
• PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID — the document hierarchy: header, line, and shipment schedule identifiers.
• SET_OF_BOOKS_ID and CODE_COMBINATION_ID — the accounting context, identifying the set of books and the GL charge account.
• QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED — the core distribution summary quantities that drive reconciliation and accrual reporting.
• DISTRIBUTION_NUM — the distribution sequence number.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

No explicit primary key is documented. The only documented index is IGI_CEC_DIST_SUMM_N1, a NONUNIQUE NORMAL index on PO_HEADER_ID, which supports header-level access paths. Business-key candidacy therefore falls to PO_DISTRIBUTION_ID combined with the document hierarchy columns rather than to a declared surrogate key.

Common Use Cases and Queries

Typical usage centers on reporting and reconciliation of purchasing distribution activity, particularly where a summary perspective or parent-child relationship is required.

• Distribution rollup reporting: joining PARENT_DIST_ID to PO_DISTRIBUTION_ID to traverse from child distributions to their parent summary records.
• Header-level reporting: leveraging the IGI_CEC_DIST_SUMM_N1 index on PO_HEADER_ID to aggregate ordered, delivered, and billed quantities for a given document.
• Accounting reconciliation: grouping by SET_OF_BOOKS_ID and CODE_COMBINATION_ID to compare charge-account activity against GL.
• Comparison with source: joining back to PO_DISTRIBUTIONS on PO_DISTRIBUTION_ID equals DISTRIBUTION_ID to identify summarized versus detail-level discrepancies.

A representative pattern is: SELECT po_header_id, po_distribution_id, parent_dist_id, quantity_ordered, quantity_billed FROM igi.igi_cec_dist_summary_all WHERE po_header_id = :header_id ORDER BY distribution_num.

Related Objects

The metadata documents three foreign key relationships, each anchoring the table to reference data:

• PO_DISTRIBUTIONS — the source table from which this object is replicated; join on PO_DISTRIBUTION_ID.
• PO_RELEASES_ALL — referenced via PO_RELEASE_ID, linking distributions to releases.
• IGF_AW_AWARD_ALL — referenced via AWARD_ID, tying distributions to award records for grant-related processing.
• MTL_KANBAN_CARDS — referenced via KANBAN_CARD_ID for kanban-driven replenishment distributions.

Additional join candidates implied by the column set include PO_HEADERS_ALL and PO_LINES_ALL via PO_HEADER_ID and PO_LINE_ID, and GL_CODE_COMBINATIONS via CODE_COMBINATION_ID. For further foreign key detail, the ETRM metadata directs readers to the PO_DISTRIBUTIONS section of the Oracle Purchasing Applications Technical Reference Manual.