Search Results disb_activity_desc

Overview

IGF_DB_AWD_DISB_DTL_V is a supplementary view owned by the APPS schema within the Oracle E-Business Suite Financial Aid (IGF) module, specifically the Direct Loan (DB) disbursement subsystem. Its stated purpose is to simplify Oracle Forms coding by flattening and denormalizing the award/disbursement relationship into a single queryable structure, joining disbursement detail records to descriptive lookup values. In Oracle EBS 12.1.1 and 12.2.2 it is used by the Direct Loan disbursement forms and, by extension, can be referenced for reporting and integration purposes. Oracle explicitly warns that this is a Forms-support view and does not recommend querying or altering data through it, because its definition may change dramatically across minor or major releases. The user's search term, disb_status_desc, corresponds directly to the DISB_STATUS_DESC column exposed by this view, which carries the human-readable Direct Loan disbursement status.

Underlying Base Objects

The ETRM metadata for this object does not document the referenced base tables; the "Referenced base objects" section is empty. Based on the column set, the view is drawn principally from the Direct Loan award and disbursement detail tables (for example, the IGF_DB_AWD_DISB_DTL family) with lookup and decode logic applied to produce the descr

iptive columns. Several attributes in the projection are annotated "No longer used" — DISB_BATCH_ID, DISB_ACK_DATE, BOOKING_BATCH_ID, BOOKED_DATE, DISB_STATUS, and DISB_STATUS_DATE — indicating that the underlying batch and original status columns have been superseded. The replacement descriptive columns DISB_STATUS_DESC, DISB_ACTIVITY_DESC, and SF_STATUS_DESC (each VARCHAR2(4000)) are populated in the view rather than stored directly. Because Oracle does not document the base objects, its structure should be treated as release-dependent, and consumers should not assume stability of column semantics across patches.

Key Columns

• DISB_STATUS_DESC (VARCHAR2(4000)) — Indicates the Disbursement Status for Direct Loan disbursements; this is the primary column associated with the user's search term.
• DISB_ACTIVITY_DESC (VARCHAR2(4000)) — Indicates the Disbursement Activity for Direct Loan disbursements.
• SF_STATUS_DESC (VARCHAR2(4000)) — Indicates the Transaction Status for the associated Student Financial (SF) record.
• AWARD_ID, DISB_NUM, DISB_SEQ_NUM — Identify the award and the specific disbursement sequence.
• DISB_GROSS_AMT, FEE_1, FEE_2, DISB_NET_AMT, DISB_ADJ_AMT, INTEREST_REBATE_AMT — Disbursement financial amounts, including fees paid (FEE_PAID_1, FEE_PAID_2) and interest rebate.
• DISB_DATE, SF_STATUS_DATE, NOTIFICATION_DATE — Disbursement date; SF transaction status date; and the Correspondence Process Date updated by post-process once the Loan Disbursement Letter has been sent to the student.
• SF_INVOICE_NUM, SPNSR_CREDIT_ID, SPNSR_CHARGE_ID, SF_CREDIT_ID — Student Financial invoice and credit/charge linkage identifiers.
• LD_CAL_TYPE, LD_SEQUENCE_NUMBER, LD_ALTERNATE_CODE — Load calendar type, sequence, and alternate code.
• ERROR_DESC (VARCHAR2(2000)) — Error text associated with failed processing.
• 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

Typical usage is to present the current Direct Loan disbursement status and activity in a readable form for reconciliation, financial aid reporting, and integration extracts. A sample query selecting the searched-for descriptor follows:

SELECT award_id, disb_num, disb_seq_num, disb_date, disb_gross_amt, disb_net_amt, disb_status_desc, disb_activity_desc, sf_status_desc FROM apps.igf_db_awd_disb_dtl_v WHERE disb_status_desc = :p_status;

Because the view is a Forms-support construct, it should be consumed read-only, and its column list and decode logic should be re-verified against each applied patch level or release upgrade before being relied upon in a production report or interface.