Search Results posting_interface

Overview

IGS_FI_POSTING_PROCESS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Student Systems (IGS) financials posting cycle. It functions as a batch processing engine that gathers eligible financial transactions — including charge lines, credit activities, and application records — and stages them for posting. The staged output is written to the IGS_FI_Posting_INT interface table, and when Oracle Receivables (AR) is installed, the data is subsequently transferred into the AR posting interface. The package is declared with AUTHID CURRENT_USER and carries a header indicating it was last modified in 2002, with changes introduced by the GL interface build (Bug 2584986) and the Posting_Interface modifications. Its principal purpose is to bridge student financial transactions originating in the IGS modules into the general ledger and receivables posting streams of Oracle EBS.

Key Procedures and Functions

The ETRM metadata documents two procedures: POSTING_INTERFACE and TRANSFER_POSTING.

• POSTING_INTERFACE — The primary batch entry point. It collects eligible transactions from charge lines, credit activities and application tables and inserts them into the IGS_FI_POSTING_INT staging table. It accepts an error buffer and return code for concurrent program reporting, along with low and high posting date parameters and an accounting date parameter that govern which transactions are selected and how they are dated.
• TRANSFER_POSTING — Responsible for transferring the staged posting records onward. It receives the concurrent program error buffer and return code, a batch name identifying the posting set, low and high posting date parameters, and an org_id parameter scoping the transfer to a specific business unit. This procedure moves the staged data toward the final posting destination, including the Oracle AR interface when AR is installed.

Tables Accessed

The package references a set of tables through APPS synonyms that reflect both its source-transaction and staging roles.

• IGS_FI_POSTING_INT_ALL — The primary staging table into which eligible transactions are inserted; also supplies the batch_name and org_id parameter data types.
• IGS_FI_CR_ACTIVITIES, IGS_FI_APPLICATIONS, IGS_AD_APP_REQ, IGS_FI_INVLN_INT_ALL, IGS_FI_INV_INT_ALL — Source transactional tables holding credit activities, applications, admissions application requests and invoice line/interface data from which eligible posting candidates are selected.
• IGS_FI_CONTROL_ALL, IGS_FI_POSTING_CONTROL_S — Control and sequence tables governing posting behavior and identifiers.
• RA_INTERFACE_LINES_ALL — The Oracle Receivables interface table to which data is transferred when AR is installed.
• HZ_PARTIES — Provides party (customer/student) information for the posting records.
• FND_NEW_MESSAGES — Used for concurrent program message/error reporting.
• DUAL — Used for single-row PL/SQL selection operations.

Usage Notes

The package is designed to be run as a batch process, typically invoked through Oracle EBS concurrent programs rather than interactively. It is not referenced by any other documented package, indicating it is a top-level process invoked directly by the concurrent manager or by scheduled jobs. The POSTING_INTERFACE procedure would ordinarily be scheduled to collect and stage transactions for a given posting date range, followed by TRANSFER_POSTING to move the staged records into the downstream AR interface. The low/high posting date and accounting date parameters allow operators to control the posting period, while org_id constrains processing to a single operating unit. Because it writes into the Receivables interface, standard AR interface processing must run afterward to complete the accounting entry creation. No forms-level or custom-code invocations are documented in the metadata.