Results for “igi_bud_ny_balances”

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

Overview

IGI_BUD_NY_BALANCES is a table owned by the IGI schema within the Oracle E-Business Suite release 12.1.1 and 12.2.2 environments. It belongs to the IGI - Public Sector Financials International product, the module that supports public-sector budgeting, fund accounting, and statutory financial reporting requirements. The table is documented with a VALID status and is described as containing information on next year's balances, meaning it stores forward-year budget amounts that have been extracted, rolled forward, or entered for planning purposes rather than the current approved budget picture.

From a data modeling perspective, the documented heuristic Data Vault classification for this object is standalone. In practice, this suggests that IGI_BUD_NY_BALANCES functions as a satellite-style fact store keyed by a composite business key, holding a single measurable attribute (NEXT_YEAR_BUDGET) qualified by accounting flexfield, budget version, ledger, currency, and period context. Because no foreign-key relationships are documented, it is treated as an independent balance container that integrates with the rest of the Financials schema primarily through shared key columns rather than enforced referential constraints.

Key Information Stored

The table contains six documented columns. The composite primary key is defined by the unique index IGI_BUD_NY_BALANCES_PK and comprises five columns, which together act as the business-key candidate for each stored balance:

• CODE_COMBINATION_ID — Identifies the accounting flexfield combination (the full chart-of-accounts string) to which the next-year balance applies.
• BUDGET_VERSION_ID — Identifies the budget version, such as an original appropriation, revised budget, or planning version, that owns the balance.
• SET_OF_BOOKS_ID — Identifies the ledger or set of books in which the balance is recorded.
• CURRENCY_CODE — The currency in which the next-year amount is denominated.
• PERIOD_NAME — The accounting period associated with the balance record.

The sixth and only non-key column is NEXT_YEAR_BUDGET, which holds the actual next-year budget amount. Because the table exposes no separate surrogate single-column identifier, the composite of the five key columns uniquely determines each row; implementers should treat all five as mandatory predicates in any lookup against this table.

Common Use Cases and Queries

IGI_BUD_NY_BALANCES is typically consumed for forward-year budget planning, comparison of current-year budgets against next-year projections, and public-sector reporting obligations that require multi-year visibility. A representative query filters by ledger, budget version, and accounting period to retrieve balances for a specific combination range:

SELECT code_combination_id, period_name, currency_code, next_year_budget FROM igi.igi_bud_ny_balances WHERE set_of_books_id = :p_sob AND budget_version_id = :p_version AND code_combination_id = :p_ccid;

Common reporting patterns include aggregating NEXT_YEAR_BUDGET by period or currency, joining to accounting flexfield and budget version views to render human-readable account descriptions, and extracting rows into spreadsheets for budget review cycles. Because the table carries no enforced foreign keys, deduplication and validity checks against the budget version and code combination master data are prudent before publishing results.

Related Objects

The documented metadata records this object as standalone, so no explicit foreign keys are catalogued. The most significant related objects are those that supply the key values stored in the composite primary key:

• GL_CODE_COMBINATIONS — supplies the account combination referenced by CODE_COMBINATION_ID.
• GL_BUDGET_VERSIONS — provides the budget version definition referenced by BUDGET_VERSION_ID.
• GL_SETS_OF_BOOKS (or GL_LEDGERS in 12.2.2) — provides ledger context for SET_OF_BOOKS_ID.
• GL_PERIODS and GL_PERIOD_STATUSES — provide the accounting period referenced by PERIOD_NAME.
• FND_CURRENCIES — resolves the CURRENCY_CODE value.
• Peer IGI budget tables such as current-year balance containers within the IGI - Public Sector Financials International module, which share the same ledger, combination, and version keys and are frequently joined for year-over-year comparisons.

Together these objects provide the master data needed to interpret and validate the forward-year balances held in IGI_BUD_NY_BALANCES.