Results for “igs_fi_closing_status”

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

Overview

APPS.IGS_FI_GL_PERIODS_V is a reporting view in the Oracle E-Business Suite financials/General Ledger schema area that exposes General Ledger accounting periods together with their decoded closing status. It is defined over GL_PERIOD_STATUSES, restricted to the Oracle application context (APPLICATION_ID = 8405), and joined to the IGS lookup table so that the coded closing status is returned with its human-readable meaning. The view presents one row per non-adjustment accounting period for the selected ledger/book, combining period calendar attributes (start date, end date, year start date, quarter information, period type and period year) with status and audit columns.

The object is commonly encountered when investigating the lookup type IGS_FI_CLOSING_STATUS, which controls the meaning of the CLOSING_STATUS column. Rather than navigating a raw code, consumers of this view receive the decoded MEANING alongside the code, which simplifies period-close reporting and integration extracts. Because it is a view and not a table, it carries no storage of its own and inherits the read consistency and privileges of the underlying objects.

Underlying Base Objects

The documented definition references two base objects:

• GL_PERIOD_STATUSES (aliased PER) — the General Ledger period status table, supplying the period name, set of books identifier, application identifier, dates, period numbering, adjustment period flag, elimination confirmation flag and audit columns. The view adds the predicate PER.APPLICATION_ID = 8405 and PER.ADJUSTMENT_PERIOD_FLAG = 'N', so only periods belonging to the specified application and excluding adjustment periods are returned.
• IGS_LOOKUP_VALUES (aliased LKP) — the lookup values table, supplying the descriptive MEANING for the closing status code. The join is PER.CLOSING_STATUS = LKP.LOOKUP_CODE with LKP.LOOKUP_TYPE = 'IGS_FI_CLOSING_STATUS', which is the source of the search term reported by users.

The ETRM metadata lists no additional referenced base objects. The view selects PER.ROWID, preserving row addressing for the driving period status rows, but does not expose any IGS_LOOKUP_VALUES columns beyond MEANING.

Key Columns

• ROWID — row identifier of the underlying GL_PERIOD_STATUSES record.
• APPLICATION_ID, SET_OF_BOOKS_ID — application context (fixed at 8405) and the ledger/book to which the period belongs.
• PERIOD_NAME — the accounting period name, the principal identifier in most reporting queries.
• CLOSING_STATUS and MEANING — the coded open/closed status and its decoded description from the IGS_FI_CLOSING_STATUS lookup. This pairing is central to period-close reporting.
• START_DATE, END_DATE, YEAR_START_DATE, QUARTER_START_DATE — calendar boundaries for the period and its surrounding year and quarter.
• QUARTER_NUM, PERIOD_TYPE, PERIOD_YEAR, EFFECTIVE_PERIOD_NUM, PERIOD_NUM — period sequencing and classification attributes.
• ADJUSTMENT_PERIOD_FLAG — returned for completeness although the view filters to 'N'.
• ELIMINATION_CONFIRMED_FLAG — indicates whether elimination entries for the period have been confirmed.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
• ATTRIBUTE1–ATTRIBUTE5, CONTEXT — descriptive flexfield context and segment columns passed through from GL_PERIOD_STATUSES.

Common Use Cases and Queries

Typical uses include period-close dashboards, status reconciliation between General Ledger and downstream modules, and extracts that must return a readable closing status rather than an internal code.

Listing all periods for a ledger with decoded status:

• SELECT period_name, closing_status, meaning, start_date, end_date FROM apps.igs_fi_gl_periods_v WHERE set_of_books_id = :ledger_id ORDER BY period_year, period_num;

Identifying open periods:

• SELECT period_name, meaning FROM apps.igs_fi_gl_periods_v WHERE set_of_books_id = :ledger_id AND closing_status = 'O';

Restricting by lookup meaning directly allows filtering by descriptive text from IGS_FI_CLOSING_STATUS, which is convenient when the numeric or alphabetic code is unknown. Because the view is filter-driven on APPLICATION_ID and ADJUSTMENT_PERIOD_FLAG, adjustment periods and other application contexts are never returned, so queries should not rely on it for a complete ledger period audit trail.