Search Results igs_ad_apl_int_s

Overview

IGS_UC_EXPORT_TO_OSS is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema, classified as OTHER in the ETRM repository and validated in both 12.1.1 and 12.2.2 environments. Its functional remit sits within the Oracle Student System (formerly Student Administration) admissions module, specifically the UCAS (Universities and Colleges Admissions Service) integration layer. The name identifies it as the outbound half of an interoperability exchange: it exports admissions records maintained in the local UC tables into the Open Student System (OSS) admissions interface tables. In operational terms, the package converts locally staged applicant and choice data into the standard admissions interface structures that downstream validation and import concurrent programs consume, so that applications received through the UCAS route are promoted into the institution's core admissions tables. The "IGS_UC_" prefix confirms the package belongs to the UCAS-specific component set, while "EXPORT_TO_OSS" denotes data movement outward from those staged tables into the generic student-system interface.

Key Procedures and Functions

The ETRM metadata documents a single entry point: MAIN_PROCESS. Consistent with the naming convention of the IGS public package family, MAIN_PROCESS is the driver routine invoked to execute the export in its entirety. It orchestrates the read of staged UCAS data, applies the mapping rules defined by configuration tables such as IGS_UC_MAP_OFF_RESP and IGS_UC_MAP_OUT_STAT, and writes corresponding rows into the admissions interface tables. Parameter lists are not exposed in the repository metadata and should not be assumed; callers should obtain the live signature from the package specification in the target environment. Error handling is achieved through the dependent packages APPS.APP_EXCEPTION and IGS_GE_MSG_STACK, and user-facing status is produced via FND_MESSAGE and FND_FILE, indicating concurrent-program style logging to the output and log files.

Tables Accessed

The package reads its source data from the UC staging tables IGS_UC_APPLICANTS and IGS_UC_APP_CHOICES, which hold the applicant record and the associated choice records respectively. Party attributes are resolved through HZ_PARTIES and HZ_PERSON_PROFILES, using the IGS_PE_HZ_PARTIES and IGS_PE_PERSON wrapper views. Configuration and control information is drawn from IGS_AD_BATC_DEF_DET_ALL, IGS_AD_BATC_DEF_DET_PKG, IGS_AD_INTERFACE_CTL and IGS_AD_INTERFACE_CTL_S. The principal write targets are the admissions interface structures IGS_AD_APL_INT and its sequence IGS_AD_APL_INT_S — the object named in the user's search — together with IGS_AD_ADMDE_INT and IGS_AD_ADMDE_INT_ALL. Supporting reference data includes IGS_AD_APPL_ALL, IGS_AD_CODE_CLASSES, IGS_AD_IMP_BATCH_DET, IGS_AD_INTERFACE_BATCH_ID_S, IGS_AD_OU_STAT, IGS_AD_SS_APPL_TYP and the programme and unit-set tables under IGS_PS_ and IGS_EN_. Status and response mapping is performed against IGS_UC_MAP_OFF_RESP, IGS_UC_MAP_OUT_STAT and IGS_UC_OLD_OUSTAT via IGS_UC_OLD_OUSTAT_PKG.

Usage Notes

IGS_UC_EXPORT_TO_OSS is referenced by zero other packages in the repository, confirming it is a top-level entry point rather than a shared utility. It is expected to be registered as a concurrent program in the Student System responsibility, scheduled after UCAS data has been loaded and validated, and before the standard admissions interface import runs. Because it depends on FND_REQUEST, it may also be submitted programmatically from custom code or from a form-level button. Institutions should verify the package version after applying admissions patches, since the interface table layouts in IGS_AD_APL_INT and IGS_AD_ADMDE_INT are the contract between this exporter and the subsequent import process.