Search Results servicer_refund_amt

Overview

The view APPS.IGF_DB_DL_DISB_RESP is a reporting and inquiry object within the Oracle E-Business Suite Financial Aid (IGF) module, specifically belonging to the ETRM (Enterprise Transaction and Reporting Model) design data group IGF. It exposes disbursement response and reconciliation information associated with loan disbursement processing, including fields relating to gross disbursement amounts, fees, net disbursement amounts, and interest rebate amounts. A key characteristic of this view is that it is documented as a multi-org view: it retrieves data only for the current operating unit and ignores data belonging to other operating units. This behavior is enforced through the presence of the ORG_ID column and the Oracle EBS multi-org security mechanism, which automatically appends a predicate filtering rows by the operating unit context of the connected session.

The view carries a status of VALID and is owned by the APPS schema, which is the standard owner for shared application objects in EBS. Because it is a view rather than a table, it presents a denormalized, read-only projection intended for reporting, integration extracts, and validation queries rather than for direct transactional updates.

Underlying Base Objects

The provided ETRM metadata does not document any referenced base objects for IGF_DB_DL_DISB_RESP; the referenced base object list is empty. Consequently, the exact table composition of the view cannot be confirmed from the supplied documentation. Based on the naming conventions and column structure, the view is built upon the disbursement response and disbursement transaction data underlying the IGF loan disbursement process, evidenced by identifiers such as DDRP_ID and DBTH_ID, which represent the disbursement response and disbursement transaction header keys respectively. The view appears to join response-level detail rows to batch, school, and loan contextual attributes, producing a single flattened result set. Because it is a multi-org view, one of its base components contributes the ORG_ID column used for operating unit security.

Key Columns

• DDRP_ID and DBTH_ID — Primary identifiers linking the record to the disbursement response and disbursement transaction header.
• LOAN_NUMBER, DISB_NUM, DISB_ACTIVITY, DISB_SEQ_NUM — Disbursement identification and sequencing attributes, each accompanied by a corresponding *_STATUS column indicating validation state.
• DISB_GROSS_AMT, FEE_1, DISB_NET_AMT — Reported gross amount, fee, and net amount for the disbursement.
• INT_REBATE_AMT — The interest rebate amount reported for the disbursement, and one of the two rebate columns in the view.
• LOC_DISB_GROSS_AMT, LOC_FEE_1, LOC_DISB_NET_AMT, LOC_INT_REBATE_AMT, LOC_NET_BOOKED_LOAN — Local-currency equivalents of the reported amounts, prefixed with LOC_ to distinguish them from the primary figures.
• SERVICER_REFUND_AMT — Refund amount returned by the servicer.
• ACK_DATE, AFFIRM_FLAG, STATUS — Acknowledgement date, affirmation indicator, and overall record status.
• ORG_ID — Operating unit identifier driving the multi-org filtering.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard EBS audit and concurrent program context columns.

Common Use Cases and Queries

This view is typically queried for disbursement reconciliation reports, interest rebate analysis, and interface validation. A representative query returning interest rebate figures for the current operating unit is shown below.

• Reconciling reported versus local-currency rebate amounts for a disbursement batch.
• Auditing disbursements by school, loan number, or disbursement activity status.
• Extracting affirmed and acknowledged disbursement response records for downstream reporting.

SELECT loan_number, disb_num, disb_activity, disb_gross_amt, fee_1, disb_net_amt, int_rebate_amt, loc_int_rebate_amt, servicer_refund_amt, status FROM apps.igf_db_dl_disb_resp WHERE disb_batch_id = :batch_id ORDER BY loan_number, disb_seq_num;

Because the view enforces multi-org security, the ORG_ID predicate is applied automatically based on the operating unit of the session, so no explicit ORG_ID filter is required. Columns with a *_STATUS suffix can be used to identify which disbursement attributes passed or failed validation prior to acknowledgment, making the view suitable for pre-acknowledgement review and post-processing exception reporting.