Search Results igs_fi_ftci_accts_uk1

Overview

The table IGS_FI_FTCI_ACCTS is a core data object within the Oracle E-Business Suite Student System (IGS) for releases 12.1.1 and 12.2.2. It serves a critical financial accounting function by storing the mapping rules between student fee assessments and the corresponding General Ledger (GL) revenue accounts. Specifically, it holds the Revenue Account Code or the Natural Account Segment for a given combination of academic and demographic attributes linked to a Fee Type Calendar Instance. This table enables the automated and accurate posting of student fee transactions to the correct accounting flexfields, ensuring financial integrity and compliance within the institution's chart of accounts.

Key Information Stored

The table's structure is designed to capture the specific context of a fee assessment to determine the appropriate revenue account. Its primary key is a surrogate key, ACCT_ID. A unique key (IGS_FI_FTCI_ACCTS_UK1) enforces business logic by combining FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and ORDER_SEQUENCE. The ORDER_SEQUENCE is crucial for defining the precedence of multiple accounting rules for the same fee instance. The most significant data columns include REV_ACCOUNT_CD, which points to the specific accounting code in IGS_FI_ACC_ALL. The table also stores a wide array of foreign key attributes—such as UNIT_CD, COURSE_CD, ATTENDANCE_MODE, and LOCATION_CD—that define the qualifying conditions for the account rule. This allows for highly granular account determination based on the student's program, unit, location, and mode of attendance.

Common Use Cases and Queries

The primary use case is during the student fee assessment and invoicing process, where the system queries this table to identify the correct GL account for a charge. A typical query would join the fee assessment transaction data with IGS_FI_FTCI_ACCTS on the contextual attributes, filtering by the specific Fee Type Calendar Instance and ordering results by ORDER_SEQUENCE to find the first applicable rule. For reporting and reconciliation, administrators often query this table to audit or list all accounting rules defined for a particular fee type or academic period. A sample SQL pattern to find the revenue account for a specific unit offering would be:

• SELECT rev_account_cd FROM igs_fi_ftci_accts WHERE fee_type = :p_fee_type AND fee_cal_type = :p_cal_type AND fee_ci_sequence_number = :p_ci_seq AND uoo_id = :p_uoo_id ORDER BY order_sequence;

Data fixes or implementations often involve inserting or updating records in this table to correct misposted revenue or to configure new accounting rules for novel fee scenarios.

Related Objects

IGS_FI_FTCI_ACCTS has extensive relationships with other Student System tables, as documented by its foreign keys. It is centrally linked to the Fee Type Calendar Instance (IGS_FI_F_TYP_CA_INST_ALL) via the composite key (FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER). The account code itself is validated against IGS_FI_ACC_ALL. Its contextual attributes reference fundamental academic structures: unit offerings (IGS_PS_UNIT_OFR_OPT_ALL), course and unit versions (IGS_PS_VER_ALL, IGS_PS_UNIT_VER_ALL), unit classifications (IGS_AS_UNIT_CLASS_ALL), and attendance details (IGS_EN_ATD_MODE_ALL, IGS_EN_ATD_TYPE_ALL). It also references location (IGS_AD_LOCATION_ALL) and unit level/type tables (IGS_PS_UNIT_LEVEL_ALL, IGS_PS_UNIT_TYPE_LVL). This web of relationships underscores its role as a nexus between the financial, curricular, and demographic domains within the application.