Search Results igf_gr_li_import




Overview
Explore in AI Chat

Overview

IGF_GR_LI_IMPORT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Financial Aid / Student Systems lineage of the Oracle iGrants and Student Aid (IGF) product family. In the ETRM 12.1.1 metadata the package is assigned an API classification of OTHER, indicating that it is an internal, batch-oriented processing unit rather than a formally published open interface. Its name suggests a specialized role in the Loan Import (LI) / Pell Grant reporting area: the prefix "GR" associates it with the grant side of financial aid processing, while "LI_IMPORT" denotes the loading or staging of loan-and-grant data into the reporting and award tables. In practice the package serves as a data-movement engine that consolidates awarded amounts, attendance-based disbursements, and Pell-specific records into the structures used by downstream reporting and reconciliation. It is part of the same internal infrastructure that produces the RFMS and Pell reporting extracts, ensuring that figures recorded in the transactional tables are reflected accurately in the reporting layer. The package is VALID in the reported dictionary state, confirming that it compiles cleanly against the APPS schema and that its dependencies resolve at runtime.

Key Procedures and Functions

ETRM documents one callable unit within this package:

  • MAIN — the single documented procedure. MAIN acts as the package driver, invoking the SQL and PL/SQL logic required to perform the loan and grant import or reporting routine. Callers invoke MAIN to execute the package's complete workflow rather than individual sub-steps. No parameter list is documented; it should be treated as a driver routine and its signature confirmed against the live source before use.

Because the package exposes only MAIN, all supporting logic is encapsulated and not intended for direct external calls.

Tables Accessed

The ETRM dependency list shows the following tables referenced through APPS synonyms:

Usage Notes

IGF_GR_LI_IMPORT is not referenced by any other PL/SQL package in the reported metadata (0 referencing packages), which indicates it is invoked directly by an external driver — typically a concurrent program or a scheduled batch process — rather than being called from within the application's package hierarchy. Its reliance on FND_LOG_MESSAGES shows that execution is instrumented for logging, so diagnostics should be read from the FND log at the appropriate level. When troubleshooting, verify the data state of the IGF_GR and IGF_AW tables before executing MAIN, and confirm row counts in the reporting tables afterward. Given its internal classification, custom code should call this package cautiously and only after the MAIN signature has been validated in the target environment. Behavior can also differ between 12.1.1 and 12.2.2 due to Online Patching editioning and table synonym changes; in an AD/TXK editioned 12.2.2 environment, calls made from custom code must resolve to the correct edition.