Search Results igf_gr_alt_coa

Overview

IGF_GR_ALT_COA is a secure, multi-organization view owned by the APPS schema within the IGF (Financial Aid) product of Oracle E-Business Suite, valid across releases 12.1.1 and 12.2.2. The view presents alternate chart of accounts (COA) assignment records used by Financial Aid processing, exposing rows from the underlying intersection table that links enrollment statuses and calendar terms to a specific chart of accounts and validity date range. Its principal role is twofold: it provides a reporting and integration surface for approved COA mappings without requiring direct access to the base table, and it enforces row-level organization security through an ORG_ID predicate evaluated against the session's CLIENT_INFO context.

Underlying Base Objects

The view is defined exclusively over the base table IGF_GR_ALT_COA_ALL, aliased as GCOA in the view text. No other base objects are documented in the ETRM metadata. The naming convention of the base table (the _ALL suffix) indicates that it stores data across multiple operating units, while the view filters that data to the current organization. The filter compares each row's ORG_ID against the value parsed from USERENV('CLIENT_INFO'), defaulting both sides to -99 when the client information is blank or unavailable. Because the view selects the base table's ROWID along with all business columns, it is inherently non-updatable in the usual sense; DML must be directed at the underlying _ALL table. The view does not join to any other entity, so interpreted attributes such as calendar descriptions or enrollment status descriptions must be resolved separately by joining to their respective IGF lookup or calendar tables.

Key Columns

• ROW_ID — Pseudocolumn reflecting the base table ROWID; useful for identifying and later addressing the source row.
• ALTCOA_ID — Primary key of the alternate chart of accounts record, used to join back to the base table or related setup entities.
• ENRL_STAT — Enrollment status to which the alternate COA mapping applies, enabling COA determination based on a student's enrollment condition.
• CI_CAL_TYPE — Calendar type of the academic period associated with the mapping.
• CI_SEQUENCE_NUMBER — Sequence number identifying the specific calendar instance (term) within the calendar type.
• COA_START and COA_END — Effective start and end dates defining the validity window of the alternate COA assignment.
• ORG_ID — Operating unit identifier driving the view's organization security predicate.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording creation and last modification context.

Common Use Cases and Queries

The view is typically queried to validate which alternate chart of accounts is active for a given term and enrollment status within the user's operating unit, or to extract COA mappings for reporting and downstream integrations. A representative query retrieves active mappings for the current organization:

SELECT ALTCOA_ID, ENRL_STAT, CI_CAL_TYPE, CI_SEQUENCE_NUMBER, COA_START, COA_END
FROM APPS.IGF_GR_ALT_COA
WHERE TRUNC(SYSDATE) BETWEEN COA_START AND COA_END
ORDER BY CI_CAL_TYPE, CI_SEQUENCE_NUMBER;

Because the view already restricts rows by ORG_ID, callers do not add an organization predicate for security purposes, though an explicit ORG_ID filter may be applied for documentation clarity. To obtain descriptive text for enrollment status or calendar type, join the view to the appropriate IGF lookup views on ENRL_STAT and CI_CAL_TYPE respectively. For reconciliation, a DBA may compare the view's row count against IGF_GR_ALT_COA_ALL filtered to the same ORG_ID to confirm that organization security is functioning as expected. Note that, as with all CLIENT_INFO-based views, the session context must be initialized by the application before reliable results are returned; ad hoc queries run without that context will fall through to the -99 default and typically return no rows.