Search Results sevis_site_of_activity

Overview

IGS_SV_BATCH_PROCESS_PKG is the core batch-processing engine within the Oracle EBS Student Information Systems (SIS) module responsible for gathering, validating, packaging, and transmitting SEVIS (Student and Exchange Visitor Information System) data to the U.S. government. The package body header, dated October 2002 and authored by Don Shellito, states that its purpose is the "processing and gathering of the SEVIS related information that is to be sent for transmital." It exposes globally the concurrent programs that drive SEVIS batch operations while keeping all other procedures internal.

A significant portion of the package concerns SEVIS address usage values introduced under bug 2630743. Three constants govern the classification of addresses: g_us_addr_usage (SEVIS_PRIMARY_US), g_f_addr_usage (SEVIS_PRIMARY_FOREIGN), and g_site_addr_usage (SEVIS_SITE_OF_ACTIVITY). The term the user searched for, sevis_site_of_activity, corresponds directly to this last constant, which the package uses to identify the SEVIS Site of Activity address — the location where a nonimmigrant student or exchange visitor actually performs their program activity, as distinct from their primary U.S. or foreign address.

Key Procedures and Functions

Ten documented procedures and functions make up the package's public surface:

• EV_BATCH_PROCESS — Processes Exchange Visitor batch records for transmittal to SEVIS.
• NIMG_BATCH_PROCESS — Processes Nonimmigrant (NIMG) student batch records for SEVIS transmittal.
• EV_PURGE_BATCH — Purges processed Exchange Visitor batch data.
• NIMG_PURGE_BATCH — Purges processed Nonimmigrant student batch data.
• PROCESS_TRANS_HEADER — Builds and manages the SEVIS transaction header records used for batch assembly.
• PROCESS_TRANS_ERRORS — Captures and handles errors encountered during SEVIS transaction processing.
• PROCESS_STUDENT_RECORD — Assembles an individual student's SEVIS data, including address classifications such as the Site of Activity.
• PROCESS_DEP_RECORD — Assembles SEVIS data for a dependent associated with a student or exchange visitor.
• GENERATE_BATCH_XML — Produces the XML payload required by SEVIS for batch submission.
• ASSIGN_DSO — Assigns the Designated School Official (DSO) responsible for a given record.

Tables Accessed

The package reads and writes HZ_PARTIES, HZ_PERSON_PROFILES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_LOCATIONS, HZ_CITIZENSHIP, and HZ_RELATIONSHIPS to resolve person identity, addresses (including the SEVIS Site of Activity usage), citizenship, and dependent relationships. IGS_PE_ACT_SITE supplies Site of Activity data, while IGS_EN_SVS_AUTH holds SEVIS authorization and school/Official identifiers. EDI/ECX interface tables — ECX_EXT_PROCESSES, ECX_TP_DETAILS, ECX_TP_HEADERS, and ECX_TRANSACTIONS — store the assembled outbound transactions. FND_USER and FND_LOOKUP_VALUES resolve the submitting user and seeded lookup values. Historical fixes record that FND user customer IDs were replaced by person party IDs (bug 4293911) and that the status column was used for addresses during validation (bug 3227107).

Usage Notes

The package is invoked primarily by SEVIS-related concurrent programs submitted from Oracle EBS, which it declares globally. Institutions running Oracle EBS 12.1.1 or 12.2.2 schedule the batch process programs to assemble and transmit SEVIS records, and the corresponding purge programs to remove processed data afterward. Custom code should not call internal procedures; documented public procedures should be used only as the concurrent programs invoke them. No other packages reference this package, confirming its role as a top-level SEVIS batch driver rather than a shared utility.