Search Results igi_itr_charge_headers_tmp




Overview
Explore in AI Chat

Overview

IGI_ITR_CHARGE_HEADERS_TMP is a temporary staging table in the IGI (Public Sector Financials International) product family of Oracle E-Business Suite. Its documented purpose is to hold charge header details. In the EBS architecture, the "_TMP" suffix denotes a transient working area that accepts intermediate charge header rows during an inbound interface, batch validation, or concurrent program run before the data is committed to the permanent transaction tables. This pattern is characteristic of the IGI inter-agency and intra-governmental transfer (ITR) processing flow, where charge information captured from feeder systems is validated, corrected, and then transferred into the base charge headers table.

The table resides in the IGI schema with 23 documented columns in the 12.2.2 physical schema, and its status is VALID in both 12.1.1 and 12.2.2 environments. Data Vault classification derived heuristically from the foreign-key structure indicates a standalone classification, suggesting that, for modeling purposes, this object is best treated as an independent staging entity rather than as a hub, link, or satellite within a governed Data Vault model. Its transient nature means it should generally be excluded from persistent warehouse layers or loaded only into a staging schema.

Key Information Stored

The table's surrogate and primary-key candidate is IT_HEADER_ID, which also carries a foreign-key relationship to IGI_ITR_CHARGE_HEADERS, indicating that each staging row is intended to reconcile to a definitive charge header record. The principal business and accounting attributes are:

Common Use Cases and Queries

The most frequent use is pre-transfer validation: identifying staging rows that are ready for commit versus those pending correction. A typical query filters on the submit indicator and period:

  • SELECT it_header_id, name, it_period_name, entered_dr, entered_cr FROM igi_itr_charge_headers_tmp WHERE submit_flag = 'Y';
  • Reconciliation against the permanent table: SELECT t.it_header_id FROM igi_itr_charge_headers_tmp t, igi_itr_charge_headers h WHERE t.it_header_id = h.it_header_id;
  • Referential integrity checks by joining ENCUMBRANCE_TYPE_ID, EMPLOYEE_ID, and CHARGE_CENTER_ID to their parent tables to detect orphaned staging rows before submission.
  • Period-close reporting that aggregates ENTERED_DR and ENTERED_CR by SET_OF_BOOKS_ID and IT_PERIOD_NAME.

Related Objects

  • IGI_ITR_CHARGE_HEADERS – joined on IT_HEADER_ID; the permanent charge header target.
  • GL_ENCUMBRANCE_TYPES – joined on ENCUMBRANCE_TYPE_ID for budgetary encumbrance validation.
  • PSB_EMPLOYEES – joined on EMPLOYEE_ID to resolve the responsible employee.
  • IGI_ITR_CHARGE_CENTER – joined on CHARGE_CENTER_ID for charge center attribution.
  • GL_CODE_COMBINATIONS – referenced indirectly through CODE_COMBINATION_ID for account validation.