Search Results igs_fi_otc_charges_uk

Overview

The IGS_FI_OTC_CHARGES table is a core transactional data structure within the Oracle E-Business Suite Student System (IGS). It functions as a repository for external-type charges generated specifically during the creation of a cash receipt. Its primary role is to maintain a permanent, auditable link between a student's over-the-counter (OTC) payment and any ancillary charges that were automatically created as part of that payment transaction. This table is essential for ensuring financial integrity and traceability in the student receivables process, capturing charges that are directly tied to the act of payment itself rather than standard tuition or fee assessments.

Key Information Stored

The table's structure is designed to establish relationships between the payment receipt and the associated charge documents. Its key columns are defined by its primary and unique keys. The surrogate primary key is OTC_CHARGE_ID. The critical business keys are CREDIT_ID and INVOICE_ID, which form a unique constraint (IGS_FI_OTC_CHARGES_UK). The CREDIT_ID column holds a foreign key reference to the IGS_FI_CREDITS_ALL table, linking directly to the cash receipt (credit memo) created for the over-the-counter payment. The INVOICE_ID column holds a foreign key reference to the IGS_FI_INV_INT_ALL table, linking to the specific invoice (charge) that was generated concurrently with the receipt. This two-column relationship is the definitive record of which charge was spawned by which receipt.

Common Use Cases and Queries

The primary use case is auditing and reconciling OTC payment transactions. Financial administrators and system auditors query this table to verify that for every over-the-counter receipt, the corresponding system-generated charges are correctly recorded. A typical query would join to credit and invoice tables to retrieve a full transaction view. For example, to list all OTC charges for a specific student or within a date range:

• SELECT o.otc_charge_id, c.credit_id, c.receipt_number, i.invoice_id, i.invoice_amount FROM igs_fi_otc_charges o JOIN igs_fi_credits_all c ON o.credit_id = c.credit_id JOIN igs_fi_inv_int_all i ON o.invoice_id = i.invoice_id WHERE c.person_id = :student_id AND c.creation_date >= :start_date;

This table is also critical for troubleshooting scenarios where a charge exists but its originating receipt is unclear, or vice-versa. Reporting on the volume and value of system-generated OTC charges by term or payment location is another common application.

Related Objects

The IGS_FI_OTC_CHARGES table has direct, mandatory dependencies on two primary financial tables, as defined by its foreign keys. It is a child table to IGS_FI_CREDITS_ALL, which stores all credit memos (receipts), and to IGS_FI_INV_INV_INT_ALL, which stores all invoice interfaces (charges). The existence of a record in IGS_FI_OTC_CHARGES is contingent upon records existing in both parent tables. Processes that create over-the-counter receipts, typically within the Student System's cashiering functions, are responsible for populating this table. While not explicitly listed in the provided metadata, it is logically related to person (student) tables and fee type definitions through its connections to the credit and invoice structures.