Results for “elimination_confirmed_flag”

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

Overview

IGS_FI_GL_PERIODS_V is a reporting view shipped with the Oracle Student System (IGS) product family, which Oracle classifies as obsolete in the 12.1.1 and 12.2.2 releases. Its stated purpose is to retrieve the accounting periods created in Oracle Financials — specifically the General Ledger module — so that Oracle Student System processes and reports can present General Ledger period information using Student System terminology and closing-status lookups. Rather than exposing the full General Ledger period table directly, the view filters it to the single application context owned by the Student System and joins it to the IGS lookup table, producing a clean, presentation-ready row set of valid, non-adjustment accounting periods.

Because the object belongs to an obsolete product, implementers on current releases will typically encounter it only in legacy customizations, historic extracts, or migration documentation. The metadata record notes that the object is not implemented in the reference database, so it should be treated as a historical definition rather than an actively supported interface.

Underlying Base Objects

The view text reveals two base objects, even though the ETRM column notes do not document referenced base objects:

• GL_PERIOD_STATUSES PER — the General Ledger table holding period definitions and their calendar/status attributes per set of books.
• IGS_LOOKUP_VALUES LKP — the Student System lookup table, used here with LOOKUP_TYPE = 'IGS_FI_CLOSING_STATUS' to translate the GL closing status code into a user-facing meaning.

The join is driven by three predicates. First, PER.APPLICATION_ID must equal 8405, the General Ledger application identifier registered for the Student System integration. Second, PER.ADJUSTMENT_PERIOD_FLAG must equal 'N', excluding adjustment periods from the result. Third, PER.CLOSING_STATUS is equated to LKP.LOOKUP_CODE, restricted to the IGS_FI_CLOSING_STATUS lookup type. The result set therefore represents open and closed accounting periods for the Student System's ledger only, with no adjustment periods and with status descriptions resolved.

Key Columns

The view projects nearly every descriptive attribute of GL_PERIOD_STATUSES. The most significant columns are:

• ROW_ID — the row identifier of the underlying GL_PERIOD_STATUSES record.
• APPLICATION_ID — always 8405 in this view's output, identifying the Student System ledger context.
• SET_OF_BOOKS_ID — the ledger (set of books) to which the period belongs.
• PERIOD_NAME — the accounting period name, such as JAN-25.
• CLOSING_STATUS and CLOSING_STATUS_MEANING — the GL status code and its IGS lookup meaning, e.g. Open or Closed.
• START_DATE, END_DATE, YEAR_START_DATE, QUARTER_START_DATE — the period and fiscal calendar boundaries.
• PERIOD_TYPE, PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM, EFFECTIVE_PERIOD_NUM — structural calendar attributes used for sequencing and reporting.
• ADJUSTMENT_PERIOD_FLAG — carried through for completeness, but always 'N' due to the view filter.
• ELIMINATION_CONFIRMED_FLAG — the column matching the user's search term. It originates in GL_PERIOD_STATUSES and indicates whether elimination entries for the period have been confirmed during consolidation processing.
• ATTRIBUTE1 through ATTRIBUTE5 and CONTEXT — the standard descriptive flexfield columns passed through unchanged.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on listing available accounting periods for a Student System ledger, resolving status descriptions, and checking consolidation-related flags. A representative query follows:

• SELECT period_name, closing_status_meaning, start_date, end_date, period_year, period_num, elimination_confirmed_flag FROM igs_fi_gl_periods_v WHERE set_of_books_id = :ledger_id ORDER BY period_year, period_num;
• Filtering to currently open periods: add WHERE closing_status_meaning = 'Open'.
• Auditing consolidation: SELECT period_name, elimination_confirmed_flag FROM igs_fi_gl_periods_v WHERE set_of_books_id = :ledger_id AND elimination_confirmed_flag = 'Y';

Because no base objects are formally documented in the ETRM record and the product is obsolete, any new development should validate the view's presence in the target database schema before use, and should confirm the meaning and permitted values of ELIMINATION_CONFIRMED_FLAG against the GL data dictionary for the specific release.