Search Results dest_entity_id_txt

Overview

The table IGF.IGF_SL_CR_RESP_DTLS is an Oracle E-Business Suite table owned by the IGF schema, which underpins the Student Loan and Common Record processing functionality delivered through Oracle Financial Aid and related self-service modules. The object stores the Common Record Tag Response Elements extracted from an inbound response XML file, capturing the header-level metadata of each response document exchanged between trading partners. In EBS 12.1.1 and 12.2.2 this table is classified as VALID and is registered in FND Design Data as IGF.IGF_SL_CR_RESP_DTLS. Its physical storage resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its unique index IGF_SL_CR_RESP_DTLS_PK lives in APPS_TS_TX_IDX.

From a modeling perspective, the heuristic Data Vault classification for this object is hub-leaning. The surrogate primary key is a natural business identifier (DOCUMENT_ID_TXT) rather than a generated sequence, which supports treating it as a hub-style key that other tables reference as a foreign key. This makes the table a central anchor for response document identity within the financial aid integration flow.

Key Information Stored

The table records 20 documented columns. The most significant are:

DOCUMENT_ID_TXT — the identifier for the document and the column that forms the unique primary key IGF_SL_CR_RESP_DTLS_PK. This is the business-key candidate referenced by dependent tables.
DOC_CREATED_DATE — the date and time the source document was created.
SOURCE_ENTITY_ID_TXT and DEST_ENTITY_ID_TXT — the originating and receiving trading-partner entity identifiers.
SOFT_PROVIDER and SOFT_VERSION — the software provider and software version that produced the response. SOFT_VERSION is the column most directly associated with the search term "soft_version" and identifies the release level of the originating system.
FULL_RESP_CODE — the full response code returned in the document.
RECEIPT_DATE — the timestamp marking receipt of the document.
DOC_TYPE_CODE and DOC_STATUS_CODE — the document type returned and its processing status at COD.
PROCESS_DATE — the date the document was processed.
Standard Who columns including CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID for audit and concurrent program traceability.

Common Use Cases and Queries

Typical usage centers on reconciliation, audit, and troubleshooting of Common Record responses. Analysts frequently filter by SOFT_VERSION or SOFT_PROVIDER to identify responses from a specific sending system, or by DOC_STATUS_CODE to isolate responses that failed processing. A representative query is:

SELECT DOCUMENT_ID_TXT, SOFT_PROVIDER, SOFT_VERSION, FULL_RESP_CODE, DOC_STATUS_CODE, RECEIPT_DATE FROM IGF.IGF_SL_CR_RESP_DTLS WHERE SOFT_VERSION = :version;
Joining to child detail tables on DOCUMENT_ID_TXT to retrieve all response elements belonging to a document.
Reporting on documents received within a date range using RECEIPT_DATE or DOC_CREATED_DATE.
Grouping by DOC_TYPE_CODE to summarize response volume by type.

Related Objects

Two documented foreign-key relationships reference this table:

IGF.IGF_SL_ED_PRC_RSLTS.EDIT_ID references IGF.IGF_SL_CR_RESP_DTLS.DOCUMENT_ID_TXT, linking edit processing results back to the originating response document.
IGF.IGF_SL_RS_RESP_DTLS.DOCUMENT_ID_TXT references IGF.IGF_SL_CR_RESP_DTLS.DOCUMENT_ID_TXT, providing the response detail elements that belong to each header document.

These relationships confirm the hub-leaning role of the table: DOCUMENT_ID_TXT acts as the anchor key joined by downstream processing and detail tables, making this object the primary gateway for querying Common Record response metadata in Oracle EBS financial aid implementations.

TABLE: IGF.IGF_SL_CR_RESP_DTLS 12.1.1
owner:IGF, object_type:TABLE, fnd_design_data:IGF.IGF_SL_CR_RESP_DTLS, object_name:IGF_SL_CR_RESP_DTLS, status:VALID,
View: IGF_GR_RESP_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_GR_RESP_DTLS_V, object_name:IGF_GR_RESP_DTLS_V, status:VALID, product: IGF - Financial Aid , description: View for Pell response details , implementation_dba_data: APPS.IGF_GR_RESP_DTLS_V ,
View: IGF_GR_RESP_DTLS_V 12.2.2
product: IGF - Financial Aid (Obsolete) , description: View for Pell response details , implementation_dba_data: Not implemented in this database ,
VIEW: APPS.IGF_GR_RESP_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_GR_RESP_DTLS_V, object_name:IGF_GR_RESP_DTLS_V, status:VALID,
View: IGF_SL_RESP_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_SL_RESP_DTLS_V, object_name:IGF_SL_RESP_DTLS_V, status:VALID, product: IGF - Financial Aid , description: View containing the response details for all the XML Documents received for the Direct Loans , implementation_dba_data: APPS.IGF_SL_RESP_DTLS_V ,
View: IGF_SL_RESP_DTLS_V 12.2.2
product: IGF - Financial Aid (Obsolete) , description: View containing the response details for all the XML Documents received for the Direct Loans , implementation_dba_data: Not implemented in this database ,
VIEW: APPS.IGF_SL_RESP_DTLS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGF.IGF_SL_RESP_DTLS_V, object_name:IGF_SL_RESP_DTLS_V, status:VALID,
APPS.IGF_SL_UPLOAD_XML SQL Statements 12.1.1
APPS.IGF_SL_UPLOAD_XML dependencies on IGF_SL_CR_RESP_DTLS 12.1.1
PACKAGE BODY: APPS.IGF_SL_UPLOAD_XML 12.1.1
eTRM - IGF Tables and Views 12.1.1
description: Holds pays only unit details for a pays only program ,