Search Results igf_se_awd_disb_v

Overview

IGF_SE_AWD_DISB_V is a database view within the Oracle E-Business Suite Financial Aid module (product code IGF). In Release 12.1.1 and 12.2.2 the product is classified as obsolete, meaning Oracle no longer actively develops or supports the functionality natively, though the underlying objects frequently persist in upgraded or legacy installations. The view is designed to retrieve award disbursement details specifically for student employment awards, consolidating disbursement-level information with the calendar instance attributes associated with the load or award period. It functions as a reporting and inquiry layer over the base disbursement table, presenting a denormalized projection that includes computed columns, thereby simplifying downstream reporting, extracts, and integration routines that would otherwise require multi-table joins against the raw disbursement entity. The presence of standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), concurrency columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and the multi-org column ORG_ID confirms that the view is exposed through the standard Oracle Application Object Library security and multi-org architecture.

Underlying Base Objects

According to the view text, the definition joins two base objects: IGF_AW_AWD_DISB_ALL, aliased ADISB, which supplies the award disbursement rows, and IGS_CA_INST, aliased CILD, which supplies calendar instance information. The join predicate links CILD.CAL_TYPE to ADISB.LD_CAL_TYPE and CILD.SEQUENCE_NUMBER to ADISB.LD_SEQUENCE_NUMBER, securing the lookup of the load calendar instance for each disbursement. The _ALL suffix on IGF_AW_AWD_DISB_ALL indicates a multi-org partitioned table, consistent with the ORG_ID column projected by the view. The documented ETRM metadata for this object records no referenced base objects and does not identify an owner, so the dependency on IGF_AW_AWD_DISB_ALL and IGS_CA_INST is derived from the view SQL rather than the catalog entry. The implementation note in the metadata states the object is not implemented in the source database, which is typical for obsolete IGF objects that survive only in legacy instances.

Key Columns

• AWARD_ID and DISB_NUM — identify the parent award and the specific disbursement sequence number.
• TP_CAL_TYPE and TP_SEQUENCE_NUMBER — the teaching period calendar context for the disbursement.
• DISB_GROSS_AMT, FEE_1, FEE_2, DISB_NET_AMT — gross amount, associated fee deductions, and net disbursed amount.
• DISB_ACCEPTED_AMT and DISB_PAID_AMT — accepted and actually paid amounts; the view derives REMAINING_AMOUNT as the difference and PROGRESS_TWDS_LMT as the percentage of accepted amount paid.
• DISB_STATUS and FUND_STATUS — disbursement and funding lifecycle state indicators, each with their respective date columns.
• FORCE_DISB — the force-disbursement indicator, the column most directly associated with the searched term "force_disb," used to flag disbursements that bypass standard eligibility or release controls.
• ELIG_STATUS, AFFIRM_FLAG, HOLD_REL_IND, MANUAL_HOLD_IND — eligibility, affirmation, and hold-management flags governing release.
• MIN_CREDIT_PTS, DISB_EXP_DT, VERF_ENFR_DT — minimum credit point threshold, disbursement expiry date, and verification enforcement date.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE — load calendar instance identifiers and the alternate code resolved through IGS_CA_INST.
• ORG_ID — the operating unit, enabling multi-org filtering.

Common Use Cases and Queries

Typical uses include identifying disbursements flagged for forced release, monitoring outstanding balances against accepted amounts, and reconciling paid versus accepted totals per award. The following query isolates forced disbursements for a given organization:

SELECT AWARD_ID,
       DISB_NUM,
       DISB_DATE,
       DISB_GROSS_AMT,
       DISB_NET_AMT,
       DISB_ACCEPTED_AMT,
       DISB_PAID_AMT,
       REMAINING_AMOUNT,
       PROGRESS_TWDS_LMT,
       DISB_STATUS,
       FORCE_DISB
  FROM IGF_SE_AWD_DISB_V
 WHERE FORCE_DISB = 'Y'
   AND ORG_ID = :p_org_id
 ORDER BY DISB_DATE DESC;

A second common pattern aggregates net paid amounts by teaching period and load calendar to support reconciliation reporting:

SELECT LD_CAL_TYPE,
       LD_SEQUENCE_NUMBER,
       LD_ALTERNATE_CODE,
       SUM(DISB_PAID_AMT) PAID_TOTAL,
       SUM(DISB_ACCEPTED_AMT) ACCEPTED_TOTAL
  FROM IGF_SE_AWD_DISB_V
 GROUP BY LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE;

Because the product is obsolete in 12.1.1 and 12.2.2, integrators should treat these columns as read-only legacy interfaces and validate object availability before deployment.