Search Results disb_hold_rel_ind

Overview

IGF_SL_CL_RESP_R8 is a view in the Oracle E-Business Suite (EBS) financial aid module (product code IGF, "Financial Aid"). In release 12.1.1 and 12.2.2 this view is part of the legacy Student Loan CommonLine processing schema, representing the R8 response record set that lenders and guarantee agencies return to institutions after a disbursement has been processed. The view exposes disbursement-level detail — disbursement date, gross amount, fees, net amount, hold-release indicator, and disbursement status — together with the standard EBS concurrency and audit columns.

The ETRM metadata for 12.2.2 explicitly states "Not implemented in this database" and describes the product as obsolete, so in most installations the view exists only as historical metadata. It is retained for reference by customers who still hold the original CommonLine schema or who have archived financial-aid data. The view is read-only and is exposed primarily to reporting and integration layers rather than to end-user forms. Because the base table carries ORG_ID, the view is a multi-org (business group / operating unit) secured object, and its definition applies the standard client-info ORG_ID predicate to restrict rows to the current organization context.

Underlying Base Objects

The view is defined over a single base object, IGF_SL_CL_RESP_R8_ALL. No other referenced base objects are documented in the ETRM record; the view selects directly from that table with an alias of SLRESPR8. The "_ALL" suffix identifies the table as the multi-org master for the R8 response entity; the view therefore provides an operating-unit-filtered window onto it, while insert, update, and delete operations remain the responsibility of the underlying table and its concurrent programs.

The predicate in the view uses USERENV('CLIENT_INFO') decoded through SUBSTRB and DECODE and compared with ORG_ID, defaulting to -99 when no client information is present. This mirrors the standard multi-org view construct used throughout EBS 12.x, so querying the view returns only rows whose ORG_ID matches the organization established by the caller's session. Reports that must span operating units cannot bypass this filter without explicit MO security privileges or by querying the ALL table directly with appropriate authorization.

Key Columns

• ROW_ID — ROWID of the underlying row, useful for row-level joins or de-duplication.
• CLRP1_ID / CLRP8_ID — Foreign keys linking the response to the CLRP1 (loan) and CLRP8 (disbursement) CommonLine records.
• DISB_DATE / DISB_GROSS_AMT / NET_DISB_AMT — The disbursement date and the gross and net amounts of the disbursement.
• ORIG_FEE / GUARANTEE_FEE / GUARNT_FEE_PAID / ORIG_FEE_PAID — Origination and guarantee fee amounts assessed and the paid flags that indicate fee remittance status.
• DISB_HOLD_REL_IND — Disbursement hold-release indicator controlling whether funds may be released.
• DISB_STATUS — The disbursement status value; this is the most frequently searched column, used to filter responses by whether a disbursement is pending, released, or otherwise processed.
• RESP_RECORD_STATUS — Status of the response record itself, distinct from the disbursement status.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — Standard audit columns.
• REQUEST_ID / PROGRAM_APPLICATION_ID / PROGRAM_ID / PROGRAM_UPDATE_DATE — Concurrent program and request context that produced or last updated the row.
• ORG_ID — Operating unit identifier enforcing multi-org security.
• LAYOUT_OWNER_CODE_TXT / LAYOUT_VERSION_CODE_TXT / RECORD_CODE_TXT — CommonLine layout metadata describing the record format used in the exchange file.
• DIRECT_TO_BORR_FLAG — Flag indicating whether funds were directed to the borrower.

Common Use Cases and Queries

The principal use case is extracting disbursement outcomes for reconciliation and reporting. A typical query filtering by disbursement status is:

• SELECT clrp1_id, clrp8_id, disb_date, disb_gross_amt, net_disb_amt, disb_status FROM igf_sl_cl_resp_r8 WHERE disb_status IS NOT NULL ORDER BY disb_date;
• SELECT disb_status, COUNT(*), SUM(disb_gross_amt) FROM igf_sl_cl_resp_r8 GROUP BY disb_status;
• SELECT r.clrp8_id, r.disb_status, r.guarantee_fee, r.guarnt_fee_paid FROM igf_sl_cl_resp_r8 r WHERE r.org_id = :org_id AND r.disb_hold_rel_ind = 'Y';

Because the product is obsolete and the object is not implemented in the documented 12.2.2 database, these queries are relevant only for legacy archives or migration projects. In current 12.1.1 or 12.2.2 environments, verify object existence in ALL_VIEWS and confirm base table availability before relying on the view; otherwise, historical data must be sourced from archived extracts.