Search Results igc_cc_arc_acct_line_hist




Overview
Explore in AI Chat

Overview

IGC_CC_ARC_ACCT_LINE_HIST is a table in the IGC (Contract Commitment) product schema within Oracle EBS 12.1.1 and 12.2.2. It serves as a historical repository for account line versions that are staged for archiving. In the Contract Commitment architecture, account lines represent the accounting distributions generated from commitment documents and their associated charges. As these distributions are revised, approved, or superseded, each version is captured so that a complete audit trail is preserved before older versions are moved out of the active transactional tables.

The table carries a composite primary key, ICAALH_PK, defined over CC_ACCT_LINE_ID and CC_ACCT_VERSION_NUM. A matching unique index, IGC_CC_ARC_ACCT_LINE_HIST_U1, is defined on the same two columns, confirming that the combination of account line identifier and version number uniquely identifies each historical record. The documented physical schema consists of 48 columns. Under the heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning: it stores descriptive and measure-bearing attributes attached to a business key rather than serving as a pure hub or link. That classification is a modeling suggestion; the physical object remains a standard Oracle EBS archive table.

Key Information Stored

The most significant columns fall into three groups: identity and versioning, accounting amounts, and project/expenditure attribution.

Common Use Cases and Queries

The principal use case is audit and reconciliation: reconstructing the history of an account line as it existed prior to archival. Typical queries join the archive history on the composite key and filter by version to compare successive states.

  • Retrieve the full version history of a single account line: SELECT * FROM igc.igc_cc_arc_acct_line_hist WHERE cc_acct_line_id = :line_id ORDER BY cc_acct_version_num;
  • Identify the latest archived version per line using an analytic rank over CC_ACCT_VERSION_NUM.
  • Report encumbrance activity from archived versions by filtering on CC_ACCT_ENCMBRNC_STATUS and CC_ACCT_ENCMBRNC_DATE.
  • Reconcile entered versus functional amounts across versions to detect restatements or revaluations.
  • Reconstruct project cost attribution using PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE for integration to Oracle Projects.

Because the table is an archive target, queries are generally read-only and often executed through concurrent archive or purge processes rather than interactive forms.

Related Objects

The documented foreign key relationship for this table is self-referencing on CC_ACCT_LINE_ID, reflecting the satellite-style lineage of account line history. The most significant related objects are:

  • IGC_CC_ARC_ACCT_LINE_HIST (self, via CC_ACCT_LINE_ID) — historical lineage and predecessor versions.
  • IGC_CC_ACCT_LINES — the active account line table from which archived versions originate; joined on CC_ACCT_LINE_ID.
  • IGC_CC_HEADERS — commitment headers referenced by CC_HEADER_ID and PARENT_HEADER_ID.
  • IGC_CC_CHARGES — charge definitions linked through CC_CHARGE_CODE_COMBINATION_ID and charge codes.
  • GL_CODE_COMBINATIONS — source of the accounting flexfield for CC_CHARGE_CODE_COMBINATION_ID and CC_BUDGET_CODE_COMBINATION_ID.
  • PA_PROJECTS, PA_TASKS, and PA_EXPENDITURE_TYPES — project, task, and expenditure type validation for PROJECT_ID, TASK_ID, and EXPENDITURE_TYPE.
  • IGC_CC_ARCHIVE_* concurrent programs and related archive staging tables — drive the movement of rows into this history object.