Search Results igs_fi_acc




Overview
Explore in AI Chat

Overview

IGS_FI_ACC is a database view delivered within the Oracle E-Business Suite Student System (IGS) product family. In the ETRM metadata for release 12.2.2, the object is classified under the IGS - Student System module and carries an explicit "Obsolete" designation. It exposes financial account data maintained by the Student System's financials component, presenting one row per account record along with descriptive attributes and standard Oracle EBS audit columns.

The view performs a critical function common to multi-org (multi-organization) enabled IGS objects: it applies an operating unit filter at query time. Rather than presenting every account across all organizations, the view restricts the result set to records whose ORG_ID matches the organization identifier supplied through the USERENV('CLIENT_INFO') session context. This makes IGS_FI_ACC a reporting- and integration-safe interface, since it inherits the security and data segmentation behavior of the underlying _ALL table.

Underlying Base Objects

The view is defined solely over a single base table, IGS_FI_ACC_ALL. The "_ALL" suffix is the standard Oracle Applications convention indicating a table that stores rows for multiple operating units, with ORG_ID as the discriminating column. The view does not join to any additional IGS tables, nor does it incorporate lookups or reference data; it is a direct projection of selected columns from IGS_FI_ACC_ALL.

The view definition aliases the base table as "A" and exposes the table's ROWID as ROW_ID, which preserves a unique physical row identifier for update or drill-down operations. The WHERE clause is the only logic applied, and it compares the base table's ORG_ID to a value decoded from the CLIENT_INFO session variable, with a NVL wrapper and a sentinel value of -99 to handle null or uninitialized session contexts.

Key Columns

  • ROW_ID — The physical ROWID of the underlying IGS_FI_ACC_ALL row; useful for joins, updates, and Drilldown links.
  • FIN_CAL_TYPE — Financial calendar type, identifying which calendar the account's financial periods are based on.
  • FIN_CI_SEQUENCE_NUMBER — Financial calendar instance sequence number, tying the account to a specific calendar instance.
  • ACCOUNT_CD — The account code, the business-readable identifier for the financial account.
  • DESCRIPTION — Free-text description of the account.
  • CLOSED_IND — Indicator (typically Y/N) denoting whether the account is closed.
  • ACCOUNT_ID — Internal surrogate primary key for the account record.
  • ORG_ID — Operating unit identifier, the column used by the view's WHERE clause for data segmentation.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

The view is typically used for financial account validation, account listing in concurrent programs or reports, and integration extracts that must respect operating unit boundaries. A basic query selecting the active accounts for the current session's organization is:

SELECT account_cd, description, fin_cal_type, fin_ci_sequence_number
FROM igs_fi_acc
WHERE NVL(closed_ind, 'N') = 'N';

Because the view enforces ORG_ID filtering internally, callers generally do not add an explicit ORG_ID predicate; however, reports intending to display the organization explicitly may include it. A drill-down to the base table, or an update path, uses ROW_ID:

SELECT row_id, account_id, org_id, last_update_date
FROM igs_fi_acc
WHERE account_cd = :account_code;

Note that because the ETRM metadata marks this object as not implemented in the documented database and the product as obsolete, references to IGS_FI_ACC in 12.1.1 and 12.2.2 should be verified against the actual instance before use in new development.