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.

  • Table: IGS_FI_BILL_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_ALL,  object_name:IGS_FI_BILL_ALL,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_BILL_ALL is the relation where the Billing Header information is recorded. Here the Bill Numbers are generated and Bill header details such as Bill Date, Due Date, Billed Person, Sub Account and Balances are recorded. ,  implementation_dba_data: IGS.IGS_FI_BILL_ALL , 

  • View: IGS_FI_BILL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_BILL,  object_name:IGS_FI_BILL,  status:VALID,  product: IGS - Student System ,  description: This is a flat view on the Multi Org table IGS_FI_BILL_ALL. ,  implementation_dba_data: APPS.IGS_FI_BILL , 

  • Table: IGS_FI_BILL_DPSTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_DPSTS,  object_name:IGS_FI_BILL_DPSTS,  status:VALID,  product: IGS - Student System ,  description: This table captures eligible deposit records for a particular bill. ,  implementation_dba_data: IGS.IGS_FI_BILL_DPSTS , 

  • Table: IGS_FI_BILL_PLN_CRD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_PLN_CRD,  object_name:IGS_FI_BILL_PLN_CRD,  status:VALID,  product: IGS - Student System ,  description: Stores the planned credit records for the particular bill extract. ,  implementation_dba_data: IGS.IGS_FI_BILL_PLN_CRD , 

  • Table: IGS_FI_BILL_P_PLANS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_P_PLANS,  object_name:IGS_FI_BILL_P_PLANS,  status:VALID,  product: IGS - Student System ,  description: This table stores student payment plan information included in a billing extract record ,  implementation_dba_data: IGS.IGS_FI_BILL_P_PLANS , 

  • Table: IGS_FI_CR_ACTIVITIES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CR_ACTIVITIES,  object_name:IGS_FI_CR_ACTIVITIES,  status:VALID,  product: IGS - Student System ,  description: Contains steps for the life cycle of credit transactions. This captures one record in this table when a new credit transaction is created in IGS_FI_CREDITS_ALL table with STATUS 'CLEARED'. ,  implementation_dba_data: IGS.IGS_FI_CR_ACTIVITIES , 

  • Table: IGS_FI_BILL_ADDR 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_ADDR,  object_name:IGS_FI_BILL_ADDR,  status:VALID,  product: IGS - Student System ,  description: This table describes the relation that records the different addressing details for the Bill. ,  implementation_dba_data: IGS.IGS_FI_BILL_ADDR , 

  • Table: IGS_FI_INV_INT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_INV_INT_ALL,  object_name:IGS_FI_INV_INT_ALL,  status:VALID,  product: IGS - Student System ,  description: This interface table stores invoice data generated by invoice process. ,  implementation_dba_data: IGS.IGS_FI_INV_INT_ALL , 

  • Table: IGS_FI_SUBACCTS_ALL 12.1.1

    product: IGS - Student System ,  description: Stores information about each defined sub account. Each row contains information for a specific sub account, including name, description, receivables, revenue, cash and unapplied account details and receipt lockbox numbers that are assigned ,  implementation_dba_data: Not implemented in this database , 

  • Table: IGS_FI_BILL_TRNSCTNS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_TRNSCTNS,  object_name:IGS_FI_BILL_TRNSCTNS,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_TRNSCTNS is the relation where the transactions recorded against a Bill are stored. This relation has a mapping to the Bill Header table as it stores the detail information against the header records. The transaction recorded in this ,  implementation_dba_data: IGS.IGS_FI_BILL_TRNSCTNS , 

  • View: IGSFV_PARTY_CHARGES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CHARGES,  object_name:IGSFV_PARTY_CHARGES,  status:VALID,  product: IGS - Student System ,  description: Contains details of charges for a person ,  implementation_dba_data: APPS.IGSFV_PARTY_CHARGES , 

  • View: IGSFV_PERSON_DEPOSITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PERSON_DEPOSITS,  object_name:IGSFV_PERSON_DEPOSITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Student Deposits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PERSON_DEPOSITS , 

  • View: IGSFV_PARTY_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CREDITS,  object_name:IGSFV_PARTY_CREDITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Party Credits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PARTY_CREDITS ,