Search Results export_data

Overview

The APPS.IGS_UC_EXPORT_UCAS_PKG package belongs to the Oracle E-Business Suite product family supporting the UK higher-education sector, commonly referred to as the Oracle Student System (IGS) module set. Specifically, the "IGS_UC" prefix identifies components that manage the interface between the institution's student records and the UCAS (Universities and Colleges Admissions Service) central admissions system. The package provides the mechanism by which admissions and applicant data held in the EBS database are extracted and formatted for transmission to UCAS, and it also facilitates the handling of inbound transaction files.

The documented API classification for this package is "OTHER," indicating it is not a general-purpose public API but a specialized utility intended for controlled batch execution. The single documented procedure, EXPORT_DATA, encapsulates the entire export workflow, accepting operational flags and status parameters rather than a granular set of business attributes. This design is typical of wrapper or driver packages that orchestrate a sequence of data-selection and file-generation steps.

Key Procedures and Functions

One procedure is documented within the package specification:

• EXPORT_DATA — This is the primary driver procedure for the UCAS export process. It declares standard concurrent-program output parameters (Errbuf and Retcode) which signal success or failure back to the concurrent manager, and it accepts several IN parameters that control which categories of data are included in an export run. The parameters p_contact, p_program_details, p_keywords, and p_abbreviations govern reference or descriptive content, while p_ucas_transactions, p_gttr_transactions, and p_nmas_transactions control the three principal UCAS transaction streams — the standard UCAS exchange, the GTTR (Graduate Teacher Training Registry) route, and the NMAS (Nursing and Midwifery Admissions Service) route. Each parameter allows the operator to selectively include or exclude the corresponding data set for a given export.

No additional procedures or functions are present in the documented specification, and no other packages are recorded as referencing this one.

Tables Accessed

The documented tables referenced via APPS synonyms are:

• IGS_UC_CYC_DEFAULTS — Stores cycle-level default settings for UCAS processing, consulted to determine institution-wide values such as the current admissions cycle, institution identifiers, and file-naming conventions used during export.
• IGS_UC_DEFAULTS — Holds the general configuration defaults for the UCAS interface, including directory locations, file-format options, and operational switches that influence how the export is generated.
• IGS_UC_UCAS_CONTROL — The control table governing the state and sequencing of UCAS transactions. It typically records which transaction records have been processed, their status, and the control flags used to prevent duplicate transmission.

Together these tables supply the runtime configuration and transactional context required by EXPORT_DATA before it produces output.

Usage Notes

IGS_UC_EXPORT_UCAS_PKG is normally invoked as a concurrent program rather than from an online form. Its Errbuf and Retcode parameters follow the standard EBS concurrent-program signature, and the input parameters are supplied through the concurrent program's parameter window or through a scheduling/set request. Typical execution occurs at defined points in the admissions cycle, when the institution must submit applicant and transaction data to UCAS, GTTR, or NMAS, or when a controlled re-export is required after data correction.

Because the package is classified as "OTHER" and is referenced by no other documented packages, it should not be called from custom code without careful analysis of the underlying implementation. Administrators should verify the configuration in IGS_UC_DEFAULTS and IGS_UC_CYC_DEFAULTS and confirm the state of IGS_UC_UCAS_CONTROL before each run to ensure that only the intended transaction streams are exported and that records are not submitted more than once.