Search Results igi_itr_charge_lines_tmp




Overview
Explore in AI Chat

Overview

IGI_ITR_CHARGE_LINES_TMP is a temporary staging table owned by the IGI schema (Public Sector Financials International) in Oracle E-Business Suite 12.1.1 and 12.2.2. As its name and description indicate, it holds details of individual charge lines that are processed by the Intercompany Transaction Reconciliation (ITR) and charge allocation functionality. The table acts as a transient repository: rows are populated during charge calculation, validation, encumbrance checking, and posting, then consumed by concurrent programs that move validated lines into permanent charge and journal structures. It is a standalone object from a heuristic Data Vault perspective — it is neither a pure hub nor a link, and while it contains surrogate keys and date stamps, it is better modeled as a temporary satellite/staging area rather than a durable entity. Because the table is temporary in nature, records should be treated as an intermediate stage between charge generation and final general ledger posting.

Key Information Stored

The table contains 43 documented columns. The principal identifier is IT_SERVICE_LINE_ID, which serves as the surrogate primary key for each charge line. IT_HEADER_ID is the foreign key to the charge header and, together with IT_LINE_NUM, forms the most likely business-key candidate for a line within a run. Key columns fall into several groups:

Common Use Cases and Queries

Typical usage centers on monitoring and reconciliation. A common query retrieves unposted lines awaiting encumbrance or journal creation:

  • SELECT it_service_line_id, it_header_id, entered_dr, entered_credits, status_flag FROM igi.igi_itr_charge_lines_tmp WHERE posting_flag = 'N' AND encumbrance_flag = 'Y';
  • Join to headers to report charge totals by run: SELECT h.it_header_id, SUM(l.suggested_amount) FROM igi.igi_itr_charge_lines_tmp l, igi.igi_itr_charge_headers h WHERE l.it_header_id = h.it_header_id GROUP BY h.it_header_id;
  • Identify rejected or failed-funds lines: SELECT * FROM igi.igi_itr_charge_lines_tmp WHERE rejection_note IS NOT NULL OR failed_funds_lookup_code IS NOT NULL;
  • Encumbrance aging: filter on GL_ENCUMBERED_PERIOD_NAME and GL_ENCUMBERED_DATE.

Related Objects

Documented foreign keys link this table to its charge configuration and header parents; additional dependencies exist through application logic.

Because rows are temporary, purging programs and concurrent charge processors frequently delete or transfer records after successful posting, making this table unsuitable as a long-term audit source.