Search Results finpl_clc_sua_cp




Overview
Explore in AI Chat

Overview

IGS_FI_PRC_FEE_ASS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems (IGS) financials module, specifically the assessment and processing of student fees. The package operates within the fee assessment lifecycle, where enrollment records, program versions, and fee categories are correlated to determine which fees a student should be charged. Its classification as an "OTHER" API indicates it is not a formally published open interface, but rather an internal processing package invoked by higher-level fee generation and calculation routines.

The object is documented as VALID in the ETRM repository for both 12.1.1 and 12.2.2, confirming it remains a supported internal component across those releases. Its principal role is to insert enrollment-based fee assessments and to calculate student unit attempt charge components that feed downstream fee processing, waivers, and account payment logic.

Key Procedures and Functions

  • FINP_INS_ENR_FEE_ASS — Inserts enrollment fee assessment records. This routine is responsible for creating the fee assessment rows associated with a student's enrollment, drawing on the enrollment attempt, program version, and fee category data to build the assessment output consumed by later stages of the fee process.
  • FINPL_CLC_SUA_CP — Calculates student unit attempt charge components. This routine derives the charge amounts tied to a student's unit attempts, applying fee rates and category configuration to produce the computed assessment values.

Both procedures are internal building blocks rather than self-contained public APIs. Parameter details are not exposed in the metadata, and callers should not assume a stable external signature.

Tables Accessed

The package reads and writes a broad set of IGS enrollment and fee tables. Enrollment-side tables include IGS_EN_STDNT_PS_ATT_ALL, IGS_EN_SU_ATTEMPT_ALL, IGS_CA_INST_ALL, and IGS_PS_VER_ALL, providing the student program attempt, unit attempt, calendar instance, and program version context required to evaluate fees. Fee configuration and assessment tables include IGS_FI_FEE_AS_ITEMS, IGS_FI_FEE_AS_RATE, IGS_FI_FEE_STR_STAT, IGS_FI_FEE_TYPE_ALL, IGS_FI_FAI_DTLS, IGS_FI_F_CAT_CA_INST, and IGS_FI_F_CAT_FEE_LBL_ALL, which supply fee items, rate definitions, fee status, fee types, and category-to-calendar/label mappings. Reference and party data are drawn from IGS_FI_CONTROL, IGS_LOOKUPS_VIEW (FND_LOOKUP_VALUES), HZ_PARTIES, and IGS_AD_APPL_ALL. The mix of reads and writes indicates the package both consumes configuration and persists assessment results.

Usage Notes

IGS_FI_PRC_FEE_ASS is not designed for direct invocation by end users. It is called by other IGS financials packages, notably IGS_FI_GEN_004, IGS_FI_GEN_008, IGS_FI_PRC_WAIVERS, and IGS_FI_SS_ACCT_PAYMENT, and by itself internally. These callers typically execute within fee generation and assessment concurrent programs or within the Student Fee Assessment forms, where fee lines are assembled and charges computed. Customizations should avoid calling this package directly because its procedures assume the surrounding context provided by its callers. Any extension work should instead hook into the documented public entry points that invoke it, since the internal procedures do not carry API guarantees across patches or upgrades.