Search Results igf_ap_profile_matching_pkg




Overview
Explore in AI Chat

Overview

IGF_AP_PROFILE_MATCHING_PKG is an Oracle Application Object Library (APPS) PL/SQL package that supports the profile matching and financial aid applicant processing functions within the Oracle Financial Aid module of Oracle E-Business Suite. The package is classified as OTHER in the ETRM metadata and is registered as VALID in the APPS schema. Its primary business purpose is to evaluate financial aid applicant and student records against institutional and external data profiles, create or update the corresponding base records, and maintain the matching detail and person match information used by downstream financial aid processes.

The package operates within the broader financial aid data flow that includes ISIR (Institutional Student Information Record) interfaces, CSS Profile data, and FA base records. It is referenced by IGF_AP_LI_PROF_IMP_PROC and IGF_AP_PROFILE_GEN_PKG, indicating that it participates in profile import and generation processing.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. Their documented names and purposes are as follows:

Tables Accessed

The package interacts with several APPS-synonym tables. It reads and writes IGF_AP_CSS_INTERFACE_ALL, IGF_AP_CSS_PROFILE_ALL, IGF_AP_ISIR_INTS_ALL, IGF_AP_MATCH_DETAILS, IGF_AP_PERSON_MATCH_ALL, IGF_AP_FA_BASE_REC_ALL, IGF_AP_RECORD_MATCH_ALL, IGF_AP_BATCH_AW_MAP_ALL, and IGF_AP_TD_ITEM_INST_ALL, which hold applicant, profile, match, and award-mapping data. It also touches Trading Community Architecture tables — HZ_CONTACT_POINTS, HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES, and HZ_PERSON_PROFILES — to resolve and create person, party site, and address information. IGS_AD_CAL_CONF is referenced for admissions calendar configuration.

Usage Notes

IGF_AP_PROFILE_MATCHING_PKG is typically invoked from concurrent programs and self-service flows associated with financial aid profile import and matching. The SS_WRAP_* procedures indicate it is callable from self-service pages, while MAIN and the CREATE/UPDATE routines are called from batch or form-driven processes. Because it is referenced by IGF_AP_LI_PROF_IMP_PROC and IGF_AP_PROFILE_GEN_PKG, customizations should avoid direct modification; any extension should occur through supported wrappers. Dependency analysis should be performed before upgrades to 12.2.2, given the package's reliance on HZ and financial aid tables.