Results for “igi_eer_setup_v”

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

Overview

IGI_EER_SETUP_V is an APPS-owned database view within the Oracle E-Business Suite product family IGI – Public Sector Financials International. It exists to present end-user-meaningful descriptions of the multi-level account segment configuration stored in the underlying IGI_EER_SETUP table, resolving each stored segment identifier into a chart-of-accounts segment name and its corresponding application column name. The view is documented as VALID in ETRM 12.2.2 and is available in both 12.1.1 and 12.2.2 releases.

This view supports the IGI "EER" (Expenditure/Revenue or external reporting) setup functionality, which associates up to six chart-of-accounts segments with a given set of books. Rather than requiring implementers and reporting authors to join to FND_ID_FLEX_SEGMENTS six times individually, the view delivers a flattened, descriptive result set. It therefore acts as a reporting and integration convenience layer, typically consumed by custom reports, extracts, and downstream public-sector financials processes that must interpret the EER setup in human-readable form.

Underlying Base Objects

The view is defined over three documented referenced objects:

• IGI_EER_SETUP (SYNONYM) – the primary configuration table holding the set of books and the level 1 through level 6 segment numbers. This is the driving table of the view (aliased EER).
• GL_SETS_OF_BOOKS (VIEW) – the General Ledger set of books definition (aliased SOB), used to obtain the set of books name and the associated chart of accounts identifier.
• FND_ID_FLEX_SEGMENTS (SYNONYM) – the flexfield segment definition table (aliased FND1 through FND6), joined once per level to translate each stored segment number into a segment name and application column.

The join conditions link EER.GL_SET_OF_BOOKS_ID to SOB.SET_OF_BOOKS_ID, and each FNDn.ID_FLEX_NUM to SOB.CHART_OF_ACCOUNTS_ID with ID_FLEX_CODE = 'GL#' and FNDn.SEGMENT_NUM equal to the corresponding EER.LEVEL_n value. The view is defined with SELECT DISTINCT.

Key Columns

• ROW_ID – the ROWID of the underlying IGI_EER_SETUP row.
• GL_SET_OF_BOOKS_ID – identifier of the associated set of books.
• D_SOB_NAME – the descriptive name of the set of books (from GL_SETS_OF_BOOKS.NAME).
• COA_ID – the chart of accounts flexfield identifier.
• LEVEL_1 … LEVEL_6 – the configured segment numbers for each EER level.
• D_NAME_1 … D_NAME_6 – the descriptive segment names corresponding to each level.
• LEVEL_1_SEG … LEVEL_6_SEG – the flexfield application column names for each level.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – standard WHO audit columns inherited from IGI_EER_SETUP.

For levels 5 and 6, DECODE expressions substitute an empty string when the level is NULL, preventing a null segment name or column from being exposed.

Common Use Cases and Queries

Typical usage includes validating EER setup against the chart of accounts, driving EER-aware reports, and exporting configuration for documentation or migration.

SELECT sob_name, level_1, d_name_1, level_2, d_name_2
FROM   apps.igi_eer_setup_v
WHERE  gl_set_of_books_id = :p_sob_id;

Resolving the segment column names for a given setup:

SELECT d_sob_name,
       level_1_seg, level_2_seg, level_3_seg,
       level_4_seg, level_5_seg, level_6_seg
FROM   apps.igi_eer_setup_v
ORDER  BY d_sob_name;

Because the view already joins GL_SETS_OF_BOOKS and all segment definitions, queries against it avoid repetitive manual joins and return directly usable descriptive data for integration and reporting purposes.