Search Results is_fa_base_record_present

Overview

IGF_AP_MATCHING_PROCESS_PKG is a PL/SQL package owned by the APPS schema that forms the core of the matching engine within the Oracle E-Business Suite Financial Aid module (also referred to as the Oracle Student System / FinAid components delivered under the IGF application short name). Its principal business function is to reconcile imported ISIR (Institutional Student Information Record) data against existing person, party, and financial aid base records in the EBS database, and to produce matched and unmatched result sets that downstream eligibility, packaging, and disbursement processes consume.

The package sits at the intersection of the inbound ISIR interface tables and the permanent Financial Aid record structures. It normalizes incoming data (Social Security Numbers, dates, numeric fields), evaluates each student against the HZ party model, writes match detail and match result rows, and maintains records that flag whether a student matches a base Financial Aid record. It additionally supports NSLDS data creation and the refresh of previously computed match results. In ETRM 12.1.1 documentation the package is classified with API classification OTHER and exposes sixteen documented procedures and functions, listed in the ETRM metadata.

Key Procedures and Functions

The documented entry points partition into control, conversion, and record-maintenance groups.

• MAIN — the primary driver procedure that orchestrates the end-to-end matching run.
• FORMAT_SSN, CONVERT_NEGATIVE_CHAR, REMOVE_SPL_CHR — data hygiene routines that normalize incoming values before comparison.
• CONVERT_TO_DATE and CONVERT_TO_NUMBER — datatype conversion helpers for ISIR interface fields delivered as character strings.
• IS_FA_BASE_RECORD_PRESENT — predicate that determines whether a Financial Aid base record already exists for a given student, central to the match decision.
• LOAD_MATCHED_ISIR, CREATE_ISIR_MATCHED, UPDATE_ISIR_INTRFACE — persist match outcomes and update the interface rows accordingly.
• CREATE_NSLDS_DATA — derives NSLDS-related records from matched ISIR data.
• CHECK_PTYP_CODE and GET_MSG_CLASS_FROM_FILENAME — validation and file/class parsing utilities.
• WRPR_AUTO_FA_REC, WRPR_UNMATCHED_REC, WRPR_REFRESH_MATCHES — wrapper procedures supporting automatic FA record creation, unmatched-record handling, and match refresh.

Tables Accessed

The package reads and writes interface and result tables including IGF_AP_ISIR_INTS_ALL, IGF_AP_ISIR_MATCHED_ALL, IGF_AP_MATCH_DETAILS, IGF_AP_RECORD_MATCH_ALL, IGF_AP_PERSON_MATCH_ALL, IGF_AP_FA_BASE_REC_ALL, IGF_AP_ISIR_CORR_ALL, IGF_AP_NSLDS_DATA_ALL, IGF_AP_BATCH_AW_MAP_ALL, and IGF_AP_PERSON_V. It also joins the Oracle Trading Community (HZ) model through HZ_PARTIES, HZ_PERSON_PROFILES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, HZ_LOCATIONS, and HZ_CONTACT_POINTS to resolve identities.

Usage Notes

IGF_AP_MATCHING_PROCESS_PKG is not typically called directly by end users. It is invoked by concurrent programs and loader processes such as IGF_AP_ISIR_GEN_PKG, IGF_AP_ISIR_IMPORT_PKG, IGF_AP_LI_ISIR_IMP_PROC, IGF_AP_LI_PROF_IMP_PROC, IGF_AP_LOADER_LAUNCH_PKG, IGF_AP_PROFILE_MATCHING_PKG, and the Self-Service IGF_SL_* routines, all documented as referencing this package. The package itself references STANDARD and SYS. Custom extensions should invoke it through the standard concurrent program interfaces rather than calling procedures directly, to preserve matching and auditing integrity.