Results for “igi_ar_journal_interim”

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

Overview

IGI_AR_JOURNAL_INTERIM is a table owned by the IGI schema (IGI – Public Sector Financials International) in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description identifies it as a copy of AR_JOURNAL_INTERIM_ALL, used by the ARC (Accounting Reconciliation/Public Sector accounting) and CBR (Budgetary Control) processes. In practice it serves as a staging table for Receivables journal entry lines that must be validated, enriched, and converted into General Ledger journal entries under public-sector accounting rules.

When a subledger journal is generated by Receivables (AutoInvoice, AutoAccounting, or manual entry), rows are inserted into an interim journal table so they can be edited, validated, and eventually posted to GL. IGI_AR_JOURNAL_INTERIM mirrors that structure but carries IGI-specific extensions such as encumbrance type, budgetary amounts, warning codes, and statutory reporting columns required by public sector deployments. Data is transient rather than historical — records exist between creation and transfer to GL, after which they are typically purged or archived.

From a Data Vault modeling perspective, the mined FK structure classifies this object as standalone — that is, a heuristic suggestion of a standalone satellite rather than a hub or link. It does not own a natural business key of its own; instead it is keyed by surrogate identifiers (JE_HEADER_ID, JE_LINE_NUM, INTERFACE_RUN_ID) that reference the parent GL journal structures.

Key Information Stored

The table contains 93 documented columns in 12.2.2. The most significant fall into four groups:

• Journal identity and grouping: JE_HEADER_ID, JE_LINE_NUM, JE_BATCH_ID, JE_SOURCE_NAME, JE_CATEGORY_NAME, PERIOD_NAME, INTERFACE_RUN_ID. These define the batch/header/line hierarchy and the source category used at import into GL.
• Accounting and amounts: SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID, CODE_COMBINATION_ID, ACCOUNTING_DATE, TRANSACTION_DATE, CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR, STAT_AMOUNT.
• Currency conversion and encumbrance: CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID, ACTUAL_FLAG.
• Flexfield and descriptive references: SEGMENT1 through SEGMENT30 (note SEGMENT8 appears later in the column list), REFERENCE1 through REFERENCE30, ORG_ID, WARNING_CODE, STATUS, STATUS_DESCRIPTION.

The table has no documented primary key or unique index in the ETRM metadata; combination candidates for business identity include JE_HEADER_ID + JE_LINE_NUM, or INTERFACE_RUN_ID + JE_LINE_NUM. Two foreign keys are documented: ENCUMBRANCE_TYPE_ID → GL_ENCUMBRANCE_TYPES and CHART_OF_ACCOUNTS_ID → GL_MGT_SEG_UPGRADE_H. The latter is an upgrade support reference.

Common Use Cases and Queries

Typical use cases are diagnostic and reconciliation oriented: identifying lines that failed transfer to GL, verifying currencies and conversions, and validating budgetary/encumbrance treatment before posting.

• Find unposted/failed lines: SELECT j.JE_HEADER_ID, j.JE_LINE_NUM, j.STATUS, j.STATUS_DESCRIPTION, j.WARNING_CODE FROM IGI_AR_JOURNAL_INTERIM j WHERE j.INTERFACE_RUN_ID = :run_id AND (j.STATUS IS NULL OR j.WARNING_CODE IS NOT NULL);
• Reconcile entered vs accounted amounts per period: SELECT j.PERIOD_NAME, SUM(j.ENTERED_DR - j.ENTERED_CR) ENTERED_NET, SUM(j.ACCOUNTED_DR - j.ACCOUNTED_CR) ACCOUNTED_NET FROM IGI_AR_JOURNAL_INTERIM j GROUP BY j.PERIOD_NAME;
• Join to GL encumbrance types: SELECT j.JE_HEADER_ID, e.ENCUMBRANCE_TYPE_ID, e.ENCUMBRANCE_TYPE FROM IGI_AR_JOURNAL_INTERIM j, GL_ENCUMBRANCE_TYPES e WHERE j.ENCUMBRANCE_TYPE_ID = e.ENCUMBRANCE_TYPE_ID;
• Category-level balance reporting using JE_CATEGORY_NAME, SET_OF_BOOKS_ID, and ORG_ID to produce budgetary execution reports.

Related Objects

• AR_JOURNAL_INTERIM_ALL — the base Oracle Receivables table from which this IGI copy is derived.
• GL_ENCUMBRANCE_TYPES — referenced via ENCUMBRANCE_TYPE_ID for encumbrance classification.
• GL_MGT_SEG_UPGRADE_H — referenced via CHART_OF_ACCOUNTS_ID during the 12.x upgrade path.
• GL_INTERFACE / GL_JE_HEADERS / GL_JE_LINES — destination tables reached after the interim rows are validated and posted.
• GL_CODE_COMBINATIONS — resolved through CODE_COMBINATION_ID for account validation.
• IGI_AR_JOURNAL_INTF-related ARC/CBR programs — the concurrent processes that populate, validate, and transfer from this table.