Search Results find_duplicates

Overview

IGS_PE_DUP_PERSON is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an OTHER API. It belongs to the Higher Education / Student System product family, as indicated by the IGS_ prefix, and is used primarily for prospect and person data management. Its central responsibility is the identification of duplicate person records during data entry, a common requirement in recruitment, admissions, and student registration workflows where the same individual may otherwise be created multiple times.

The package exposes a single documented procedure, FIND_DUPLICATES, which accepts identifying attributes of a person and returns an indication of whether one or more matching records already exist. The package therefore acts as the matching engine behind duplicate-checking functionality, allowing calling programs to detect potential duplicates before committing a new person record.

Key Procedures and Functions

• FIND_DUPLICATES — The sole documented procedure in the package. It evaluates a candidate person's identifying characteristics — surname, given names, birth date, sex, and optionally an existing person ID and a preferred alternate identifier — against the set of configured matching rules. It returns an OUT parameter indicating whether a duplicate was found, an OUT parameter containing a dynamically constructed WHERE clause reflecting the match criteria, and an IN OUT parameter indicating whether the match was exact or partial. The match behavior is driven by a match set identifier passed in by the caller.

No public functions are documented in the ETRM metadata; the package interface is entirely procedural.

Tables Accessed

• HZ_PARTIES — The central TCA (Trading Community Architecture) table storing party records. It is the primary source against which candidate duplicate persons are compared.
• IGS_PE_MATCH_SETS_ALL — Stores the definitions of match sets, which group the matching rules applied during duplicate detection. The match set ID passed into FIND_DUPLICATES selects the applicable rule configuration.
• IGS_PE_MTCH_SET_DATA_ALL — Stores the individual match criteria data associated with each match set, such as which attributes participate in matching and the matching thresholds or operators.
• DBMS_SQL — The Oracle-supplied dynamic SQL package, used to construct and execute the dynamically generated query, which is consistent with the procedure returning a WHERE clause to the caller.

Usage Notes

IGS_PE_DUP_PERSON is typically invoked from person entry forms and related UI components within the Student System, where it is called during or after entry of a person's biographical details to warn the user of potential duplicates. It may also be called from concurrent programs, batch data-load routines, or custom integration code that imports person records and needs to avoid creating duplicates.

Callers must supply a valid match set ID and the person attributes to be evaluated. The returned duplicate flag, WHERE clause, and exact/partial indicator allow the caller to decide whether to block creation, present a warning, or proceed. Because the procedure generates and executes dynamic SQL, performance is sensitive to the configuration of the match set and the volume of data in HZ_PARTIES; proper indexing and carefully scoped match rules are important. The package is referenced by one other package per the ETRM metadata, indicating it is embedded within the broader person-management call stack rather than being an end-user-facing entry point.