Search Results igs_fi_posting_process
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 underlyingIGS_FI_POSTING_INT_ALLrecords 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.
-
PACKAGE BODY: APPS.IGS_FI_POSTING_PROCESS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IGS_FI_POSTING_PROCESS, status:VALID,
-
SYNONYM: APPS.IGS_FI_POSTING_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_POSTING_INT_ALL, status:VALID,
-
PACKAGE: APPS.IGS_FI_POSTING_PROCESS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_POSTING_PROCESS, status:VALID,
-
PACKAGE: APPS.IGS_FI_POSTING_PROCESS
12.1.1
-
PACKAGE: APPS.IGS_FI_INVLN_INT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_INVLN_INT_PKG, status:VALID,
-
SYNONYM: APPS.IGS_FI_POSTING_CONTROL_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_POSTING_CONTROL_S, status:VALID,
-
PACKAGE: APPS.IGS_FI_POSTING_INT_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_POSTING_INT_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_APPLICATIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_APPLICATIONS_PKG, status:VALID,
-
PACKAGE: APPS.IGS_FI_CR_ACTIVITIES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_CR_ACTIVITIES_PKG, status:VALID,
-
PACKAGE: APPS.IGS_AD_GEN_015
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_AD_GEN_015, status:VALID,
-
SYNONYM: APPS.IGS_AD_APP_REQ
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_AD_APP_REQ, status:VALID,
-
PACKAGE: APPS.IGS_FI_COM_REC_INTERFACE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_COM_REC_INTERFACE, status:VALID,
-
SYNONYM: APPS.IGS_FI_INVLN_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_INVLN_INT_ALL, status:VALID,
-
SYNONYM: APPS.RA_INTERFACE_LINES_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RA_INTERFACE_LINES_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_APPLICATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_APPLICATIONS, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_005
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_005, status:VALID,
-
SYNONYM: APPS.IGS_FI_CR_ACTIVITIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CR_ACTIVITIES, status:VALID,
-
SYNONYM: APPS.IGS_FI_CONTROL_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_CONTROL_ALL, status:VALID,
-
SYNONYM: APPS.IGS_FI_INV_INT_ALL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IGS_FI_INV_INT_ALL, status:VALID,
-
VIEW: APPS.IGS_FI_POSTING_INT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_POSTING_INT, object_name:IGS_FI_POSTING_INT, status:VALID,
-
PACKAGE: APPS.IGS_FI_GEN_GL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_FI_GEN_GL, status:VALID,
-
VIEW: APPS.IGS_FI_INVLN_INT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_INVLN_INT, object_name:IGS_FI_INVLN_INT, status:VALID,
-
VIEW: APPS.IGS_FI_PARTIES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_PARTIES_V, object_name:IGS_FI_PARTIES_V, status:VALID,
-
VIEW: APPS.IGS_AD_APPL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_AD_APPL, object_name:IGS_AD_APPL, status:VALID,
-
PACKAGE: APPS.IGS_GE_DATE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_DATE, status:VALID,
-
VIEW: APPS.IGS_FI_CONTROL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CONTROL, object_name:IGS_FI_CONTROL, status:VALID,
-
VIEW: APPS.IGS_LOOKUPS_VIEW
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_LOOKUPS_VIEW, object_name:IGS_LOOKUPS_VIEW, status:VALID,
-
VIEW: APPS.IGS_FI_CREDITS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_CREDITS, object_name:IGS_FI_CREDITS, status:VALID,
-
VIEW: APPS.IGS_FI_INV_INT
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_FI_INV_INT, object_name:IGS_FI_INV_INT, status:VALID,
-
VIEW: APPS.IGS_LOOKUP_VALUES
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IGS.IGS_LOOKUP_VALUES, object_name:IGS_LOOKUP_VALUES, status:VALID,
-
APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_POSTING_PROCESS
12.1.1
-
PACKAGE BODY: APPS.IGS_FI_POSTING_PROCESS
12.1.1
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.IGS_GE_GEN_003
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_GEN_003, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
SYNONYM: APPS.FND_NEW_MESSAGES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_NEW_MESSAGES, status:VALID,
-
APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_GE_MSG_STACK
12.1.1
-
APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_POSTING_INT_ALL
12.1.1
-
SYNONYM: APPS.HZ_PARTIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_PARTIES, status:VALID,
-
PACKAGE: APPS.IGS_GE_MSG_STACK
12.1.1
owner:APPS, object_type:PACKAGE, object_name:IGS_GE_MSG_STACK, status:VALID,
-
PACKAGE: APPS.FND_FILE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_FILE, status:VALID,
-
eTRM - IGS Tables and Views
12.1.1
description: 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'. ,
-
PACKAGE: APPS.APP_EXCEPTION
12.1.1
owner:APPS, object_type:PACKAGE, object_name:APP_EXCEPTION, status:VALID,
-
SYNONYM: PUBLIC.DUAL
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.FND_MESSAGE
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
-
eTRM - IGS Tables and Views
12.1.1
description: 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'. ,
-
PACKAGE: SYS.STANDARD
12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,