Search Results dlpdr_id

Overview

IGF.IGF_SL_DL_PDET_RESP is a transaction data table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the IGF schema and registered under FND Design Data as IGF.IGF_SL_DL_PDET_RESP. It stores the response records generated from the Direct Loan Promissory note acknowledgment file uploaded into the system, functioning as the detail-level repository where disbursement-specific acknowledgments from the loan servicing process are persisted. Within the broader Oracle Student Financial Aid and ETRM (Extended Transactional Relationship Management) integration flows, this table captures the outcome of processing lender or servicer acknowledgment files for Direct Loan promissory notes.

Based on the heuristic Data Vault classification mined from its foreign key structure, this object leans toward a satellite classification. Modeling guidance suggests treating IGF_SL_DL_PDET_RESP as a satellite attached to the parent IGF_SL_DL_PNOTE_RESP_ALL hub via the DLPNR_ID foreign key, carrying descriptive and numeric attributes (such as DISB_GROSS_AMT) that change over time or per disbursement event.

Key Information Stored

• DLPNR_ID — Identifier for response records from the Direct Loan Promissory note acknowledgment file. This column is both part of the composite primary key and a foreign key referencing IGF_SL_DL_PNOTE_RESP_ALL.
• DLPDR_ID — Disbursement Number; the second component of the composite primary key and part of the unique index.
• DISB_GROSS_AMT — First disbursement anticipated gross amount, the primary quantitative value captured per detail response.
• CREATED_BY, CREATION_DATE — Standard Who columns recording the creating user and timestamp.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns recording the most recent modification user, timestamp, and login.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program Who columns identifying the batch process and application that populated or updated the row.

The surrogate primary key is IGF_SL_DL_PDET_RESP_PK, composed of (DLPNR_ID, DLPDR_ID). A unique index, IGF_SL_DL_RESP_ALL_U1, also spans (DLPNR_ID, DLPDR_ID) in the APPS_TS_TX_IDX tablespace, reinforcing the same pair as the effective business-key candidate. Table data resides in APPS_TS_TX_DATA with PCT Free 10.

Common Use Cases and Queries

Typical reporting scenarios include reconciling anticipated disbursement amounts per promissory note response, auditing acknowledgment file imports by concurrent request, and joining detail rows to their parent response header. A sample query pattern follows:

• Retrieve all detail responses for a given promissory note: SELECT DLPDR_ID, DISB_GROSS_AMT FROM IGF.IGF_SL_DL_PDET_RESP WHERE DLPNR_ID = :p_dlpnr_id;
• Trace rows to the concurrent program that loaded them: filter or group by REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID.
• Audit recently changed records using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

• IGF.IGF_SL_DL_PNOTE_RESP_ALL — Parent response record table referenced by the DLPNR_ID foreign key; the primary join partner.
• APPS.IGF_SL_DL_PDET_RESP — The APPS-synonymed view or reference used by application code and concurrent programs.
• Index IGF_SL_DL_RESP_ALL_U1 — Unique index on (DLPNR_ID, DLPDR_ID) supporting lookups and enforcing business-key uniqueness.
• Primary key constraint IGF_SL_DL_PDET_RESP_PK — Enforces row identity over the same composite column pair.

No additional database objects are documented as referencing this table, confirming its role as a leaf-level detail satellite within the Direct Loan promissory note acknowledgment data model.