Search Results igc_cc_closed_canc_hdrs_v




Overview
Explore in AI Chat

Overview

IGC_CC_CLOSED_CANC_HDRS_V is a reporting view owned by the APPS schema within the IGC (Contract Commitment) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents a consolidated list of contract commitment headers that have reached a closed or cancelled lifecycle state and have been fully approved. Specifically, the view restricts its output to header records where the commitment state (CC_STATE) is either 'CL' (Closed) or 'CT' (Cancelled) and where the approval status (CC_APPRVL_STATUS) equals 'AP' (Approved). In addition, the view joins down through the accounting line and detail performance line structure, so that each row reflects the intersection of an eligible header with its associated accounting and detail lines. As a consequence, the view does not simply return headers; it returns the header/acct/detail correlation set together with the latest activity timestamp recorded for the header. This makes it useful for period-end reconciliation, archival reporting, and downstream integration extracts that must isolate commitments which are no longer active, i.e., those that are closed or cancelled, rather than open or in-process commitments.

Underlying Base Objects

The view is defined over four documented base objects:

The join chain is therefore: IGC_CC_HEADERS → IGC_CC_HDRS_MAX_DATES_V, then the header to IGC_CC_ACCT_LINES, then the accounting line to IGC_CC_DET_PF. This hierarchical structure is typical of contract commitment data, where a header owns multiple accounting lines, each owning multiple detail performance lines. The view naturally inherits this cardinality.

Key Columns

  • CC_HD_ID — the commitment header identifier (sourced from CC_HDR_ID in the max-dates view).
  • CC_NUM_VAL — the human-readable commitment number (CC_NUM) from IGC_CC_HEADERS.
  • CC_ACT_ID — the accounting line identifier (CC_ACCT_LINE_ID) associated with the header.
  • CC_PF_ID — the detail performance line identifier (CC_DET_PF_LINE_ID) associated with the accounting line.
  • MAX_DT — the latest activity date recorded for the commitment header.

Common Use Cases and Queries

Because the view filters to approved, closed/cancelled commitments, it is commonly used to report on completed obligations, to feed downstream archival or data-mart extracts, and to reconcile commitments that have been finalized within a fiscal period. A typical query lists closed commitments with their associated line detail:

SELECT cc_hd_id, cc_num_val, cc_act_id, cc_pf_id, max_dt
FROM apps.igc_cc_closed_canc_hdrs_v
WHERE max_dt >= :p_period_start
ORDER BY max_dt DESC;

A second scenario aggregates the number of accounting and detail lines per closed commitment header:

SELECT cc_hd_id, cc_num_val, COUNT(*) line_count
FROM apps.igc_cc_closed_canc_hdrs_v
GROUP BY cc_hd_id, cc_num_val;

Because the view exposes only headers that are approved and either closed or cancelled, no additional state predicate is required, though period filtering on MAX_DT is recommended to bound result sets in high-volume environments.