Search Results cc_version_num




Overview
Explore in AI Chat

Overview

IGC_CC_HEADER_VERSION_V is an APPS-owned database view in the Oracle E-Business Suite Contract Commitment (IGC) module. It presents the current and historical versions of contract commitment headers, exposing a consolidated, version-aware picture of commitment records that would otherwise require complex joins across active and history tables. In Oracle EBS 12.1.1 and 12.2.2, the view is marked VALID and is used primarily as a reporting and integration interface rather than as a transactional entry point.

The core purpose of the view is to answer the recurring business question: "which version of a contract commitment header is currently effective?" It resolves this by comparing header versions against a version threshold returned by IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM and by excluding the earliest qualifying history row for each header. The result is a set-based representation of effective commitment header versions, suitable for concurrent programs, Discoverer reports, and custom PL/SQL consumers within the IGC schema.

Underlying Base Objects

The view is defined over both transactional tables and HR/FND security objects. The documented referenced base objects are:

A UNION ALL combines the active header source with the history source. An inline subquery on CC_HEADER_ID restricts rows to versions at or above the package-supplied version number and subtracts the earliest qualifying history row per header, preventing duplicate effective versions.

Key Columns

Common Use Cases and Queries

The view is commonly used for audits, version-comparison reporting, and integration extracts. A representative query retrieving effective commitment headers for a specific operating unit is:

  • Active version report: SELECT CC_NUM, CC_VERSION_NUM, CC_STATE, CC_APPRVL_STATUS, CURRENCY_CODE FROM IGC_CC_HEADER_VERSION_V WHERE ORG_ID = :p_org_id AND CC_VERSION_NUM = (SELECT MAX(CC_VERSION_NUM) FROM IGC_CC_HEADER_VERSION_V WHERE CC_HEADER_ID = ...);
  • Owner workload analysis: SELECT FULL_NAME, COUNT(*) FROM IGC_CC_HEADER_VERSION_V GROUP BY FULL_NAME;
  • Workflow-status integration: selecting WF_ITEM_TYPE and WF_ITEM_KEY for commitment approval tracking.
  • Version history auditing: comparing consecutive CC_VERSION_NUM rows for the same CC_HEADER_ID.

Because HR security predicates are applied through the underlying HR packages, queries should respect operating unit and HR security contexts. The view is read-only; all maintenance occurs against IGC_CC_HEADERS and IGC_CC_HEADER_HISTORY directly.