Results for “igi_gl_functional_balances_v”

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

Overview

The APPS.IGI_GL_FUNCTIONAL_BALANCES_V view is a reporting and integration object belonging to the IGI - Public Sector Financials International product. It is based on the General Ledger balances and sets of books tables, presenting balance figures that have been converted into the functional (set of books) currency. The view is registered as VALID in the APPS schema and is intended for use where functional-currency balances are required rather than solely entered-currency balances.

The view derives its name from its primary purpose: exposing balances in the functional currency of the ledger. Users searching for functional_period_net_dr are typically interested in the period net debit amount expressed in the functional currency, which distinguishes it from the entered-currency equivalent (ENTERED_PERIOD_NET_DR). Both columns are exposed by this view, allowing comparisons between entered and functional amounts.

Underlying Base Objects

The view text references GL_BALANCES as the driving table (aliased BA) joined implicitly to GL_SETS_OF_BOOKS (aliased SOB). The documented view metadata additionally lists DUAL as a referenced base object (via a synonym), reflecting the use of a packaged function call in the SELECT list.

Two packaged functions from GLR03300_PKG are invoked within the view:

• GLR03300_PKG.GET_PERIOD_NAME — resolves the period name associated with the balance row.
• GLR03300_PKG.GET_FACTOR — supplies a divisor applied to all monetary amounts, used to scale the stored balance figures.

Because the view is layered over GL_BALANCES, it inherits the balance grain of that table: one row per code combination, currency, actual flag, period, and related qualifiers such as encumbrance type, budget version, and translated flag.

Key Columns

• SET_OF_BOOKS_ID — taken from GL_SETS_OF_BOOKS, identifying the ledger.
• PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM — the accounting period attributes.
• CURRENCY_CODE, CODE_COMBINATION_ID, ACTUAL_FLAG — the balance dimensions carried from GL_BALANCES.
• ENCUMBRANCE_TYPE_ID, BUDGET_VERSION_ID, TRANSLATED_FLAG, TEMPLATE_ID — qualifiers that define the specific balance set being reported.
• ENTERED_PERIOD_NET_DR / ENTERED_PERIOD_NET_CR — period net debit and credit in entered currency, divided by the factor.
• FUNCTIONAL_PERIOD_NET_DR / FUNCTIONAL_PERIOD_NET_CR — period net debit and credit in functional currency. Their DECODE logic returns NULL where the row currency equals the set of books currency or is 'STAT', and otherwise uses the *_BEQ (base equivalent) columns from GL_BALANCES.
• ENTERED_QUARTER_TO_DATE, ENTERED_PROJECT_TO_DATE — quarter-to-date and project-to-date amounts derived from the balance columns.
• ROW_ID — the ROWID of the underlying balance row.

Common Use Cases and Queries

This view is used in reporting and integration where functional-currency balances are required. A typical query retrieves period net debits in the functional currency for a ledger and period:

• SELECT set_of_books_id, period_name, code_combination_id, currency_code, functional_period_net_dr, functional_period_net_cr FROM apps.igi_gl_functional_balances_v WHERE period_name = :period AND set_of_books_id = :sob;
• Reconciling entered versus functional amounts by selecting ENTERED_PERIOD_NET_DR and FUNCTIONAL_PERIOD_NET_DR side by side.
• Aggregating functional debits and credits across code combinations for a period or year-to-date reporting extract.
• Driving public-sector financial reporting that must reflect base-equivalent amounts for foreign-currency and statistical balances.

Because the view calls GLR03300_PKG functions per row, query performance depends on indexing of GL_BALANCES and on restricting the result set by ledger, period, and balance qualifiers.