Search Results igs_he_import_data




Overview
Explore in AI Chat

Overview

The APPS.IGS_HE_IMPORT_DATA package is a PL/SQL API belonging to the Oracle E-Business Suite Higher Education (HE) module. It serves as a batch-oriented data import utility responsible for processing inbound records held in the HE interfacing tables and transferring them into the institution's core student and person records. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the calling schema rather than the defining schema, a common pattern in Oracle EBS for interface packages that must respect the invoker's security context.

The package header carries a version marker (115.1) and a 2002 copyright header, confirming it as a long-standing component of the Student Systems (IGS) product family. Its API classification is documented as OTHER, indicating it is not a formally published public API but rather an internal processing engine intended to be driven by a concurrent program or batch scheduler.

Key Procedures and Functions

The ETRM metadata documents a single entry point: MAIN_PROCESS. This is the master driver procedure for the package. It accepts standard concurrent-program output parameters (ERRBUF and RETCODE) used to communicate log messages and completion status back to the concurrent manager, along with a batch identifier (P_BATCH_ID) and two mode or detail-control parameters (P_PERS_DET and P_SPA_DET). Parameter lists are not enumerated in full here, but the presence of a batch ID establishes that processing is scoped to a single logical load run — typically a set of rows staged by a prior interface/population step. The flags likely govern whether person-level and address or specialization detail is imported. No other procedures or functions are documented in the ETRM entry, so MAIN_PROCESS is the sole supported invocation surface.

Tables Accessed

The package reads and writes a broad set of HE and Trading Community (HZ) tables through APPS synonyms. The batch control table IGS_HE_BATCH_INT anchors the run and is referenced by the batch ID parameter. Person and party data flow into HZ_PARTIES, HZ_PERSON_PROFILES, and HZ_CITIZENSHIP, indicating that imported records create or update person parties, profiles, and citizenship details. Academic history and admissions records are handled via the interface staging tables IGS_AD_INTERFACE_ALL, IGS_AD_INTERFACE_S, IGS_AD_INTERFACE_CTL, IGS_AD_INTERFACE_BATCH_ID_S, and the academic history interface tables IGS_AD_ACADHIS_INT_ALL and IGS_AD_ACADHIS_INT_S. Supplementary staging tables IGS_AD_API_INT_S, IGS_AD_DISABLTY_INT_S, and IGS_AD_STAT_INT_S carry academic period, disability, and status information respectively. IGS_AD_IMP_BATCH_DET holds batch detail control. Grade scheduling data is sourced from IGS_AS_GRD_SCH_GRADE. Collectively these tables show the package bridging staged external data into normalized HE records.

Usage Notes

IGS_HE_IMPORT_DATA is not referenced by any other documented package, confirming it is a terminal consumer rather than a shared library. It is therefore invoked either directly by a concurrent program registered against MAIN_PROCESS or from custom wrapper code that supplies the batch ID and processing flags. In Oracle EBS 12.1.1 and 12.2.2, such interface packages are scheduled after an import/extract step populates the IGS_AD_* interface tables, and they must be run before downstream validation and posting programs. Because the package relies on APPS synonyms and runs under invoker's rights, callers should ensure the responsibility and security context permit access to the HZ and IGS tables listed above. Failures or rejected rows are reported through the standard ERRBUF/RETCODE concurrent parameters, and any custom invocation should honor these outputs for error handling.