Search Results igi_itr_charge_lines_audit_tmp




Overview
Explore in AI Chat

Overview

The IGI_ITR_CHARGE_LINES_AUDIT_TMP table resides in the IGI schema, owned by the Public Sector Financials International product family within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. As its description indicates, the table holds details of deleted charge lines. It functions as an internal audit and staging repository that captures charge line records at the moment they are removed from the primary charge line structures, preserving a historical footprint for reconciliation, troubleshooting, and government-audit traceability required in public-sector deployments.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as standalone under the Data Vault scheme. Standalone classification suggests the table neither behaves as a pure hub (no independent business key) nor as a pure link (no single consolidated relationship), and instead acts as a satellite-style descriptive record keyed indirectly to parent charge headers and charge centers. This classification is advisory; in practice the table depends on two foreign keys pointing to IGI_ITR_CHARGE_HEADERS and IGI_ITR_CHARGE_CENTER.

Key Information Stored

The table contains 36 documented columns. The following are the most operationally significant:

No unique index is documented in the ETRM excerpt beyond the internal identifiers; the surrogate versus business-key distinction is therefore inferred from column semantics rather than declared constraints.

Common Use Cases and Queries

Typical usage centers on audit reconstruction and troubleshooting charge-line deletions. A common pattern joins the audit table back to its header and charge center for reconciliation reporting:

  • Reconstructing deleted charge lines for a given header using IT_HEADER_ID.
  • Reporting encumbrance reversals triggered by deletions via ENCUMBRANCE_FLAG and ENCUMBERED_AMOUNT.
  • Auditing funds-check failures via FAILED_FUNDS_LOOKUP_CODE and REJECTION_NOTE.
  • Comparing pre- and post-deletion balances against SET_OF_BOOKS_ID.

A representative query joins IGI_ITR_CHARGE_HEADERS on IT_HEADER_ID and IGI_ITR_CHARGE_CENTER on CHARGE_CENTER_ID, filtering by CREATION_DATE ranges to isolate deletions within a period.

Related Objects