Search Results igs_ad_imp_near_mtch_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_IMP_NEAR_MTCH_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the near-match identification and duplicate-detection features of the Oracle Student System (formerly Oracle iLearning/Student Administration) Admissions module. Its name reflects its role: it manages the "near match" records generated when incoming admission applicant data is compared against existing person and address records in the system. When an admissions interface load identifies a probable duplicate or near match, the details of that candidate match are staged and processed through the entities this package controls. The package is classified under ETRM as an OTHER API type, meaning it is primarily an internal utility package rather than a public, documented integration API. It serves as the table-handler layer for the near-match staging tables, encapsulating the standard row-level operations (insert, lock, update, delete) and referential-integrity validation required to maintain those tables consistently.

Key Procedures and Functions

The package exposes twelve documented procedures and functions that follow the conventional Oracle Forms-generated table-handler pattern:

Tables Accessed

The package operates against two documented tables, accessed through APPS synonyms: IGS_AD_IMP_NEAR_MTCH_ALL, the base (all-organizations) table that stores the detailed near-match candidate records, and IGS_AD_IMP_NEAR_MTCH_S, its security/sequence-related companion table. The ALL table holds the substantive near-match data written during the admissions import process, while the _S table typically supports primary-key generation or row-level security. Foreign-key lookups reach the admissions interface table, the address type reference, the person match sets, and the person entity, confirming that the package links staged near-match rows back to the originating interface load and to the matched person records.

Usage Notes

IGS_AD_IMP_NEAR_MTCH_PKG is referenced by three other packages — IGS_AD_INTERFACE_PKG, IGS_PE_IDENTIFY_DUPS, and the concurrent-program support the IGS_AD_IMP_009 load — as well as being self-referenced. It is therefore invoked indirectly whenever the admissions interface processes applicant records and performs duplicate/near-match evaluation, rather than being called directly by end users. The near-match results it maintains are typically surfaced to users through the Student System admissions forms, where a user reviews candidate duplicates and decides whether to accept or reject a match. Because the package is an internal, Forms-style table handler and not a certified public API, customizations should avoid calling it directly; integrations should instead use the higher-level IGS_AD_INTERFACE_PKG and duplicate-identification entry points. This behavior is consistent across both Oracle EBS 12.1.1 and 12.2.2, as the underlying Student System data model is unchanged between those releases.