Search Results igs_uc_proc_ucas_data




Overview
Explore in AI Chat

Overview

IGS_UC_PROC_UCAS_DATA is an APPS-owned PL/SQL package within the Oracle E-Business Suite Student Systems (IGS) product family, specifically belonging to the UCAS (Universities and Colleges Admissions Service) integration subsystem. UCAS is the United Kingdom centralised admissions service through which applicants apply to higher education institutions, and Oracle Student Systems provides a set of packages to import, transform, and process the UCAS applicant and reference data that institutions receive electronically. This package serves as the processing engine that takes externally supplied UCAS reference and application data and drives it through the institution's staging and validation logic. The package is classified as OTHER in the ETRM API classification scheme, meaning it is not a formally published open interface or public API but an internal processing routine intended for controlled invocation within the UCAS data-loading workflow.

Key Procedures and Functions

Three documented procedures constitute the public interface of this package:

  • PROCESS_UCAS_DATA — the primary driver procedure. It accepts a processing reference-data indicator parameter and a processing application-data indicator parameter, together with the standard concurrent-program OUT parameters errbuf and retcode. Its purpose is to process UCAS data according to the supplied reference and application data selection flags, coordinating the extraction, validation, and staging of inbound UCAS records.
  • LOG_PROC_COMPLETE — a logging utility invoked at the conclusion of a processing run. It records the outcome of the run using a view name and the counts of successfully processed records and errored records, providing an audit trail of each processing execution.
  • LOG_ERROR_MSG — an error-logging procedure that accepts an error code typed against IGS_UC_UINST_INTS.ERROR_CODE. It records individual error conditions encountered during processing so that operators can diagnose and correct failed UCAS records.

Tables Accessed

The package references the table IGS_UC_UINST_INTS through an APPS synonym. This is the UCAS institution interaction or interface staging table that holds inbound UCAS records and their associated error codes. PROCESS_UCAS_DATA reads staged UCAS data from this table, while LOG_ERROR_MSG writes or updates error-code information against it. The error_code column of this table is used as the anchored datatype for the error-logging procedure, confirming a direct dependency between the package's error handling and the staging table structure.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is most commonly invoked from a concurrent program within the UCAS processing responsibility, consistent with the errbuf/retcode OUT parameter signature of PROCESS_UCAS_DATA, which is the standard convention for PL/SQL concurrent program entry points. The two IN flags allow operators to run reference-data processing, application-data processing, or both in a single execution. The package is also referenced by three other packages, indicating it participates in a wider UCAS processing chain and may be called programmatically rather than only through the concurrent manager. Because it is classified as OTHER and carries no public API contract, direct custom calls should be avoided; integrations should be routed through the delivered UCAS concurrent programs so that logging via LOG_PROC_COMPLETE and LOG_ERROR_MSG remains consistent and auditable.