Search Results max_activity_date

Overview

APPS.IGC_CC_HDRS_MAX_DATES_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered in FND Design Data under the application short name IGC (Oracle Grants/Contracts, part of the Enterprise Technical Reference Model). In Oracle EBS 12.1.1 and 12.2.2 the view carries a VALID status and is classified as a "supplementary view used to simplify forms coding." This classification is significant: Oracle explicitly warns that the view is not intended for direct customer querying or data manipulation, and that its definition may change dramatically in subsequent minor or major releases. The view therefore exists primarily as an internal Forms-support construct rather than a published integration interface.

The central purpose of the view is to expose, for each Contracts/Commitments header record, the single latest activity date across all related transactional detail. The column name MAX_ACTIVITY_DATE returned by the view directly reflects this aggregation role, and it is the identifier most commonly searched by developers and support analysts investigating award or contract header recency.

Underlying Base Objects

Per the documented dependency metadata, IGC_CC_HDRS_MAX_DATES_V references the following base objects (exposed as APPS synonyms):

• IGC_CC_HEADERS and IGC_CC_HEADER_HISTORY — the header and header history tables that supply CC_HDR_ID.
• IGC_CC_ACCT_LINES and IGC_CC_ACCT_LINE_HISTORY — account line and account line history detail driving date derivation.
• IGC_CC_DET_PF and IGC_CC_DET_PF_HISTORY — the detail "PF" (period/funding) tables and their history counterparts.

The inclusion of both current and history tables indicates that the view computes a greatest-of aggregation across current and historical activity, which explains why the exposed result is a single MAX_ACTIVITY_DATE per CC_HDR_ID. The view is itself referenced by APPS.IGC_CC_CLOSED_CANC_HDRS_V, meaning it participates in the closed/cancelled header reporting chain and should be treated as a dependent object when performing impact analysis.

Key Columns

• CC_HDR_ID (NUMBER, mandatory) — the contract/commitment header identifier. This is the join key to IGC_CC_HEADERS and to any downstream view such as IGC_CC_CLOSED_CANC_HDRS_V.
• MAX_ACTIVITY_DATE (DATE) — the latest activity date determined across the header, account line, and detail/period funding sources (current and history). It is the principal output of the view and is typically compared against a cutoff date in reporting logic.

No other columns are documented; consumers should not assume additional attributes are selectable, particularly given the release-volatility warning.

Common Use Cases and Queries

Typical usage is diagnostic and form-support oriented: identifying headers with recent activity, validating closure or cancellation eligibility, and confirming that a header's derived activity date aligns with its detail transactions.

Retrieve the latest activity date for every header:

• SELECT CC_HDR_ID, MAX_ACTIVITY_DATE FROM APPS.IGC_CC_HDRS_MAX_DATES_V;

Filter to headers active after a cutoff date, joining the header table for descriptive attributes:

• SELECT h.cc_hdr_id, h.* , d.max_activity_date FROM APPS.IGC_CC_HDRS_MAX_DATES_V d, APPS.IGC_CC_HEADERS h WHERE d.cc_hdr_id = h.cc_hdr_id AND d.max_activity_date >= :p_cutoff_date;

Rank headers by recency for a "most recently touched award" report using ORDER BY d.max_activity_date DESC. Because the view is Oracle-proprietary and documented as subject to change, production queries should be limited to read-only reporting, and any embedded use should be revalidated after each EBS patch or upgrade.