Search Results pe_res_status




Overview
Explore in AI Chat

Overview

IGS_FI_FTCI_ACCTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Student System (IGS) product family. Its name reflects its purpose: FTCI stands for Fee Type Course Instance Accounts, indicating that the view exposes account derivation records generated by the fee calculation engine for specific course or unit instances. In EBS 12.1.1 and 12.2.2 the view is used primarily for institutional reporting, reconciliation, and integration activities where fee account assignments must be presented alongside descriptive information about residency status, unit type, and the associated organizational unit.

The view is read-only and does not store data. It presents a denormalized, human-readable projection of the base account table, resolving coded values into their lookup meanings so that downstream reports, extracts, and interfaces do not need to perform their own joins to lookup tables.

Underlying Base Objects

Although the ETRM metadata does not document referenced base objects explicitly, the view text identifies three sources:

All joins to LKP and PUT are outer joins, so rows are retained even when the residency status code or unit type has no matching lookup or level record.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing residency-based fee account derivation, verifying that all residency statuses resolve to a PE_RES_STATUS lookup meaning, and extracting account assignments for financial reconciliation.

Sample query listing accounts by fee type with decoded residency status:

  • SELECT acct_id, fee_type, natural_account_segment, residency_status_cd, meaning, course_cd, unit_cd FROM apps.igs_fi_ftci_accts_v WHERE fee_type = :p_fee_type;

Sample query identifying rows where residency status is unmapped:

  • SELECT acct_id, residency_status_cd, fee_type FROM apps.igs_fi_ftci_accts_v WHERE meaning IS NULL;

Sample query filtering on unit level and audit period:

  • SELECT acct_id, unit_cd, level_code, last_update_date FROM apps.igs_fi_ftci_accts_v WHERE level_code = :p_level AND last_update_date >= :p_from_date;

Because the view depends on a PL/SQL function call per row, large-scale extracts should be filtered to limit the returned row set.