Search Results igi_itr_charge_headers_pk




Overview
Explore in AI Chat

Overview

IGI.IGI_ITR_CHARGE_HEADERS is a Public Sector Financials International (IGI) table that holds charge header details within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the parent record for intercompany and intrastate charge transactions, capturing the financial, organizational, and descriptive attributes of a charge event before it is broken down into individual charge lines. Each header represents a single charge submission, identified by the surrogate primary key IT_HEADER_ID and constrained by the unique index IGI_ITR_CHARGE_HEADERS_PK.

The table sits at the center of a hub-and-spoke relationship model. While it acts as a hub referenced by several downstream tables, it also holds foreign keys to GL_ENCUMBRANCE_TYPES, PSB_EMPLOYEES, and IGI_ITR_CHARGE_CENTER, giving it link-like characteristics. From a Data Vault modeling perspective, the mined classification is hub-leaning: the surrogate key IT_HEADER_ID anchors the business entity, and the descriptive and foreign-key columns would typically be modeled as satellite attributes or link relationships.

Key Information Stored

The 23 documented columns cover identification, accounting, and submission attributes. The most significant include:

Only IT_HEADER_ID is documented as a unique index candidate; other columns serve as foreign keys or descriptive attributes rather than alternate business keys.

Common Use Cases and Queries

Typical usage centers on reporting charge submissions, reconciling encumbrances, and tracing charge lines. A common query retrieves headers for a given ledger and period:

  • SELECT h.it_header_id, h.name, h.entered_dr, h.entered_cr FROM igi_itr_charge_headers h WHERE h.set_of_books_id = :p_sob AND h.it_period_name = :p_period;
  • Joining to lines: SELECT l.* FROM igi_itr_charge_headers h, igi_itr_charge_lines l WHERE h.it_header_id = l.it_header_id;
  • Resolving descriptions through employees or charge centers via EMPLOYEE_ID and CHARGE_CENTER_ID.
  • Filtering pending submissions using SUBMIT_FLAG for workflow monitoring dashboards.

Related Objects