Search Results igs_sv_batch_process_pkg




Overview
Explore in AI Chat

Overview

IGS_SV_BATCH_PROCESS_PKG is an Oracle EBS Student System package that supports SEVIS (Student and Exchange Visitor Information System) processing. SEVIS is the United States Department of Homeland Security system used by institutions to report and track international students (Non-Immigrant Students, or NIMG) and Exchange Visitors (EV) holding F, M, and J visa classifications. The package header, authored by Don Shellito and first created in October 2002, states its purpose explicitly: it is used "for the processing and gathering of the SEVIS related information that is to be sent for transmital." In practice the package assembles batch data, validates records, generates the XML payload transmitted to SEVIS, and processes the transaction responses and errors returned by that external system. It is classified under the ETRM as a general "OTHER" API object, meaning it is not a formally published open interface but a supporting processing engine. The concurrent programs it drives are defined globally within the package, while all other procedures are defined internally, indicating that the primary public entry points are the batch and purge routines.

Key Procedures and Functions

The documented package exposes ten procedures. Their names and roles are as follows.

  • EV_BATCH_PROCESS — Concurrent program entry point that gathers and processes Exchange Visitor data for SEVIS transmittal.
  • NIMG_BATCH_PROCESS — Concurrent program entry point that gathers and processes Non-Immigrant Student data for SEVIS transmittal.
  • EV_PURGE_BATCH — Purges processed Exchange Visitor batch data.
  • NIMG_PURGE_BATCH — Purges processed Non-Immigrant Student batch data.
  • PROCESS_TRANS_HEADER — Processes the header record of a SEVIS transaction.
  • PROCESS_TRANS_ERRORS — Processes error information returned against SEVIS transactions. This is the procedure most commonly sought by users searching on "process_trans_errors," since it handles the error detail associated with a transmitted batch.
  • PROCESS_STUDENT_RECORD — Builds and processes an individual student record for inclusion in a SEVIS batch.
  • PROCESS_DEP_RECORD — Builds and processes a dependent record associated with a student or exchange visitor.
  • GENERATE_BATCH_XML — Generates the XML document representing the assembled batch for transmittal to SEVIS.
  • ASSIGN_DSO — Assigns a Designated School Official (DSO) to the relevant SEVIS processing records.

Tables Accessed

The package reads and writes data through APPS synonyms spanning several EBS schemas. Person and party data comes from the HZ tables: HZ_PARTIES, HZ_PERSON_PROFILES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_LOCATIONS, HZ_CITIZENSHIP, and HZ_RELATIONSHIPS, which supply biographical, address, citizenship, and dependent relationship information. SEVIS-specific setup and authorization data is held in IGS_EN_SVS_AUTH and related IGS tables such as IGS_PE_ACT_SITE. The e-commerce/XML gateway tables ECX_EXT_PROCESSES, ECX_TP_DETAILS, ECX_TP_HEADERS, and ECX_TRANSACTIONS support transaction generation, transmission, and error capture. FND_LOOKUP_VALUES supplies lookup validation and FND_USER identifies the DSO and processing user.

Usage Notes

IGS_SV_BATCH_PROCESS_PKG is typically invoked through Oracle EBS concurrent programs rather than directly from a form. The batch and purge procedures follow the standard concurrent program signature, accepting the OUT errbuf and retcode parameters along with control flags such as validate-only and organization/DSO context. Because the package is documented as referenced by zero other packages, it functions as a top-level processing engine rather than a shared utility. Custom code should call the documented entry points only; internal procedures are implementation-specific and subject to change between releases. The $Header$ value of 120.2 indicates the last file revision shipped at the time of documentation.