Results for “igi_com_sob_link_v”

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

Overview

IGI_COM_SOB_LINK_V is a public-sector reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the IGI (Public Sector Financials International) product family and resolves the relationship between a source and a target set of books (ledger) as recorded by the IGI_COM_SOB_LINK configuration table. The view denormalizes the numeric identifiers stored in IGI_COM_SOB_LINK into the human-readable set-of-books names held in GL_SETS_OF_BOOKS, and also exposes the encumbrance flag that qualifies the linkage. Its primary role is to support public-sector commitment-control and cross-ledger processes, where transactions, budgets, or commitments posted in one set of books must be recognized against another. Rather than joining IGI_COM_SOB_LINK to GL_SETS_OF_BOOKS manually, forms, concurrent programs, and reporting tools query this view to obtain the source ledger, target ledger, and the encumbrance (commitment) setting in a single row. The object is documented as VALID in the ETRM repository, indicating that its compiled definition is consistent and queryable at runtime.

Underlying Base Objects

The view is defined over two base objects, both accessed through synonyms in the APPS schema: IGI_COM_SOB_LINK and GL_SETS_OF_BOOKS. In the 12.2.2 documented metadata, the referenced objects are resolved as GL_SETS_OF_BOOKS_11I and IGI_COM_SOB_LINK. The GL_SETS_OF_BOOKS synonym is referenced twice in the view text—once aliased SOURCE and once aliased TARGET—so that both the source and the target set-of-books names can be returned from the same lookup table. IGI_COM_SOB_LINK is also referenced twice, as LINK and LINK2; the LINK2 instance enforces that the target ledger of one linkage itself participates as a source ledger, restricting output to reciprocal or chain-consistent configurations. The join predicates equate SOURCE.SET_OF_BOOKS_ID and TARGET.SET_OF_BOOKS_ID to LINK.SOURCE_SET_OF_BOOKS_ID and LINK.TARGET_SET_OF_BOOKS_ID respectively, while LINK2.SOURCE_SET_OF_BOOKS_ID is equated to LINK.TARGET_SET_OF_BOOKS_ID.

Key Columns

• ROW_ID — the ROWID of the underlying IGI_COM_SOB_LINK row, useful for direct row identification and update correlation.
• SOURCE_SOB_NAME / TARGET_SOB_NAME — names of the source and target sets of books, derived from GL_SETS_OF_BOOKS.NAME.
• ENCUMBRANCE_FLAG — the encumbrance (commitment) indicator carried on the linkage record, matching the user's search term; it signals whether commitment control is enabled for the pairing.
• SOURCE_SOB_ID / TARGET_SOB_ID — numeric set-of-books identifiers from IGI_COM_SOB_LINK, the join keys to GL_SETS_OF_BOOKS.
• CHART_OF_ACCOUNTS_ID, CURRENCY_CODE, PERIOD_SET_NAME — accounting structure attributes taken from the source set of books.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns inherited from the base linkage table.

Common Use Cases and Queries

Typical usage includes validating ledger linkages during public-sector implementation, driving commitment-control setup, and producing cross-ledger reconciliation reports. A common query filters on the encumbrance flag:

SELECT source_sob_name, target_sob_name, encumbrance_flag
FROM apps.igi_com_sob_link_v
WHERE encumbrance_flag = 'Y';

Another pattern joins the view to transaction or budget data by SOURCE_SOB_ID to enrich reports with ledger names and currency. Because the view already enforces the LINK2 consistency restriction, results reflect only linkages where the target ledger is itself a valid source, which is appropriate for recursive funding and commitment flows. Analysts should note that only the source ledger's chart of accounts, currency, and period set are exposed; target-ledger attributes require an additional join to GL_SETS_OF_BOOKS.