Search Results igs_fi_gen_gl




Overview
Explore in AI Chat

Overview

IGS_FI_GEN_GL is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It resides in the Financials product family associated with the Oracle Student System (formerly Oracle iLearning/Student Systems), where it supports the interface between student financial transactions and the Oracle General Ledger. The package's central responsibility is to prepare, validate, and generate General Ledger accounting entries arising from student receivables activities such as credits, charge adjustments, and posting intermediates. It acts as a bridge that collects transaction data held in the IGS_FI interface and control tables and transforms it into a form suitable for GL posting. ETRM classifies the package API as OTHER, and it is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

ETRM documents eight callable units within the package body. Their purposes are as follows:

  • FINP_GET_CUR – Retrieves currency information, typically the functional or transaction currency used to value the accounting entries being generated.
  • FINP_SS_GET_CUR – A variant currency retrieval routine used within the Student System flow to obtain the applicable currency context.
  • CHECK_UNPOSTED_TXNS_EXIST – Determines whether unposted transactions remain for the relevant criteria, functioning as a gate before GL generation proceeds.
  • GET_PERIOD_STATUS_FOR_DATE – Returns the GL period status (for example, open or closed) associated with a given accounting date, ensuring transactions are directed to valid periods.
  • CHECK_GL_DT_APPL_NOT_VALID – Validates the GL date against the application setup, raising an exception when the date is not acceptable.
  • CHECK_NEG_CHGADJ_EXISTS – Detects the presence of negative charge adjustment records, which require special accounting treatment.
  • GET_LKP_MEANING – Returns the meaning of a lookup code from the Oracle lookup values repository, supporting descriptive output of coded values.
  • GET_FORMATTED_AMOUNT – Produces a formatted representation of an amount, applying currency formatting conventions for display or reporting.

Tables Accessed

The package reads and writes a defined set of student financial tables via APPS synonyms. Control and setup data are drawn from IGS_FI_CONTROL_ALL, IGS_FI_CONTROL, and IGS_FI_CONTROL_V. Transaction and application detail come from IGS_FI_APPLICATIONS, IGS_AD_APP_REQ, IGS_FI_CREDITS_ALL, IGS_FI_CR_ACTIVITIES, and IGS_FI_CR_TYPES_ALL. Posting and invoice intermediate tables include IGS_FI_POSTING_INT_ALL and IGS_FI_INVLN_INT_ALL. Currency handling relies on FND_CURRENCIES, FND_CURRENCIES_TL, and FND_CURRENCY, while messaging and lookup resolution use FND_NEW_MESSAGES and IGS_LOOKUP_VALUES. The package also calls peer modules IGS_FI_GEN_005, IGS_FI_GEN_007, and its own internal GL logic, and it invokes APP_EXCEPTION for error signalling.

Usage Notes

IGS_FI_GEN_GL is invoked during the Student System financials GL generation and posting cycle, most commonly from concurrent programs and internal generation routines (IGS_FI_GEN_005 and IGS_FI_GEN_007) rather than directly from end-user forms. It is referenced by 49 other database objects, indicating broad downstream reliance within the Student System financials codebase. The validation functions (period status, GL date, unposted transactions, negative adjustments) are typically called before the main generation step to enforce data integrity and period controls. Customizations and extensions should call the package as-is and avoid direct DML against the underlying interface and control tables, since the package encapsulates the authoritative accounting derivation rules.