Search Results igs_fi_prc_fee_rollv
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.
-
PACKAGE: APPS.IGS_FI_PRC_FEE_ROLLV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_PRC_FEE_ROLLV, status:VALID,
-
SYNONYM: APPS.IGS_FI_F_CAT_FEE_LBL_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_F_CAT_FEE_LBL_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_F_CAT_CA_INST
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_F_CAT_CA_INST, status:VALID,
-
SYNONYM: APPS.IGS_FI_F_TYP_CA_INST_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_F_TYP_CA_INST_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_FEE_TYPE_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FEE_TYPE_ALL, status:VALID,
-
PACKAGE: APPS.IGS_FI_PRC_FEE_ROLLV
12.1.1
-
PACKAGE BODY: APPS.IGS_FI_PRC_FEE_ROLLV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_PRC_FEE_ROLLV, status:VALID,
-
PACKAGE: APPS.IGS_FI_F_TYPE_ACCTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_F_TYPE_ACCTS_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_SUB_ER_RT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_SUB_ER_RT_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_ANC_RT_SGMNTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_ANC_RT_SGMNTS_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_SUB_ELM_RNG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_SUB_ELM_RNG, status:VALID,
-
SYNONYM: APPS.IGS_FI_SUB_ER_RT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_SUB_ER_RT, status:VALID,
-
SYNONYM: APPS.IGS_PS_FEE_TRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_FEE_TRG, status:VALID,
-
PACKAGE: APPS.IGS_FI_VAL_FRTNS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_VAL_FRTNS, status:VALID,
-
SYNONYM: APPS.IGS_FI_ANC_RT_SGMNTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_ANC_RT_SGMNTS, status:VALID,
-
PACKAGE: APPS.IGS_FI_ELM_RANGE_RT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_ELM_RANGE_RT_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_TP_RET_SCHD
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_TP_RET_SCHD, status:VALID,
-
PACKAGE: APPS.IGS_PS_GRP_FEE_TRG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PS_GRP_FEE_TRG_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_FTCI_ACCTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FTCI_ACCTS, status:VALID,
-
PACKAGE: APPS.IGS_FI_FEE_RET_SCHD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_FEE_RET_SCHD_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_VAL_FCFL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_VAL_FCFL, status:VALID,
-
PACKAGE: APPS.IGS_FI_VAL_FAR
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_VAL_FAR, status:VALID,
-
PACKAGE: APPS.IGS_EN_UNITSETFEETRG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_EN_UNITSETFEETRG_PKG, status:VALID,
-
PACKAGE: APPS.IGS_PS_FEE_TRG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PS_FEE_TRG_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_EL_RNG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_EL_RNG_PKG, status:VALID,
-
SYNONYM: APPS.IGS_PS_TYPE_FEE_TRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_TYPE_FEE_TRG, status:VALID,
-
SYNONYM: APPS.IGS_EN_UNITSETFEETRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_EN_UNITSETFEETRG, status:VALID,
-
PACKAGE: APPS.IGS_PS_TYPE_FEE_TRG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_PS_TYPE_FEE_TRG_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_VAL_FTCI
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_VAL_FTCI, status:VALID,
-
SYNONYM: APPS.IGS_FI_F_TYPE_ACCTS_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_F_TYPE_ACCTS_ALL, status:VALID,
-
SYNONYM: APPS.IGS_GE_S_LOG_ENTRY
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_GE_S_LOG_ENTRY, status:VALID,
-
PACKAGE: APPS.IGS_FI_ANC_RATES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_ANC_RATES_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_SUB_ELM_RNG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_SUB_ELM_RNG_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_ANC_RATES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_ANC_RATES, status:VALID,
-
PACKAGE: APPS.IGS_FI_FEE_TRG_GRP_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_FEE_TRG_GRP_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_ELM_RANGE_RT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_ELM_RANGE_RT, status:VALID,
-
SYNONYM: APPS.IGS_FI_FEE_TRG_GRP
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FEE_TRG_GRP, status:VALID,
-
PACKAGE: APPS.IGS_FI_TP_RET_SCHD_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_TP_RET_SCHD_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_APINT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_APINT, status:VALID,
-
SYNONYM: APPS.IGS_PS_GRP_FEE_TRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_PS_GRP_FEE_TRG, status:VALID,
-
PACKAGE: APPS.IGS_FI_VAL_FCCI
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_VAL_FCCI, status:VALID,
-
PACKAGE: APPS.IGS_FI_FTCI_ACCTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_FTCI_ACCTS_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_ELM_RANGE
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_ELM_RANGE, status:VALID,
-
PACKAGE: APPS.IGS_FI_UNIT_FEE_TRG_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_UNIT_FEE_TRG_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_F_CAT_CA_INST_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_F_CAT_CA_INST_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_UNIT_FEE_TRG
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_UNIT_FEE_TRG, status:VALID,
-
SYNONYM: APPS.IGS_FI_FEE_RET_SCHD
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_FEE_RET_SCHD, status:VALID,
-
PACKAGE: APPS.IGS_FI_FEE_AS_RATE_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_FEE_AS_RATE_PKG, status:VALID,
-
VIEW: APPS.IGS_FI_F_TYPE_ACCTS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_F_TYPE_ACCTS, object_name:IGS_FI_F_TYPE_ACCTS, status:VALID,
-
VIEW: APPS.IGS_FI_ACC
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_ACC, object_name:IGS_FI_ACC, status:VALID,