Results for “igi_bud_gl_interface_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGI_BUD_GL_INTERFACE_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGI — Public Sector Financials International product. The view exposes budget-related journal data staged in the Oracle General Ledger interface table together with accounting period status information. Its documented description states that it is "Based on GL_INTERFACE and GL_PERIOD_STATUSES," with FND_APPLICATION also referenced as an underlying object. In the context of federal and public sector budgeting, this view provides a consolidated read interface over the GL_INTERFACE staging area, allowing budget journals, encumbrances, and related accounting entries to be examined before and after they are posted to the General Ledger. Because it presents the raw GL_INTERFACE row set alongside period status data and standard interface status columns, it functions as both a reconciliation surface and a diagnostic aid for budget integration processes. The view is marked VALID in the ETRM metadata and is available in both EBS 12.1.1 and 12.2.2, the two releases addressed here.

Underlying Base Objects

The documented base objects for this view are GL_INTERFACE, GL_PERIOD_STATUSES, and FND_APPLICATION, accessed through synonyms in the APPS schema. GL_INTERFACE is the standard General Ledger open interface table that receives journal lines from feeder systems — including encumbrance, budgetary, and subledger sources — and holds them until Journal Import processes them. Each row carries a STATUS flag (NEW, IMPORTED, or similar) indicating its import state, and the view exposes that flag directly. GL_PERIOD_STATUSES supplies accounting period and period-status context, which allows period-level validation and reporting, such as confirming whether a period is open or closed for a given set of books. FND_APPLICATION provides application identification for the interface rows, supporting multi-application environments. The view is therefore a relatively thin projection: it does not introduce material transformations but re-presents GL_INTERFACE's column set with the period-status join and interface diagnostics intact.

Key Columns

The view exposes the complete GL_INTERFACE column list, including:

• STATUS — the import disposition of the interface row (for example, NEW before import).
• STATUS_DESCRIPTION — textual description of the status.
• WARNING_CODE and STAT_AMOUNT — the warning assigned during Journal Import and the associated statistical amount; these are frequently queried to identify rows that imported with warnings rather than cleanly.
• SET_OF_BOOKS_ID, PERIOD_NAME, ACCOUNTING_DATE, CURRENCY_CODE, DATE_CREATED — core accounting and timing attributes.
• ACTUAL_FLAG, ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID — distinguish actual, budget, and encumbrance entries, which is central to budget-control reporting.
• ENTERED_DR/ENTERED_CR and ACCOUNTED_DR/ACCOUNTED_CR — entered and accounted debit/credit amounts.
• SEGMENT1 through SEGMENT30 — the accounting flexfield segments.
• REFERENCE1 through REFERENCE30 — free reference fields used by feeder systems.
• JE_BATCH_ID, JE_HEADER_ID, JE_LINE_NUM, GROUP_ID, REQUEST_ID — identifiers linking rows to batches, headers, concurrent requests, and grouping logic.

Common Use Cases and Queries

Typical uses include reconciling budget and encumbrance lines staged for Journal Import, diagnosing rows that imported with warnings, and reporting on period-open budget activity. A representative query lists unresolved interface rows:

• SELECT period_name, status, warning_code, entered_dr, entered_credit, reference1 FROM igi_bud_gl_interface_v WHERE status = 'NEW' AND set_of_books_id = :sob;
• SELECT je_batch_id, COUNT(*), SUM(entered_dr) FROM igi_bud_gl_interface_v WHERE actual_flag = 'E' GROUP BY je_batch_id;

Because WARNING_CODE and STATUS_DESCRIPTION are exposed, the view is especially useful for troubleshooting Journal Import outcomes within the IGI budget integration flow.