Search Results igs_fi_cr_types




Overview
Explore in AI Chat

Overview

IGS_FI_CR_TYPES is a multi-org filtered flat view owned by the APPS schema in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It is a reporting and integration artifact delivered within the IGS (Student System) product family, specifically the Financials subcomponent that governs student credit types, refunds, and forfeiture accounting. The view is valid in the data dictionary and exposes one row per credit type record visible to the current operating unit context. Its central design purpose is to enforce Oracle's multi-organization access security at query time, so that any form, concurrent program, or report selecting from the view automatically receives only those credit types belonging to the organization currently set in the session. The implementation achieves this by selecting from the base table IGS_FI_CR_TYPES_ALL and applying a WHERE clause over ORG_ID derived from the CLIENT_INFO session variable, which is populated by the Multi-Org initialization routines (FND_CLIENT_INFO). Because the filter uses NVL and DECODE on the first characters of USERENV('CLIENT_INFO'), records with a NULL ORG_ID are treated as globally visible and match the sentinel value -99, ensuring that shared or seed credit type definitions remain accessible regardless of the operating unit.

Underlying Base Objects

The view is defined exclusively over the table IGS_FI_CR_TYPES_ALL, which stores the full multi-org credit type definition set. The view text performs a straight column projection of all business columns from that table with no joins, unions, or aggregations; consequently the view is updateable in principle for many column types, although the recommended practice is to maintain records through the base table or the associated IGS forms. No other base tables, synonyms, or views are documented as referenced objects, and the ETRM metadata lists no additional dependencies. Because the view carries the _ALL table's org column, it participates in the standard Oracle multi-org model in which the _ALL table is the single source of truth and filtered views supply the row-level security layer.

Key Columns

The column list begins with ROWID followed by the primary key CREDIT_TYPE_ID, which uniquely identifies each credit type. Descriptive attributes include CREDIT_TYPE_NAME, DESCRIPTION, and CREDIT_CLASS, the latter categorizing the credit for downstream processing rules. Accounting integration is served by DR_ACCOUNT_CD and CR_ACCOUNT_CD plus their corresponding general ledger code combinations DR_GL_CCID and CR_GL_CCID; forfeiture accounting uses the parallel FORFEITURE_ACCOUNT_CD and FORFEITURE_GL_CCID. Effective dating is provided by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, with REFUND_ALLOWED and PAYMENT_PRIORITY controlling refund eligibility and application order. The ORG_ID column supplies the multi-org discriminator, while SUBACCOUNT_ID and PAYMENT_CREDIT_TYPE_ID link the credit type to subaccount and payment credit configurations. TITLE4_TYPE_IND identifies Title IV treatment for financial aid reporting. The twenty ATTRIBUTE columns (ATTRIBUTE_CATEGORY through ATTRIBUTE20) provide the standard Oracle descriptive flexfield storage. Audit columns include CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN. The column the user searched for, APPL_HIERARCHY_ID, appears at the end of the projection and associates the credit type with an application hierarchy definition used in admissions or fee assessment processing, allowing charges and credits to be mapped to a hierarchy node.

Common Use Cases and Queries

Typical uses include validating the credit types available to a given operating unit, reconciling credit type accounting mappings against the GL, and extracting configuration for migration or audit. A basic query is:

  • SELECT CREDIT_TYPE_ID, CREDIT_TYPE_NAME, CREDIT_CLASS, DR_GL_CCID, CR_GL_CCID FROM IGS_FI_CR_TYPES;
  • SELECT CREDIT_TYPE_NAME, REFUND_ALLOWED, PAYMENT_PRIORITY FROM IGS_FI_CR_TYPES ORDER BY PAYMENT_PRIORITY;
  • SELECT CREDIT_TYPE_ID, CREDIT_TYPE_NAME, APPL_HIERARCHY_ID FROM IGS_FI_CR_TYPES WHERE APPL_HIERARCHY_ID IS NOT NULL;
  • SELECT CREDIT_TYPE_NAME, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE FROM IGS_FI_CR_TYPES WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND NVL(EFFECTIVE_END_DATE, SYSDATE + 1);

Because the WHERE clause is applied automatically, these statements return only the rows for the session's operating unit, so queries intended for cross-org analysis should target IGS_FI_CR_TYPES_ALL directly under appropriate privileges. Users searching on APPL_HIERARCHY_ID should verify that the MULTI_ORG context has been initialized before running the query, otherwise the client info decode resolves to the -99 sentinel and only global records are returned.