Search Results igs_fi_pp_ins_appls_v

Overview

The view IGS_FI_PP_INS_APPLS_V belongs to the Oracle E-Business Suite product family IGS – Student System, a module that is documented as Obsolete in current ETRM references. The view presents the credit information associated with a particular installment within the Student System financials (IGS_FI) schema. Its functional purpose is to expose, in a single denormalized result set, the link between an installment application record and the credit record that it applied against, thereby allowing reporting and integration processes to reconcile installment payments with the credits (charges or adjustments) they settle.

The view is defined in the ETRM documentation as: “This view displays the credit information for a particular installment.” It joins the installment-application base table to the credits base table on CREDIT_ID, producing a read-only projection suitable for inquiry screens, extracts, and downstream interfaces.

Underlying Base Objects

The view is defined over two IGS financials base tables:

• IGS_FI_PP_INS_APPLS (aliased PPIA) – the installment application table, which stores the application of a payment/installment against a credit.
• IGS_FI_CREDITS (aliased CRD) – the credits table, which holds the credit or charge being settled.

The join predicate is PPIA.CREDIT_ID = CRD.CREDIT_ID, an inner join requiring a matching credit row for every returned installment application. The ETRM metadata note “Referenced base objects: none documented” reflects a documentation gap rather than an absence of underlying objects; the view text itself explicitly names the two tables above. Notably, the metadata also records “Not implemented in this database”, indicating that the object may be absent from environments where the obsolete Student System schema components were not deployed.

Key Columns

The view exposes the following documented columns, drawn from both base tables:

• ROWID – the pseudo-column row identifier of the installment application row, included for updatable/inquiry purposes.
• INSTALLMENT_APPLICATION_ID – primary key of the installment application record.
• APPLICATION_TYPE_CODE – classification of the application transaction.
• INSTALLMENT_ID – identifier of the installment to which the application belongs.
• CREDIT_ID, CREDIT_ACTIVITY_ID, CREDIT_NUMBER, CREDIT_DESC – credit identifiers, number, and description sourced from IGS_FI_CREDITS.
• APPLIED_AMT – the monetary amount applied from the credit against the installment.
• TRANSACTION_DATE – date on which the application was transacted.
• LINK_APPLICATION_ID – reference linking related application records.
• Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
• Concurrent program context columns – REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Because the view resolves the installment-to-credit relationship, it is typically used in financial reconciliation reports, student account inquiries, and extracts feeding external accounting systems. A representative query retrieves all credits applied against a given installment:

• SELECT installment_application_id, credit_number, credit_desc, applied_amt, transaction_date FROM igs_fi_pp_ins_appls_v WHERE installment_id = :installment_id;
• SELECT credit_id, SUM(applied_amt) FROM igs_fi_pp_ins_appls_v GROUP BY credit_id;

Given the Obsolete status of the IGS Student System, organizations upgrading to EBS 12.1.1 or 12.2.2 should confirm object availability in their instance and validate references before relying on this view in custom code.