Results for “account_cd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
View: IGS_FI_ACC 12.1.1
-
View: IGS_FI_FEE_TYPE_CI_H 12.1.1
APPS.IGS_FI_FEE_TYPE_CI_H·↳ IGS_FI_FEE_TYPE_CI_H_ALL·Explore IGS module →
-
This entity describes a Finance General Ledger account specific to a financial reporting period (financial period calendar instance).
-
This entity describes the periods of fee assessment fee calendar instances applicable to a fee type.
-
This entity describes special contract based fee assessment rates
-
APPS.IGS_FI_F_TYP_CA_INST_LKP_V·↳ IGS_CA_DA·↳ IGS_CA_DA_INST_V·↳ IGS_CA_GEN_001·Explore IGS module →
-
View: IGS_FI_F_TYP_CA_INST 12.1.1
APPS.IGS_FI_F_TYP_CA_INST·↳ IGS_FI_F_TYP_CA_INST_ALL·Explore IGS module →
-
VIEW: APPS.IGS_FI_CONTROL_V 12.1.1
-
View: IGS_FI_CONTROL_V 12.1.1
APPS.IGS_FI_CONTROL_V·↳ FND_CURRENCIES_TL·↳ GL_SETS_OF_BOOKS·↳ HR_OPERATING_UNITS·Explore IGS module →
-
View: IGS_FI_CONTROL_V 12.2.2
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_FI_CR_TYPES_V 12.1.1
-
View: IGS_FI_ACC 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_CR_TYPES_V 12.2.2
This view is created to be used in Credit Types form. All associated descriptions are obtained by joining with the setup tables.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_CR_ACTIVITIES_V 12.2.2
Retrieves the records from the Credit Activities table.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_FEE_TYPE_CI_H 12.2.2
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_CR_TYPES_V 12.1.1
This view is created to be used in Credit Types form. All associated descriptions are obtained by joining with the setup tables.
APPS.IGS_FI_CR_TYPES_V·↳ IGS_FI_ACC·↳ IGS_FI_A_HIERARCHIES·↳ IGS_FI_CR_TYPES·Explore IGS module →
-
VIEW: APPS.IGS_FI_REFUNDS_V 12.1.1
-
View: IGS_FI_CR_ACTIVITIES_V 12.1.1
Retrieves the records from the Credit Activities table.
APPS.IGS_FI_CR_ACTIVITIES_V·↳ IGS_FI_ACC·↳ IGS_FI_CR_ACTIVITIES·↳ IGS_LOOKUP_VALUES·Explore IGS module →
-
TABLE: IGS.IGS_FI_ACC_ALL 12.1.1
-
View: IGS_FI_OTC_CHARGES_V 12.2.2
The view contains information on the charges(of type external) that are created at the time of receipt creation.
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_FI_ACC 12.1.1
-
View: IGSFV_PARTY_REFUNDS 12.1.1
Stores all refund transactions, which have been created due to excess unapplied credits.
APPS.IGSFV_PARTY_REFUNDS·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IGS_CA_INST_ALL·Explore IGS module →
-
View: IGS_FI_F_TYP_CA_INST 12.2.2
Not implemented in this database·Explore IGS module →
-
Table: IGS_FI_DSBR_JNL_DTL 12.1.1
This entity describes the detail of a fee assessment income disbursement journal. Each detail is specific to an organisational unit, disbursed income account. -Obsolete
Not implemented in this database·Explore IGS module →
-
Table: IGS_OR_UNIT_AC 12.1.1
This entity describes the accounts in which funds are held for the nominated organisational unit.
Not implemented in this database·Explore IGS module →
-
Table: IGS_OR_UNIT_AC 12.2.2
This entity describes the accounts in which funds are held for the nominated organisational unit.
Not implemented in this database·Explore IGS module →
-
View: IGS_FI_REFUNDS_V 12.2.2
Contains all refund transactions which have been created due to excess unapplied credits along with information about payee.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PARTY_REFUNDS 12.2.2
Stores all refund transactions, which have been created due to excess unapplied credits.
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PARTY_CREDITS 12.2.2
Stores all Party Credits in Student Finance
Not implemented in this database·Explore IGS module →
-
VIEW: APPS.IGS_FI_ACC 12.1.1
-
Table: IGS_FI_DSBR_JNL_DTL 12.2.2
This entity describes the detail of a fee assessment income disbursement journal. Each detail is specific to an organisational unit, disbursed income account. -Obsolete
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PERSON_DEPOSITS 12.1.1
Stores all Student Deposits in Student Finance
APPS.IGSFV_PERSON_DEPOSITS·↳ GL_CODE_COMBINATIONS·↳ HZ_PARTIES·↳ IBY_PAYEE·Explore IGS module →
-
View: IGSFV_PERSON_DEPOSITS 12.2.2
Stores all Student Deposits in Student Finance
Not implemented in this database·Explore IGS module →
-
View: IGSFV_PARTY_CHARGES 12.2.2
Contains details of charges for a person
Not implemented in this database·Explore IGS module →