Results for “igs_fi_gl_interface”
34 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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_NUMBERto 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.
-
SYNONYM: APPS.IGS_AD_APP_REQ 12.1.1
-
SYNONYM: APPS.GL_JE_SOURCES 12.1.1
-
SYNONYM: APPS.GL_INTERFACE 12.1.1
-
VIEW: APPS.IGS_FI_INVLN_INT 12.1.1
-
VIEW: APPS.IGS_AD_APPL 12.1.1
-
VIEW: APPS.IGS_LOOKUP_VALUES 12.1.1
-
VIEW: APPS.IGS_FI_CONTROL 12.1.1
-
VIEW: APPS.IGS_FI_CREDITS 12.1.1
-
VIEW: APPS.IGS_FI_INV_INT 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.HZ_PARTIES 12.1.1
-
VIEW: APPS.GL_SETS_OF_BOOKS 12.1.1
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
-
USSGL transaction codes
-
SYNONYM: PUBLIC.DUAL 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
USSGL transaction codes
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.