Results for “igs_fi_acc_all”

50+ results




Overview
Explore in AI Chat

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

Overview

IGS_FI_ACC_ALL is a core reference table in the Oracle E-Business Suite Student System (IGS) product family, present in both 12.1.1 and 12.2.2. It defines Finance General Ledger account definitions that are scoped to a specific financial reporting period, identified by a financial calendar instance. Each row associates a General Ledger account code with a particular financial calendar type and calendar instance sequence number, allowing institutions to maintain period-driven account configuration for tuition, fees, refunds, receivables, and related accounting events.

From a Data Vault modeling perspective, the FK topology around this table is classified heuristically as hub-leaning. IGS_FI_ACC_ALL behaves as a business-key reference hub: its natural key (ACCOUNT_CD, further qualified by financial calendar instance) is referenced by a large number of downstream transactional and configuration tables, but the table itself is populated from account setup rather than generated by transactional events. It should therefore be modeled as a hub with satellites carrying descriptive attributes, while the many referencing tables act as links and satellites.

Key Information Stored

The documented physical schema exposes 12 columns. The most operationally significant are:

  • ACCOUNT_CD — the business key column; also the single-column unique index IGS_FI_ACC_ALL_U1 and the basis of the primary key constraint IGS_FI_ACC_PK.
  • FIN_CAL_TYPE — the financial calendar type that scopes the account to a reporting calendar.
  • FIN_CI_SEQUENCE_NUMBER — the financial calendar instance sequence that ties the account to a specific reporting period.
  • ACCOUNT_ID — surrogate/GL identifier associated with the account code.
  • DESCRIPTION — descriptive text for the account definition.
  • CLOSED_IND — flag indicating whether the account is closed for the period.
  • ORG_ID — multi-org operating unit context, supporting the _ALL suffix convention.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS WHO columns used for auditing and concurrency.

The distinction between the surrogate primary key (IGS_FI_ACC_PK, anchored on ACCOUNT_CD) and the unique-index candidate IGS_FI_ACC_ALL_U1 on the same column is a design note worth flagging during integration: the account code is both the enforced business identifier and the constraint target.

Common Use Cases and Queries

Typical reporting and validation scenarios include resolving GL accounts for a given financial period, validating that account codes referenced by applications or control setups exist and are open, and driving posting logic for Student System financial integrations.

  • List active accounts for a calendar instance: 
    SELECT account_cd, description, fin_cal_type, fin_ci_sequence_number
FROM   igs.igs_fi_acc_all
WHERE  fin_cal_type = :cal_type
AND    fin_ci_sequence_number = :ci_seq
AND    closed_ind = 'N';
  • Detect orphan account references — for example, application records whose credit account has no matching definition: 
    SELECT a.application_id, a.cr_account_cd
FROM   igs.igs_fi_applications a
WHERE  NOT EXISTS (SELECT 1 FROM igs.igs_fi_acc_all f
                   WHERE f.account_cd = a.cr_account_cd);
  • Audit account assignment across control and refund setups by joining IGS_FI_CONTROL_ALL on REC_ACCOUNT_CD, REV_ACCOUNT_CD, CASH_ACCOUNT_CD, UNAPP_ACCOUNT_CD, REFUND_DR_ACCOUNT_CD, and REFUND_CR_ACCOUNT_CD.

Related Objects

IGS_FI_ACC_ALL is referenced through ACCOUNT_CD by a broad set of EBS Student System tables. The most significant dependents include:

Because the account code is a shared lookup across so many tables, changes to IGS_FI_ACC_ALL — particularly closing accounts via CLOSED_IND — propagate validation behavior throughout Student System financial processing.