Search Results get_party_number

Overview

The APPS.IGS_FI_GL_INTERFACE package is a component of the Oracle Student System (formerly Oracle iLearning / Student Systems) Financials integration layer. Its documented purpose, stated in the package header, is to transfer Student Finance transactions to the Oracle General Ledger. The package is owned by the APPS schema, is defined with AUTHID CURRENT_USER, and is classified as an "OTHER" API rather than a published business API. It acts as the bridge between the student receivables sub-ledger maintained in the IGS_FI_* tables and the standard GL journal import mechanism, ensuring that student charges, credits, and adjustments are reflected in the general ledger with appropriate balancing and posting controls.

Key Procedures and Functions

• TRANSFER — A public procedure that drives the transfer of Student Finance transactions into GL. It accepts an error buffer and return code for standard concurrent-program error handling, together with parameters controlling the GL date range to be processed, whether detail-level posting is required, the GL date to be posted against, and the journal import mode. Its role is to select eligible Student Finance transactions within the specified date window and write them into the GL interface tables for subsequent journal import.
• GET_PARTY_NUMBER — A public function returning a VARCHAR2 value for a given party identifier. It resolves a party ID from the Trading Community Architecture (HZ) model into the corresponding party number, which is used for identifying the student or customer associated with the source transaction during interface processing. This is the function most associated with the search term "get_party_number."

Tables Accessed

• HZ_PARTIES — The TCA party master, read by GET_PARTY_NUMBER to resolve party_id to party_number.
• IGS_FI_APPLICATIONS, IGS_FI_CREDITS_ALL, IGS_FI_CR_ACTIVITIES, IGS_FI_CR_TYPES_ALL, IGS_FI_INV_INT_ALL, IGS_AD_APP_REQ — Student Finance source tables holding application, credit, credit-activity, credit-type, invoice-interface, and application-request data that constitute the transactions to be transferred.
• IGS_FI_POSTING_CONTROL_S — Posting control sequence used to govern which transactions are eligible for transfer.
• GL_INTERFACE — The standard GL journal import interface table into which transfer records are written.
• GL_JE_CATEGORIES, GL_JE_SOURCES — Journal category and source validation references for the generated GL lines.
• GL_PERIOD_STATUSES — Used to validate open/closed accounting periods for the supplied GL dates.
• FND_NEW_MESSAGES and DUAL — Supporting message lookup and single-row expression evaluation.

Usage Notes

IGS_FI_GL_INTERFACE.TRANSFER is typically invoked from a concurrent program that submits Student Finance transactions to GL, following the standard errbuf/retcode convention so that output appears in the concurrent manager request log. It should be scheduled after Student Finance posting is complete and before GL journal import is run, with GL dates constrained to open periods. GET_PARTY_NUMBER is a utility helper that may be called from the same flow or from custom code needing to convert a party identifier to its display number; because the package is AUTHID CURRENT_USER, callers must have appropriate privileges on the underlying objects. The package header indicates it is an older internal component (last updated 2002), and no other documented packages reference it, so it is best treated as an internal interface rather than a supported extension point.