Search Results igs_fi_fin_lt_plan

Overview

The IGS_FI_FIN_LT_PLAN table is a core data object within the Oracle E-Business Suite (EBS) Student System (IGS) module. It serves as the master repository for defining and storing the rules governing finance and late fee charge plans. These plans are critical for automating the calculation and application of financial charges, such as late payment fees, against student accounts. The table's existence is fundamental to the financial operations of an educational institution within the EBS ecosystem, enabling the systematic enforcement of payment policies and the management of receivables.

Key Information Stored

The table's primary function is to define the parameters of a charge plan. While the full column list is not provided in the metadata, the documented foreign keys and primary key reveal its essential structure. The PLAN_NAME column acts as the unique identifier (Primary Key: IGS_FI_FIN_LT_PLAN_PK) for each defined plan. Crucially, the table establishes relationships to other master data entities: the FEE_TYPE column is a foreign key to IGS_FI_FEE_TYPE_ALL, linking the plan to a specific type of fee or charge. The SUBACCOUNT_ID column is a foreign key to IGS_FI_SUBACCTS_ALL, associating the plan with a specific financial sub-account for proper accounting and ledger posting. Other typical columns in such a table would include details like calculation methods, grace periods, charge amounts or percentages, effective dates, and status indicators.

Common Use Cases and Queries

This table is central to processes that assess financial penalties. A common use case is the batch job that evaluates overdue student invoices and automatically applies late fee charges based on the active plan linked to the original fee. For reporting and administration, typical queries involve listing all active plans or analyzing the parameters of a specific plan. Sample SQL to retrieve basic plan information with related master data might resemble:

• SELECT p.plan_name, f.fee_code, s.subaccount_code FROM igs_fi_fin_lt_plan p, igs_fi_fee_type_all f, igs_fi_subaccts_all s WHERE p.fee_type = f.fee_type_id AND p.subaccount_id = s.subaccount_id;

Data from this table is also essential for troubleshooting charge calculations and validating the setup of the institution's financial penalty rules.

Related Objects

The IGS_FI_FIN_LT_PLAN table is integrally connected to other key tables in the Student System's financial schema, as indicated by its foreign keys. The table IGS_FI_FEE_TYPE_ALL provides the valid fee types that can be associated with a late fee plan. The table IGS_FI_SUBACCTS_ALL provides the chart of accounts mapping for where the generated charges should be recorded. It is highly probable that this plan table is referenced by transactional tables that store the actual applied charges (e.g., an invoice lines table) and by program units (packages or procedures) within the IGS_FI_* schema that execute the charge calculation logic. Any interface or API that creates or updates late fee plans would ultimately read from or write to this table.