Search Results finp_prc_fee_rollvr

Overview

The APPS.IGS_FI_PRC_FEE_ROLLV package is a component of the Oracle E-Business Suite Student Systems / Financials integration layer, specifically belonging to the IGS (Student Information) product family. It supports the processing of fee rollover and fee valuation logic within the institution's fee calendar and fee type framework. Its role is to apply fee eligibility and category-instance configuration data to generate or refresh rolled-over fee amounts for enrolled students against defined fee types and calendar instances.

The package is classified under the ETRM metadata with an API classification of OTHER, and its object status is listed as VALID. It is owned by the APPS schema, which is consistent with the shared public synonym ownership model used throughout Oracle EBS 12.1.1 and 12.2.2. While it is not designed as a public, externally callable PL/SQL API, it is a documented database object referenced through ETRM and is part of the internal fee calculation package set.

Key Procedures and Functions

The ETRM documentation records two procedures/functions within this package:

• GENP_PIN_PACKAGE — Generates the package's pin (persistent identity) information. This is a standard internal utility routine used by certain generated IGS packages to record package identity and integrity metadata.
• FINP_PRC_FEE_ROLLVR — The principal business routine. It performs the fee rollover processing, applying fee type, fee category, and calendar instance configurations to calculate and populate fee rollover values for the applicable population.

The package is non-public and is not intended for direct invocation outside the standard IGS processes. No additional parameter lists are documented in the source metadata, and no invented signatures are provided here.

Tables Accessed

The package reads and writes against a defined set of IGS tables via APPS synonyms, including:

• IGS_FI_FEE_TYPE_ALL — Provides fee type definitions used to scope rollover processing.
• IGS_FI_F_CAT_CA_INST, IGS_FI_F_CAT_FEE_LBL_ALL, IGS_FI_F_TYP_CA_INST_ALL, IGS_FI_ANC_RATES, IGS_FI_ANC_RT_SGMNTS, IGS_FI_ELM_RANGE, IGS_FI_CONTROL_ALL — Configure fee categories, fee labels, calendar instance assignments, ancillary rates, rate segments, element ranges, and fee control settings.
• IGS_CA_INST_ALL, IGS_CA_DA_INST, IGS_CA_TYPE — Supply calendar instance and calendar type context for the fee rollover date logic.
• IGS_EN_UNITSETFEETRG — Links enrollment unit sets to fee trigger configurations.
• IGS_GE_S_LOG_ENTRY — Records log entries generated during processing.
• FND_ID_FLEX_SEGMENTS, FND_NEW_MESSAGES — Provide key flexfield segment metadata and message resolution for error handling.

Usage Notes

IGS_FI_PRC_FEE_ROLLV is invoked internally by the IGS fee processing framework, typically through concurrent programs, scheduled fee rollover jobs, or from dependent IGS packages such as IGS_FI_PRC_FEE_ROLLV itself (self-reference). It is not referenced by any other package per the ETRM dependency listing, indicating it sits near the leaf of the internal call tree. Customizations should avoid direct invocation; instead, use the delivered concurrent program or the parent fee processing API. Direct calls are unsupported and bypass required setup validation and logging behavior.