Search Results igs_uc_proc_application_data




Overview
Explore in AI Chat

Overview

IGS_UC_PROC_APPLICATION_DATA is an APPS-owned PL/SQL package within the Oracle E-Business Suite student systems product family, specifically the UK UCAS (Universities and Colleges Admissions Service) integration component of the IGS (Student System) schema. The package resides in the APPS schema and holds a VALID status, confirming it is a deployed and compiled database object. Its name and structure indicate it serves as a processing engine for inbound application data received from the UCAS clearing and admissions channels, transforming and staging that data for loading into the Oracle Student System application tables.

The package is part of the broader IGS_UC family of objects that manage the interface between external admissions sources and the local student records. It is referenced by IGS_UC_PROC_UCAS_DATA, which acts as a higher-level driver, and is itself self-referential through the dependency listing. Only a small dependency footprint is recorded, with a direct reference to the SYS.STANDARD package, indicating standard PL/SQL runtime behaviour rather than reliance on a large set of external application APIs.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions, most of which share the PROCESS_IV prefix, indicating an "*IV" (inbound processing) naming convention. These routines isolate handling of distinct UCAS record categories:

No parameter lists are documented in the available metadata; therefore the precise invocation signatures should be confirmed against the deployed package specification. The procedures collectively perform validation, code mapping and staging of incoming application data.

Tables Accessed

The package references application tables through APPS synonyms, grouped into three functional categories:

Usage Notes

IGS_UC_PROC_APPLICATION_DATA is not an end-user API; it is an internal processing package invoked by the higher-level package IGS_UC_PROC_UCAS_DATA during the UCAS data load cycle. Typical invocation occurs through concurrent programs that import and process UCAS transmissions, most commonly in scheduled admissions batch runs. The APPL_DATA_SETUP routine is expected to be called first to establish control and setup context before the individual PROCESS_IV routines execute against staged records.

Because the dependency metadata records only one referencing package, customisations should avoid calling these routines directly unless the calling program also replicates the setup and control context expected by the driver. All behaviour is identical between Oracle EBS 12.1.1 and 12.2.2, as the IGS schema and its UCAS integration objects are shared across both releases. Developers investigating errors from this package should begin with the IGS_AD_INTERFACE_CTL and IGS_AD_IMP_BATCH_DET records to correlate failures with specific inbound batches.