Search Results igf_db_dl_disb_resp_all




Overview
Explore in AI Chat

Overview

The table IGF_DB_DL_DISB_RESP_ALL resides in the IGF schema and belongs to the Oracle E-Business Suite Financial Aid (IGF) product family. It stores records originating from the Direct Loan disbursements acknowledgment file or booking notification file received from the Common Origination and Disbursement (COD) system. In the context of Oracle EBS 12.1.1 and 12.2.2, this table functions as the landing and reconciliation store for disbursement responses tied to a Direct Loan batch, enabling institutions to confirm, adjust, or flag disbursement activity against what was originally transmitted.

The documented primary key is IGF_DB_DL_DISB_RESP_ALL_PK, defined on the surrogate column DDRP_ID, which is the identifier most commonly referenced by users searching for "ddrp_id". Under a heuristic Data Vault classification mined from the foreign key structure, this object is satellite-leaning: it captures descriptive, mutable attributes and status flags attached to a parent batch entity rather than acting as a standalone hub or a pure associative link.

Key Information Stored

The physical schema for the 12.1.1 release documents 39 columns. The most operationally significant are summarized below.

Common Use Cases and Queries

Typical use cases center on reconciliation of COD responses, disbursement reporting, and exception handling for failed or mismatched acknowledgments.

  • Retrieving all responses for a batch: SELECT * FROM IGF.IGF_DB_DL_DISB_RESP_ALL WHERE DBTH_ID = :p_batch_id;
  • Locating a single response by its surrogate key: SELECT * FROM IGF.IGF_DB_DL_DISB_RESP_ALL WHERE DDRP_ID = :p_ddrp_id;
  • Identifying exceptions: filtering on STATUS or the *_STATUS validation columns to surface mismatches between reported and local amounts.
  • Reconciliation reporting that compares DISB_GROSS_AMT, FEE_1, and DISB_NET_AMT against the corresponding LOC_* values.

Related Objects

  • IGF_SL_DL_BATCH_ALL — Parent batch table, joined via DBTH_ID; the primary dependency for this satellite object.
  • PER_JP_SCHOOL_LOOKUPS — Referenced through SCHOOL_ID for school-level validation and lookup values.
  • Related Direct Loan processing tables and concurrent programs within the IGF module that populate and consume these response records.

Because the documented metadata is heavily FK-driven, the two foreign keys above represent the most authoritative join paths available for this object.