Results for “base_amt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_FI_PP_TEMPLATES_V is a seeded Oracle E-Business Suite view owned by the APPS schema and shipped as part of the IGS (Student System) product family, specifically the Financials sub-module (IGS_FI). The view presents master Payment Plan Template information — the reusable blueprints that define how a student's tuition and fee obligations are scheduled into installments. Rather than exposing the raw configuration table directly, the view joins template rows to the lookup values that give the installment period code a human-readable meaning, producing a reporting-friendly projection suitable for BI Publisher extracts, OAF-based pages, concurrent program outputs, and integration interfaces that need to display or consume payment plan definitions.

Because the object is a view and not a table, it carries no independent storage and is inherently read-only. Its status is documented as VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2. The column DUE_CUTOFF_DAY — the term surfaced by the user's search — is exposed directly by the view. This column represents the cutoff day used in conjunction with the due day settings to determine the point at which a scheduled installment is no longer eligible for a given processing cycle, effectively controlling late-attribution behaviour within the payment plan calendar logic.

Underlying Base Objects

The documented view text shows a two-table join:

• IGS_FI_PP_TEMPLATES (alias PPT) — the primary base table holding the master payment plan template definitions, including naming, installment period, due date rules, processing fee attributes, and base amount configuration.
• IGS_LOOKUP_VALUES (alias LKP) — the standard Oracle lookup values view, filtered to LOOKUP_TYPE = 'IGS_FI_INSTALLMENT_PERIOD' and joined on PPT.INSTALLMENT_PERIOD_CODE = LKP.LOOKUP_CODE, supplying the meaning associated with the installment period code.

The join is an inner join, so a template row appears in this view only when its INSTALLMENT_PERIOD_CODE resolves to an active lookup value of type IGS_FI_INSTALLMENT_PERIOD. Template rows in the base table that reference a missing or misconfigured lookup code are therefore silently excluded, a behaviour worth noting when reconciling row counts between the view and the base table.

Key Columns

• ROW_ID — the ROWID of the underlying IGS_FI_PP_TEMPLATES row, carried through for identification and row-level addressing.
• PAYMENT_PLAN_NAME / PAYMENT_PLAN_DESC — the identifying name and descriptive text of the master template.
• CLOSED_FLAG — indicates whether the template has been closed to further use.
• INSTALLMENT_PERIOD_CODE — the lookup code defining the frequency or period basis of installments.
• INSTALLMENT_PERIOD_MEANING — the decoded description of the installment period, sourced from IGS_LOOKUP_VALUES.
• DUE_DAY_OF_MONTH — the calendar day of the month on which installments fall due.
• DUE_END_OF_MONTH_FLAG — flag indicating that the due date should be anchored to the end of the month rather than the fixed due day.
• DUE_CUTOFF_DAY — the cutoff day governing eligibility relative to the due date, central to scheduling and late-fee logic.
• PROCESSING_FEE_AMT / PROCESSING_FEE_TYPE — the processing fee amount and the fee type that governs its treatment.
• INSTALLMENT_METHOD_FLAG and BASE_AMT — the installment method indicator and the base amount from which plan schedules are derived.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN for standard EBS audit traceability.

Common Use Cases and Queries

The view is typically used to populate payment plan selection lists, validate student plan assignments, and extract template configurations for audit or migration. A typical query listing active templates with their due rules is:

• SELECT payment_plan_name, installment_period_meaning, due_day_of_month, due_end_of_month_flag, due_cutoff_day, processing_fee_amt, processing_fee_type, base_amt FROM apps.igs_fi_pp_templates_v WHERE closed_flag = 'N' ORDER BY payment_plan_name;
• SELECT payment_plan_name, due_cutoff_day FROM apps.igs_fi_pp_templates_v WHERE due_cutoff_day IS NOT NULL;

A common reconciliation query compares view rows against the base table to detect templates whose installment period code fails to resolve:

• SELECT t.payment_plan_name FROM apps.igs_fi_pp_templates t WHERE NOT EXISTS (SELECT 1 FROM apps.igs_fi_pp_templates_v v WHERE v.row_id = t.rowid);

All queries should be executed against the APPS schema or a synonym-bearing custom schema, and access should respect the standard EBS security model for IGS Financials data.