Search Results pending_outcome_status

Overview

The IGS_UC_DEFAULTS table is a configuration table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the IGS (Student Systems) schema. Its primary role is to store a single, system-wide record of default values applied during the import of UCAS (Universities and Colleges Admissions Service) application records into the Oracle Student System (OSS). This table acts as a central control point, ensuring consistency by providing predefined values for critical calendar and process parameters when processing incoming UCAS data. Its status is VALID, and it is stored in the APPS_TS_TX_DATA tablespace.

Key Information Stored

The table's columns can be categorized into functional groups, with a significant portion marked as obsolete. The SYSTEM_CODE column, part of the primary key, likely identifies the specific institutional or system context for the defaults. A critical non-obsolete column is CURRENT_INST_CODE, which holds the current institution code. Other active columns include UCAS_ID_FORMAT for future formatting rules and a set of TEST_* columns (TEST_APP_NO, TEST_CHOICE_NO, TEST_TRANSACTION_TYPE) used for validating offer conditions. Notably, numerous calendar-related columns are documented as obsolete, including ACA_CAL_ALT_ID, ADM_CAL_TYPE, DEF_ACA_CAL_SEQ_NO, and DEF_ADM_CAL_ALT_ID. The ADM_PROC_CAT and ADM_PROC_TYPE columns are also obsolete, as referenced in a specific change control document.

Common Use Cases and Queries

The primary use case is the UCAS data import process, where the system references the single record in this table to populate missing calendar and institutional data. A common operational query would retrieve all current default settings for review or audit purposes. Given the user's search for "obsolete_outcome_status," it is pertinent to note that while this specific column is not present in IGS_UC_DEFAULTS, the table's metadata clearly indicates a pattern of columns being marked obsolete, suggesting a legacy design. Sample queries include retrieving the active institution code or the testing parameters for offer validation.

• Retrieve all default values: SELECT * FROM igs.igs_uc_defaults;
• Retrieve current institution and test parameters: SELECT current_inst_code, test_app_no, test_choice_no FROM igs.igs_uc_defaults;
• Identify obsolete columns: SELECT column_name FROM all_tab_columns WHERE table_name = 'IGS_UC_DEFAULTS' AND owner = 'IGS' AND column_name LIKE '%OBSOLETE%';

Related Objects

The table is centrally linked to the UCAS application import process within OSS. Its unique primary key index, IGS_UC_DEFAULTS_PK, is built on the SYSTEM_CODE column and resides in the APPS_TS_TX_IDX tablespace. The table is a foundational FND Design Data object (IGS.IGS_UC_DEFAULTS), indicating it is registered within the EBS framework. It is logically related to the UCAS interface tables and the programs that consume these defaults during data transformation and loading. The documented obsolete columns, such as those for admission process category and type, were likely referenced by older versions of these import programs or related setup tables before being superseded.