Search Results igs_fi_posting_control_s

Overview

The APPS.IGS_FI_POSTING_PROCESS package body is a core component of the Oracle E-Business Suite Student Systems (formerly Oracle Student System / OSS) financials integration layer. Its principal business function is to move fee, invoice, and credit data originating in the student information model into the Oracle Receivables posting interface, where it can ultimately be processed by standard Receivables autoinvoice and accounting routines. In effect, the package acts as the bridge between the student accounts subledger (the IGS_FI_* tables) and the general financials schema (RA_INTERFACE_LINES_ALL). It supports the end-to-end flow of posting control records, interfaces, and error diagnostics required by institutions that bill students for tuition, fees, and related charges. The object is classified in ETRM as an OTHER API, is owned by APPS, and is documented as VALID for the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The documented package exposes two public program units:

• POSTING_INTERFACE — The primary driver routine. It orchestrates the movement of selected student finance records into the posting interface tables, applying the applicable posting control setup to determine which transactions are eligible for transfer. It is responsible for initiating the interface population, performing validation, and recording messages to the message stack where problems are encountered.
• TRANSFER_POSTING — Handles the transfer/posting stage, taking the prepared interface rows and passing them forward to the Receivables interface (RA_INTERFACE_LINES_ALL) so that standard Receivables processing can create transactions. It coordinates the status updates on the underlying IGS_FI_POSTING_INT_ALL records and interacts with the posting control tables to respect processing rules.

No parameter lists are documented in the ETRM metadata; only the program names and their functional roles should be relied upon when invoking them.

Tables Accessed

The package references a broad set of tables through APPS synonyms, reflecting its role as a data-movement hub:

• IGS_FI_POSTING_INT_ALL, IGS_FI_POSTING_INT, IGS_FI_POSTING_CONTROL_S, IGS_FI_CONTROL_ALL, IGS_FI_CONTROL — the posting interface and posting control records that govern which student finance data qualifies for transfer.
• IGS_FI_APPLICATIONS, IGS_FI_CREDITS, IGS_FI_CR_ACTIVITIES, IGS_FI_INV_INT_ALL, IGS_FI_INVLN_INT_ALL — applicant, credit, invoice, and invoice line data forming the source transactions.
• IGS_AD_APPL, IGS_AD_APP_REQ, IGS_FI_PARTIES_V, HZ_PARTIES — party and application context used to identify the customer/student.
• RA_INTERFACE_LINES_ALL — the Receivables interface target where posted lines are staged.
• FND_NEW_MESSAGES, FND_MESSAGE, FND_FILE — message and logging infrastructure used for user feedback and concurrent output.
• DUAL — used for single-row computations and control checks.

Usage Notes

IGS_FI_POSTING_PROCESS is typically invoked from a concurrent program in the Student Finance responsibility, where a user selects the posting control set and runs the transfer to Receivables. It is also callable from forms and from custom PL/SQL wrappers that need to trigger posting as part of a batch or scheduled job. Because the package relies on IGS_FI_POSTING_CONTROL_S and related control tables, correct setup of posting controls is a prerequisite. The package is not referenced by any other database object, so it functions as a top-level entry point rather than a shared utility. All output and diagnostics are directed through the standard FND message and file APIs, making the concurrent request log the primary troubleshooting surface.