Search Results plan_line_num

Overview

The IGS_FI_PP_TMPL_LNS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as the detailed line-level repository for payment plan templates. These templates define the schedule of payments—specifying amounts, percentages, and due dates—that students can be assigned for their financial obligations. The table's primary role is to store the configurable installment rules that constitute a payment plan template, enabling the systematic billing and collection of tuition and fees.

Key Information Stored

The table stores the defining attributes for each line or installment within a payment plan template. Key columns include:

• PLAN_LINE_ID: The unique primary key identifier for each template line record.
• PAYMENT_PLAN_NAME: The name of the parent payment plan template, serving as a foreign key to the header table (IGS_FI_PP_TEMPLATES).
• PLAN_LINE_NUM: A critical column that defines the sequence or order of the installment within the plan. This number dictates the chronological application of payments.
• PLAN_PERCENT and PLAN_AMT: These columns define the financial value of the installment. One column typically populates based on the template's configuration, representing either a fixed amount or a percentage of the total charge.
• Standard WHO Columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each line.

Common Use Cases and Queries

This table is central to operations involving the setup, inquiry, and audit of payment schedules. A common use case is generating a report of all installments for a specific payment plan template, ordered by their sequence. The following query pattern is fundamental:

SELECT PAYMENT_PLAN_NAME, PLAN_LINE_NUM, PLAN_PERCENT, PLAN_AMT, CREATION_DATE
FROM IGS.IGS_FI_PP_TMPL_LNS
WHERE PAYMENT_PLAN_NAME = '&TEMPLATE_NAME'
ORDER BY PLAN_LINE_NUM;

Another critical scenario involves data validation and integrity checks, such as identifying templates where the sum of PLAN_PERCENT does not equal 100% or where PLAN_LINE_NUM sequences have gaps. Support and implementation consultants frequently query this table to troubleshoot student account charges or to clone and modify existing payment plan structures.

Related Objects

The IGS_FI_PP_TMPL_LNS table has a direct and essential relationship with its parent header table, as indicated by the provided foreign key metadata. The primary related object is:

• TABLE: IGS.IGS_FI_PP_TEMPLATES: This is the parent table referenced via the foreign key column PAYMENT_PLAN_NAME. Each line in IGS_FI_PP_TMPL_LNS must correspond to a valid template defined in this header table. The relationship is foundational, as the template lines have no meaning without the parent template definition that groups them into a coherent payment schedule.

The table's unique constraint IGS_FI_PP_TMPL_LNS_U1, on (PAYMENT_PLAN_NAME, PLAN_LINE_NUM), enforces that line numbers are unique within a given template, preventing duplicate installment sequences.