Search Results offresp_int_id

Overview

IGS.IGS_AD_OFFRESP_ERR is a public, active interface table within the Oracle E-Business Suite product family IGS (Intelligent Grants System / Student Systems), classified under the business entity IGS_ADM_APPLICATION. It holds the errors and warnings produced by the Offer Response Import concurrent process. Each time the import runs, a row is inserted into this table for every warning or error encountered, linked back to the specific record in the source interface table IGS_AD_OFFRESP_INT via the OFFRESP_INT_ID column. This makes the table an error-staging and diagnostic artifact rather than a transactional master.

The table is stored in the APPS_TS_INTERFACE tablespace with PCT Free of 10, consistent with its role as an interface-layer object populated by concurrent processing. From a Data Vault modeling perspective, the metadata heuristic suggests a satellite-leaning classification: it records descriptive attributes (error code, error text) surrounding a business key that originates in the interface table, with a dependent surrogate key. It is best treated as a dependent satellite attached to the interface hub represented by IGS_AD_OFFRESP_INT.

Key Information Stored

Only the columns documented in the ETRM metadata are described below; these are the most significant for functional and diagnostic purposes.

• OFFRESP_ERR_ID (NUMBER 15, mandatory) — Surrogate primary key uniquely identifying each error row; enforced by the unique index IGS_AD_OFFRESP_ERR_PK.
• OFFRESP_INT_ID (NUMBER 15, mandatory) — Foreign key to IGS_AD_OFFRESP_INT, identifying the interface record that generated the warning or error. Backed by non-unique index IGS_AD_OFFRESP_ERR_N1, reflecting its role as the primary lookup path.
• ERROR_CODE (VARCHAR2 30) — Short code classifying the warning or error.
• ERROR_TEXT (VARCHAR2 2000) — Descriptive message text explaining the failure or warning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing row creation and modification history.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns identifying the request and program that last processed the row.

The business-key candidate is OFFRESP_ERR_ID (unique). No alternate unique business key exists beyond the surrogate; OFFRESP_INT_ID is a foreign-key reference, not a unique key, because one interface row may yield multiple errors.

Common Use Cases and Queries

The primary use case is diagnosing Offer Response Import failures. Operations staff and support analysts query this table after running the import to enumerate warnings and errors, group by error code, and trace problems back to the originating interface records. A typical query joins to the interface table to see the offending data alongside its error text.

• List all errors for a given interface record: SELECT * FROM IGS.IGS_AD_OFFRESP_ERR WHERE OFFRESP_INT_ID = :id;
• Summarize errors by code for a run: SELECT ERROR_CODE, COUNT(*) FROM IGS.IGS_AD_OFFRESP_ERR WHERE REQUEST_ID = :request_id GROUP BY ERROR_CODE;
• Trace errors to concurrent request context using REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID.
• Reporting: produce an error log per import run, and identify high-frequency error codes for data-quality remediation.

The standard extraction query selects all 13 columns from IGS.IGS_AD_OFFRESP_ERR, as documented in the ETRM query text.

Related Objects

• IGS.IGS_AD_OFFRESP_INT — The interface table containing Offer Response records; joined via OFFRESP_INT_ID = IGS_AD_OFFRESP_INT.OFFRESP_INT_ID (documented foreign key). This is the most significant relationship.
• Offer Response Import concurrent program — The process that populates this table; its REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, and PROGRAM_UPDATE_DATE columns reference FND concurrent request metadata.
• FND_CONCURRENT_REQUESTS / FND_CONCURRENT_PROGRAMS — Standard Oracle Application Object Library tables usable to resolve REQUEST_ID and PROGRAM_ID to submission details.
• IGS_ADM_APPLICATION business entity — The category under which this object is registered, tying it to the admissions application domain.
• IGS_AD_OFFRESP_ERR_PK and IGS_AD_OFFRESP_ERR_N1 — Indexes supporting unique identification and efficient lookup by interface identifier.