Search Results igs_fi_bill_pkg




Overview
Explore in AI Chat

Overview

IGS_FI_BILL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) financial product family. Its object name and dependencies place it at the center of the billing data model used by Oracle Student Financials, where the IGS_FI_BILL_ALL table stores the header-level billing records generated for a student or sponsor over a billing period. The package encapsulates the standard row-level data manipulation and validation logic applied to those billing entity rows, functioning as the generated-style "table handler" through which higher-level billing processes insert, update, lock, and delete billing records without issuing raw DML against the base table.

The ETRM metadata confirms the package is VALID and lists nine documented procedures. Its dependents are exclusively other IGS financial billing packages — bill address, bill disbursements, bill extract, bill plan credit, person plans, bill transactions, credit activities, and invoice interface — indicating that IGS_FI_BILL_PKG provides the shared persistence layer on which the rest of the billing subsystem depends.

Key Procedures and Functions

The documented program units follow the conventional Oracle EBS table-handler pattern:

  • INSERT_ROW — performs the core insert of a new billing record, populating the primary key and mandatory columns.
  • UPDATE_ROW — applies changes to an existing billing row, maintaining the audit columns.
  • DELETE_ROW — removes a billing record from the entity.
  • LOCK_ROW — issues a SELECT ... FOR UPDATE to serialize concurrent access to a specific billing row.
  • ADD_ROW — front-end entry point that validates a row and delegates to INSERT_ROW or UPDATE_ROW depending on whether the record already exists.
  • BEFORE_DML — central pre-DML hook that derives WHO columns and enforces entity-level validation before any insert, update, or delete proceeds.
  • GET_PK_FOR_VALIDATION — returns the primary key value used by the generic validation framework.
  • GET_UK_FOR_VALIDATION — returns the unique key value for duplicate detection.
  • GET_FK_HZ_PARTIES — retrieves the foreign key linking the billing record to the Trading Community Architecture party record.

Tables Accessed

  • IGS_FI_BILL_ALL — the base billing table holding the bill header information; the primary target of insert, update, delete, and lock operations.
  • IGS_FI_BILL_S — the sequence/primary-key source supporting surrogate key generation for new billing rows.
  • HZ_PARTIES — referenced for party foreign-key resolution and validation, confirming the bill is associated with a valid TCA person or organization.
  • DUAL — used for scalar evaluations within the package logic.

Usage Notes

IGS_FI_BILL_PKG is not intended for direct invocation by end users. It is called programmatically by the billing forms and concurrent programs in Oracle Student Financials, and by the eight dependent packages listed in its metadata. Customizations that need to create or maintain billing records should call the public procedures rather than issuing direct DML, because BEFORE_DML and the validation routines enforce constraints that raw SQL would bypass. The package is supported on both EBS 12.1.1 and 12.2.2; the 12.2.x online patching editioning views for IGS_FI_BILL_ALL do not alter the documented API surface. Any modifications should be made through the supported extension mechanisms, since the package is a VALID, Oracle-owned object in the APPS schema.