Search Results party_site_name




Overview
Explore in AI Chat

Overview

The IGS_SV_EV_DEL_SOA_BLK_V view is a seeded Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the IGS — Student System product family. Its documented purpose is to support the deletion of Site of Activity (SOA) information for Exchange Visitors, a requirement in SEVIS-related processing for J-1 exchange visitor address management. Rather than storing data itself, the view acts as a filtered, presentation-ready projection over the Exchange Visitor address staging tables, exposing only those records flagged for a delete operation.

Because the object is a view, it carries no independent persistence. It is intended to be consumed by concurrent programs, forms-based delete logic, or integration routines that submit batch processing for SOA records flagged with a delete action. In the context of Oracle EBS 12.1.1 and 12.2.2, such views typically serve as the data source for a batch block (hence the "_BLK_V" suffix) used to drive DELETE operations or to feed downstream SEVIS batch files.

Underlying Base Objects

The view is defined over a single documented base object, IGS_SV_ADDRESSES (aliased as UADD in the view text). The documented metadata lists no additional referenced base objects. The view applies three filter predicates to that table:

  • ADDRESS_TYPE = 'A' — restricts rows to a specific address type classification maintained in the Exchange Visitor address table.
  • ACTION_TYPE = 'D' — restricts rows to records flagged for deletion.
  • ACTIVITY_SITE_CD IS NOT NULL — ensures only records that carry a populated Site of Activity code are included, excluding address rows that are not tied to an activity site.

The result is a narrow working set of Exchange Visitor address records scheduled for SOA deletion.

Key Columns

  • BATCH_ID — Identifier of the batch to which the address record belongs; supports grouping and batch-level processing of deletions.
  • PERSON_ID — The party/person identifier of the Exchange Visitor, linking to person-level records.
  • PARTY_SITE_ID — The party site identifier of the address record and the primary key reference used in SOA deletion.
  • REMARKS — Free-text remarks associated with the address record, carried through to the delete block.
  • PARTY_SITE_NAME — A derived, display-friendly concatenation built as ADDRESS_LINE1 || '-' || CITY || '-' || PARTY_SITE_ID. This is the column most directly relevant to searches for "party_site_name": it is not a stored attribute of the base table but is synthesized within the view to give a human-readable label for each site.

Common Use Cases and Queries

The principal use case is identifying and processing Exchange Visitor Site of Activity records marked for deletion. Typical usage includes verification, reporting, and batch driver queries.

Listing all pending SOA deletions:

SELECT batch_id, person_id, party_site_id, party_site_name, remarks
FROM   apps.igs_sv_ev_del_soa_blk_v
ORDER BY batch_id, person_id;

Retrieving the party site name for a specific person or site:

SELECT party_site_name, party_site_id
FROM   apps.igs_sv_ev_del_soa_blk_v
WHERE  person_id = :person_id;

Because PARTY_SITE_NAME is derived in the view, it can be matched with a LIKE predicate for ad-hoc identification, though partitioned access by PERSON_ID or BATCH_ID is preferable for performance. Organizations integrating with SEVIS should use this view strictly as a read source for delete-driven batch logic, since it exposes only rows already flagged with ACTION_TYPE = 'D'.