Search Results reply_code




Overview
Explore in AI Chat

Overview

The IGS_UC_MAP_OFF_RESP table is a critical configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for institutions using the UCAS (Universities and Colleges Admissions Service) integration in the Oracle Student Management (OSM) product suite. Its primary role is to act as a translation or mapping layer between external UCAS decision and reply codes and the internal Oracle Admissions offer response status codes. This mapping is essential for the automated processing of applicant communications and status updates received from the UCAS system, ensuring data integrity and consistent status tracking within the EBS application.

Key Information Stored

The table stores discrete mapping records defined by a unique combination of key columns and associated control data. The most important columns include:

  • SYSTEM_CODE, DECISION_CODE, REPLY_CODE: Together, these three columns form the composite primary key (IGS_UC_MAP_OFF_RESP_PK). They identify a specific UCAS transaction context: the admissions system, the decision code (e.g., conditional offer, unconditional offer), and the applicant's reply code.
  • ADM_OFFER_RESP_STATUS: This is the target internal status code within Oracle Admissions (referencing the IGS_AD_OFR_RESP_STAT lookup) that corresponds to the UCAS code combination.
  • CLOSED_IND: A flag (default 'N') that controls the active status of the mapping record, allowing administrators to invalidate mappings without deleting them.
  • Standard WHO Columns (CREATED_BY, CREATION_DATE, etc.): Audit columns tracking the creation and last update details for the record.

Common Use Cases and Queries

The primary use case is the real-time or batch processing of UCAS data feeds. When an applicant's decision or reply is received from UCAS, the application queries this table to determine the appropriate internal offer response status to apply. A common reporting need is to audit or verify the configured mappings. A sample query to retrieve all active mappings for a specific system would be: SELECT system_code, decision_code, reply_code, adm_offer_resp_status FROM igs.igs_uc_map_off_resp WHERE closed_ind = 'N' AND system_code = :p_system_code ORDER BY 1,2,3; Another critical query pattern involves joining to the related lookup tables to get descriptive meaning for the codes, which is essential for support and configuration screens.

Related Objects

IGS_UC_MAP_OFF_RESP is a central reference table with defined foreign key relationships to ensure data validity. Key related objects include:

  • Primary Key: IGS_UC_MAP_OFF_RESP_PK on (SYSTEM_CODE, DECISION_CODE, REPLY_CODE).
  • Foreign Key (Reference To): The ADM_OFFER_RESP_STATUS column references the IGS_AD_OFR_RESP_STAT lookup table, validating the internal status code.
  • Foreign Key (Reference To): The SYSTEM_CODE column references the IGS_UC_SYS_DECISION table, validating the UCAS system identifier.
  • Referenced By: The table is referenced by objects within the APPS schema, indicating it is integral to the application logic, likely through views or APIs that encapsulate the mapping logic for UCAS integration processes.
These relationships enforce that only valid, pre-defined internal statuses and system codes can be used in the mapping configuration.