Search Results create_admission_rec

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:

• MAIN — Primary entry point that orchestrates the profile matching process.
• CREATE_FA_BASE_RECORD — Creates a financial aid base record for a matched applicant.
• CREATE_FNAR_DATA — Constructs financial need analysis record data.
• CREATE_PERSON_RECORD — Creates a person record from matched profile data.
• CREATE_PERSON_ADDR_RECORD — Creates person address information associated with a matched person.
• CREATE_PROFILE_MATCHED — Establishes a matched profile entry.
• IS_FA_BASE_RECORD_PRESENT — Determines whether a financial aid base record already exists.
• UPDATE_CSS_INTERFACE — Updates the CSS interface records during matching.
• CONVERT_INT — Converts integer values as part of data processing.
• AUTO_FA_REC — Handles automatic financial aid record creation or matching.
• RVW_FA_REC — Supports review processing of financial aid records.
• UNMATCHED_REC — Handles records that fail to match against profiles.
• CREATE_ADMISSION_REC — Creates admission-related records from matched data.
• UPDATE_PERSON_MATCH — Updates person matching information.
• UPDATE_FA_BASE_REC — Updates an existing financial aid base record.
• REMOVE_SPL_CHR — Removes special characters during data normalization.
• SS_WRAP_CREATE_PERSON_RECORD — Self-service wrapper for creating person records.
• SS_WRAP_REFRESH_MATCHES — Self-service wrapper for refreshing matches.
• SS_WRAP_CREATE_BASE_RECORD — Self-service wrapper for creating base records.
• SS_WRAP_UPLOAD_PROFILE — Self-service wrapper for uploading profiles.

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.