Search Results igs_fi_dsb_dtl_alc




Overview
Explore in AI Chat

Overview

The IGS_FI_DSB_DTL_ALC table is a core data entity within the Oracle E-Business Suite (EBS) Student System (IGS), specifically in the financial modules. Its primary function is to store the allocation details for income disbursement journal entries related to student fee assessments. This table plays a critical role in tracking how revenue from assessed fees is distributed and allocated across different financial dimensions, such as organizational units and account codes, for reporting and reconciliation. It is important to note that the ETRM documentation explicitly marks this table, and the entire IGS product, as Obsolete. Furthermore, the metadata states it was "Not implemented in this database," indicating it may not be present in standard deployments of EBS 12.1.1 or 12.2.2, or its functionality has been superseded by other objects in later releases.

Key Information Stored

The table's structure is defined by its composite primary key and a set of foreign keys linking to related transactional and master data. The primary key uniquely identifies an allocation record through a combination of the fee assessment identifier and a sequence: FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, CREATE_DT, and SEQUENCE_NUMBER. Key columns for data storage include FIN_CAL_TYPE and FIN_CI_SEQUENCE_NUMBER, which identify the financial calendar period for the allocation. The ORG_UNIT_CD, OU_START_DT, ACCOUNT_CD, and CLASSIFICATION_CD columns define the financial dimensions (cost center, account, etc.) to which the disbursed amount is allocated. The PERSON_ID, COURSE_CD, and UNIT_CD columns link the allocation to specific students and their academic attempts, enabling detailed analysis by student and program.

Common Use Cases and Queries

Given its obsolete status, direct operational use in active systems is unlikely. Historically, its purpose was to support financial reporting and audit trails for fee revenue distribution. Analytical queries would have joined this table to student and fee master data to answer questions about revenue allocation. A sample reporting pattern might have involved aggregating allocated amounts by organizational unit and account.

  • Revenue Allocation Report: SELECT org_unit_cd, account_cd, SUM(allocated_amount) FROM igs_fi_dsb_dtl_alc WHERE fin_cal_type = '&CAL_TYPE' GROUP BY org_unit_cd, account_cd;
  • Disbursement Detail for a Fee Assessment: SELECT * FROM igs_fi_dsb_dtl_alc WHERE fee_type = '&FEE_TYPE' AND fee_cal_type = '&CAL_TYPE' AND fee_ci_sequence_number = &SEQ_NUM ORDER BY sequence_number;

Consultants encountering references to this table should treat it as legacy and verify the current data model and supported APIs for any related financial disbursement processes.

Related Objects

The table's integrity is maintained through defined foreign key relationships, as documented in the ETRM metadata. These relationships connect the allocation detail to its parent transaction and relevant master data tables.

  • IGS_FI_DSB_SPSHT_DTL: Links via FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, CREATE_DT, FIN_CAL_TYPE, FIN_CI_SEQUENCE_NUMBER, ACCOUNT_CD, ORG_UNIT_CD, OU_START_DT, and CLASSIFICATION_CD. This is likely the parent disbursement spreadsheet detail record.
  • IGS_FI_FEE_DSBR_FML: Links via FEE_TYPE, FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER, and FORMULA_NUMBER, connecting to the fee disbursement formula used.
  • HZ_PARTIES: Links via PERSON_ID, providing the master party information for the student.
  • IGS_EN_STDNT_PS_ATT_ALL: Links via PERSON_ID and COURSE_CD, connecting to the student's program attempt.
  • IGS_EN_SU_ATTEMPT_ALL: Links via PERSON_ID, COURSE_CD, UNIT_CD, TEACH_CAL_TYPE, and TEACH_CI_SEQUENCE_NUMBER, connecting to the specific student unit attempt.