Search Results invoice_creditact_id

Overview

The IGS_FI_BILL_TRNSCTNS table is a core transaction ledger within the Oracle E-Business Suite (EBS) 12.1.1/12.2.2, specifically for the IGS (Oracle Student Management) product family. It functions as the detailed transaction repository for all financial activities posted against a student bill. The table stores line-level details for both charges (debits) and credits, providing a complete audit trail. Its primary role is to map individual financial transactions—originating from charges or credit activities—to a parent bill header record, thereby enabling detailed billing analysis, reconciliation, and reporting.

Key Information Stored

The table's structure captures essential transaction attributes. The primary key is TRANSACTION_ID, a system-generated sequence. Each record links to a parent bill via BILL_ID. The TRANSACTION_TYPE column is critical, indicating if the record is a Charge ('D') or Credit ('C'). The INVOICE_CREDITACT_ID column holds the foreign key reference to the source record, pointing to either a Charges table or a Credit Activities table, depending on the transaction type. Other significant columns include TRANSACTION_AMOUNT, TRANSACTION_DATE (effective date for credits, transaction date for charges), TRANSACTION_NUMBER from the source system, and descriptive fields like FEE_CREDIT_TYPE and TRANSACTION_DESCRIPTION. Standard WHO columns (CREATED_BY, CREATION_DATE) are also present for auditing.

Common Use Cases and Queries

This table is central to generating detailed student account statements, reconciling bill totals to underlying transactions, and auditing financial activity. A common reporting use case is to list all transactions for a specific bill. For example, to find all charges and credits for a given BILL_ID, including the source transaction identifier:

• SELECT transaction_type, transaction_amount, invoice_creditact_id, transaction_date FROM igs.igs_fi_bill_trnsctns WHERE bill_id = <bill_id> ORDER BY transaction_date;

Another frequent query involves analyzing credit activities. To report on all credit transactions applied within a date range, filtered by a specific credit type:

• SELECT bill_id, transaction_number, transaction_amount FROM igs.igs_fi_bill_trnsctns WHERE transaction_type = 'C' AND fee_credit_type = '<TYPE>' AND transaction_date BETWEEN :start_date AND :end_date;

The column INVOICE_CREDITACT_ID is pivotal for tracing a bill line item back to its originating source document, which is essential for troubleshooting and data validation.

Related Objects

IGS_FI_BILL_TRNSCTNS maintains defined foreign key relationships with other core tables, as indicated by its mutually exclusive reference to source transaction tables. The INVOICE_CREDITACT_ID column is the join key for these relationships.

• Bill Header Table: Related to a parent bill header table via the BILL_ID column.
• Charges Table: When TRANSACTION_TYPE = 'D', the INVOICE_CREDITACT_ID references a record in a charges table (specific table name not provided in excerpt).
• Credit Activities Table: When TRANSACTION_TYPE = 'C', the INVOICE_CREDITACT_ID references a record in a credit activities table (specific table name not provided in excerpt).

The table has two unique indexes: IGS_FI_BILL_TRNSCTNS_U1 on TRANSACTION_ID (primary key) and IGS_FI_BILL_TRNSCTNS_U2 on the combination of TRANSACTION_TYPE and INVOICE_CREDITACT_ID, enforcing uniqueness of the source transaction reference.