Search Results igf_aw_fund_mast

Overview

The view IGS_FI_BILL_PLN_CRD_V belongs to the Oracle E-Business Suite product family IGS (Student System), a module that is designated obsolete in Release 12.1.1 and 12.2.2. The view is a reporting construct used specifically by the Billing History form to display the planned credits that were extracted for a particular student bill. It exposes the intersection of billing plan credit records, award fund master data, and calendar instance data, allowing the Billing History form to render fund codes and the applicable calendar period alongside the planned credit amount.

The view is documented in ETRM 12.2.2 metadata but is explicitly noted as not implemented in the reference database. As a view rather than a table, it carries no independent storage; its behavior is entirely derived from its defining query and the underlying base tables.

Underlying Base Objects

The view is defined over three base tables:

• IGS_FI_BILL_PLN_CRD — the driving table, supplying the planned credit rows associated with a bill, award, disbursement, fund, and fee calendar context.
• IGF_AW_FUND_MAST — the award fund master table, joined on FUND_ID, providing the human-readable FUND_CODE. This is the object referenced by the search term "igf_aw_fund_mast".
• IGS_CA_INST — the calendar instance table, outer-joined on FEE_CAL_TYPE and FEE_CI_SEQUENCE_NUMBER to supply START_DT and END_DT for the applicable calendar period.

The join to IGF_AW_FUND_MAST is an inner join (equality on FUND_ID), so any planned credit row lacking a matching fund master record will not appear in the result set. The join to IGS_CA_INST is an outer join, indicated by the (+) operator, meaning rows for credits without a matching calendar instance still qualify.

Key Columns

The view projects the following significant columns:

• ROW_ID — the ROWID of the underlying IGS_FI_BILL_PLN_CRD row, preserved for update navigation in the form.
• BILL_ID — identifier of the bill to which the planned credit applies.
• PLN_CREDIT_DATE — the planned date of the credit.
• AWARD_ID, DISB_NUM — the award and disbursement reference for the credit.
• FUND_ID, FUND_CODE — the fund identifier from the planned credit row and the decoded fund code from IGF_AW_FUND_MAST.
• FEE_CAL_TYPE, FEE_CI_SEQUENCE_NUMBER — the calendar type and sequence identifying the fee period.
• PLN_CREDIT_AMOUNT — the monetary value of the planned credit.
• START_DT, END_DT — the calendar instance start and end dates supplied by IGS_CA_INST.
• BILL_DESC — descriptive text for the bill.
• DML audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

The principal consumer is the Billing History form, which filters planned credits by bill. A representative query follows:

SELECT bill_id, fund_code, pln_credit_date, pln_credit_amount, start_dt, end_dt
FROM igs_fi_bill_pln_crd_v
WHERE bill_id = :p_bill_id
ORDER BY pln_credit_date;

Reconciliation reporting between planned credits and extracted fund awards typically joins the view back to IGF_AW_FUND_MAST or forward to disbursement records using AWARD_ID and DISB_NUM. Because IGS is obsolete in 12.2.2, clients should confirm whether the view exists in their environment and treat any dependency as legacy, favoring successor student financials objects where available.