Search Results main_process

Overview

IGS_UC_EXPORT_TO_OSS is an Oracle EBS Student System / Admissions (Recruiting and Admissions) PL/SQL package owned by the APPS schema. Its role is to export applicant and applicant choice data captured in the UC (Universities and Colleges) admissions tables to the Oracle Student System (OSS) admissions interface tables, where the standard admissions import processes can validate and load the records into the core admissions model. In effect, it bridges the legacy UC admissions capture schema (IGS_UC_APPLICANTS, IGS_UC_APP_CHOICES) with the integration staging area used by the OSS admissions interface. The package is classified as OTHER in the ETRM metadata, meaning it is not published as a public read-only API; it is an internal integration utility. Declared with AUTHID CURRENT_USER, it executes with the privileges of the calling database user.

Key Procedures and Functions

The package exposes a single documented procedure:

• MAIN_PROCESS — the entry point that performs the export of an applicant and the associated choice. It accepts a standard concurrent-program style error buffer and return code, plus an applicant number and a choice number identifying the specific UC applicant record and choice to be transferred. The error buffer and return code follow the standard OSS/EBS concurrent processing signature so that errors can be surfaced to the concurrent manager log and to the request completion status. On invocation it reads the specified UC applicant and choice, maps and validates the data, and inserts the corresponding rows into the OSS admissions interface staging tables.

No other public procedures or functions are documented for this package. Because the actual data-mapping loops are not enumerated in the metadata, the internal logic should be treated as opaque; integrations should only call MAIN_PROCESS.

Tables Accessed

The package reads source data from the UC admissions tables and writes to the OSS admissions interface tables via APPS synonyms:

• IGS_UC_APPLICANTS — the UC applicant header, keyed by app_no; supplies personal and application data.
• IGS_UC_APP_CHOICES — the applicant choice line, keyed by choice_no; supplies the specific programme/choice being exported.
• IGS_AD_APPL_ALL — the OSS admissions application base table, the ultimate target model.
• IGS_AD_APL_INT, IGS_AD_APL_INT_S, IGS_AD_ADMDE_INT_ALL, IGS_AD_IMP_BATCH_DET — admissions interface staging tables for applications and admission details, populated during the export.
• IGS_AD_INTERFACE_CTL, IGS_AD_INTERFACE_CTL_S, IGS_AD_INTERFACE_BATCH_ID_S, IGS_AD_BATC_DEF_DET_ALL, IGS_AD_CODE_CLASSES — interface control, batch definition, batch identifier and code/class reference tables used to drive and validate the export batch.
• HZ_PARTIES, HZ_PERSON_PROFILES — Trading Community Architecture person tables, used to resolve or create the person party and profile associated with the applicant.
• FND_NEW_MESSAGES — the EBS message repository, used to resolve error/warning text raised during processing.

Usage Notes

IGS_UC_EXPORT_TO_OSS is an internal integration routine and is not referenced by any other documented package (referenced by 0 other packages). It is typically invoked from a custom concurrent program or wrapper that iterates over the UC applicants and choices to be exported and calls MAIN_PROCESS once per applicant/choice pair, passing the applicant and choice identifiers. The ERRBUF/RETCODE out parameters allow the wrapper to capture failures and mark the concurrent request accordingly. Server version header (IGSUC20S.pls 115.5) indicates the package dates from the 11i/early R12 era and remains present in 12.1.1 and 12.2.2. Because it is an OTHER-classified, undocumented public API, direct calls should be avoided where a supported API exists; custom code should call it only through a controlled concurrent program after validating that the target interface tables are not in use by other admissions interface processes.