Search Results soft_version




Overview
Explore in AI Chat

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:

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.