Search Results igf_ap_batch_aw_map

Overview

IGS_FI_PLN_CREDITS_V is a reporting view that belongs to the IGS (Student System) product family within Oracle E-Business Suite, specifically the financial aid and award disbursement sub-area. In release 12.1.1 and 12.2.2 documentation the object is flagged as obsolete, and the ETRM record explicitly states "Not implemented in this database," meaning the view is documented for reference but is not created in a standard installation of the current release. The name suggests a planning-oriented credit view: it collapses award disbursement records into a flat, billable-credit projection combining disbursement amounts, fund classification, and calendar-instance context.

Its primary role is read-only reporting. Consolidating award, fund, calendar, and disbursement data into a single row per disbursement allows downstream reports — billing, fund credit posting, and fee-assessment reconciliation — to consume student award credits without traversing the normalized award schema. The presence of DISB_NET_AMT as a projected column is significant: it is the net disbursement amount (gross award disbursement less adjustments), and it is the field most often searched by users seeking to reconcile posted credits against expected disbursements.

Underlying Base Objects

Although the metadata lists no documented base objects, the embedded view text shows the definition joins seven tables:

• IGF_AW_AWD_DISB (DISB) — the driving disbursement table, providing amount, date, transaction type, and bill flag.
• IGF_AW_AWARD (AWD) — the parent award, filtered to AWARD_STATUS = 'ACCEPTED'.
• IGF_AP_FA_BASE_REC (BASE) — the financial-aid base record that supplies PERSON_ID.
• IGF_AW_FUND_MAST (FMAST) — the fund master, supplying FUND_CODE, FUND_ID, and CREDIT_TYPE_ID.
• IGS_CA_INST_REL (CIR) and IGS_CA_TYPE (CT) — relate the load calendar to its superior (fee) calendar, with CT.S_CAL_CAT = 'FEE'.
• IGS_CA_INST (CA) — the fee calendar instance, supplying START_DT and END_DT.
• IGF_AP_BATCH_AW_MAP (BM) — the award-year batch mapping, filtered to AWARD_YEAR_STATUS_CODE = 'O' (open).

The joins on the calendar-relationship and calendar-instance tables are outer joins, so disbursements without a mapped fee calendar still return rows, with START_DT and END_DT null.

Key Columns

• ROW_ID / AWARD_ID / PERSON_ID — identifiers linking the credit back to the disbursement, award, and student.
• DISB_NUM / DISB_DATE — disbursement sequence and effective date.
• DISB_NET_AMT — the net credit amount, the principal monetary measure of the view.
• SHOW_ON_BILL / TRANS_TYPE — filters restricting the view to billable, payment-type ('P') disbursements.
• LD_CAL_TYPE / LD_SEQUENCE_NUMBER — the load calendar instance tied to the disbursement.
• FEE_CAL_TYPE / FEE_CI_SEQUENCE_NUMBER / START_DT / END_DT — the derived fee (superior) calendar context and its date range.
• FUND_CODE / FUND_ID / SUBACCOUNT_ID / CREDIT_TYPE_ID — fund and credit classification used by subledger posting logic.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report billable award credits for open award years and to reconcile net disbursements by fund and person. A representative query retrieving net credits for a student is:

SELECT person_id, award_id, disb_num, disb_net_amt, disb_date, fund_code, credit_type_id FROM igs_fi_pln_credits_v WHERE person_id = :person_id ORDER BY disb_date;

Aggregation by fund supports financial-aid cash planning:

SELECT fund_code, SUM(disb_net_amt) FROM igs_fi_pln_credits_v WHERE start_dt BETWEEN :from_dt AND :to_dt GROUP BY fund_code;

Because the view is documented as obsolete and not implemented in the database, these patterns should be validated against the underlying IGF_AW_AWD_DISB and related tables, reproducing the filter conditions (TRANS_TYPE = 'P', SHOW_ON_BILL = 'Y', AWARD_STATUS = 'ACCEPTED', AWARD_YEAR_STATUS_CODE = 'O', and CT.S_CAL_CAT = 'FEE') directly in custom SQL.