Search Results igs_fi_bill_all




Overview
Explore in AI Chat

Overview

The IGS_FI_BILL_ALL table is a core data object within the Oracle E-Business Suite's Student System (IGS) module, specifically for release versions 12.1.1 and 12.2.2. It functions as the primary billing header table, establishing the master record for a financial bill. Its fundamental role is to generate and store the overarching details of a bill, serving as the parent entity for detailed line items and related financial transactions. This table is central to the student financial management process, enabling the tracking of charges, payments, and balances at a summary level for a billed person or entity.

Key Information Stored

The table stores the header-level attributes of a bill. The primary identifier is the system-generated BILL_ID. As documented, other critical columns include the BILL_DATE and DUE_DATE, which define the billing and payment timelines. The PERSON_ID column identifies the billed individual, linking to the HZ_PARTIES table in the Trading Community Architecture (TCA) model. The SUBACCOUNT_ID links to the IGS_FI_SUBACCTS_ALL table, associating the bill with a specific financial sub-account. The table also records summary BALANCES for the bill. A unique key constraint on CUT_OFF_DATE and PERSON_ID suggests the table supports mechanisms for billing cycles or periodic statements.

Common Use Cases and Queries

This table is pivotal for generating student statements, aging reports, and reconciling account activity. Common operational and reporting queries involve joining to related transaction tables to calculate outstanding balances or to retrieve a complete billing history for a person. A typical pattern is to retrieve all bills for a specific person to display a statement summary.

  • Retrieve a person's billing summary: SELECT bill_id, bill_date, due_date FROM igs_fi_bill_all WHERE person_id = :p_person_id ORDER BY bill_date DESC;
  • Identify overdue bills for reporting: SELECT bill_id, person_id, due_date FROM igs_fi_bill_all WHERE due_date < TRUNC(SYSDATE) AND balance > 0;
  • Analyze billing activity by sub-account for a period: SELECT subaccount_id, COUNT(*), SUM(balance) FROM igs_fi_bill_all WHERE bill_date BETWEEN :p_start_date AND :p_end_date GROUP BY subaccount_id;

Related Objects

As a central hub table, IGS_FI_BILL_ALL has extensive relationships within the IGS financial schema. It is the parent table for numerous detail entities, as indicated by the foreign key relationships. Key child tables include IGS_FI_CR_ACTIVITIES for credit transactions, IGS_FI_BILL_TRNSCTNS for bill line items, IGS_FI_INV_INT_ALL for invoice interfaces, and supporting tables for addresses (IGS_FI_BILL_ADDR), deposits (IGS_FI_BILL_DPSTS), and payment plans (IGS_FI_BILL_P_PLANS, IGS_FI_BILL_PLN_CRD). Its primary foreign key dependencies are on HZ_PARTIES for party information and IGS_FI_SUBACCTS_ALL for the financial account structure.