Search Results igc_cc_arc_det_pf_hist




Overview
Explore in AI Chat

Overview

The IGC.IGC_CC_ARC_DET_PF_HIST table is an Oracle EBS Contract Commitment (IGC) historical archive object that stores detail payment forecast line versions slated for archival. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 architecture, its function is to retain the full version history of payment forecast detail lines so that superseded or closed versions can be preserved offline or in a separate archive schema without losing audit continuity. The table is owned by the IGC schema and is currently marked VALID in the ETRM 12.2.2 dictionary.

Under a heuristic Data Vault classification mined from its foreign-key structure, this table is satellite-leaning. In Data Vault modeling terms, that classification is a suggestion rather than a normative constraint: a satellite holds descriptive attributes tied to a parent hub or link key, and the presence of CC_DET_PF_VERSION_NUM as part of the primary key (rather than a single immutable surrogate) supports a versioned-satellite interpretation. Each row therefore represents one archived version of one payment forecast detail line.

Key Information Stored

The primary key is ICADPH_PK, a composite surrogate key defined over CC_DET_PF_LINE_ID and CC_DET_PF_VERSION_NUM. The same two columns form the unique index IGC_CC_ARC_DET_PF_HIST_U1, which is the documented business-key candidate identifying a specific version of a specific forecast line. Key business columns include:

The table documents 36 columns in total; the remaining columns are the standard audit set (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN), a CONTEXT column, and DFF attributes ATTRIBUTE1 through ATTRIBUTE15.

Common Use Cases and Queries

Typical applications include audit reconstruction of a payment forecast as it stood at a given version, commitment and encumbrance reporting against archived data, and archival purge verification.

SELECT CC_DET_PF_LINE_ID, CC_DET_PF_VERSION_NUM,
       CC_DET_PF_VERSION_ACTION, CC_DET_PF_FUNC_AMT
FROM   IGC.IGC_CC_ARC_DET_PF_HIST
WHERE  CC_DET_PF_LINE_ID = :line_id
ORDER  BY CC_DET_PF_VERSION_NUM;

Version-count reconciliation across source and archive:

SELECT CC_DET_PF_LINE_ID,
       COUNT(*) AS archived_versions
FROM   IGC.IGC_CC_ARC_DET_PF_HIST
GROUP  BY CC_DET_PF_LINE_ID
HAVING COUNT(*) > 1;

Encumbrance aging reports filter on CC_DET_PF_ENCMBRNC_STATUS and CC_DET_PF_ENCMBRNC_DATE to reconcile obligated versus billed amounts.

Related Objects

  • IGC_CC_ARC_DET_PF_HIST self-references through CC_DET_PF_LINE_ID in the documented FK mapping, mirroring the parent/child line hierarchy.
  • The Contract Commitment payment forecast detail line table (source of CC_DET_PF_LINE_ID) supplies the live rows later copied into this archive.
  • The Contract Commitment account line table referenced by CC_ACCT_LINE_ID and PARENT_ACCT_LINE_ID.
  • Foreign-key joins resolve through CC_DET_PF_LINE_ID, preserving the link back to the originating forecasting records.
  • Standard IGC Concurrent Programs and archive purges operate on this table for retention management.