Search Results otc_charge_id




Overview
Explore in AI Chat

Overview

The IGS_FI_OTC_CHARGES table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Student Management (OSM) or related educational modules under the IGS (iGrants) schema. Its primary function is to log and manage external charges generated during the creation of over-the-counter (OTC) receipts. When a student makes a payment in person, the system can create associated charges of an external type. This table serves as the definitive link between the receipt transaction and any such charges, ensuring a complete audit trail for financial activities originating from direct, in-person payments.

Key Information Stored

The table's structure is designed to establish relationships between key financial identifiers while maintaining standard audit information. The critical transactional columns are OTC_CHARGE_ID, which uniquely identifies each record; INVOICE_ID, which holds the identifier for the related charge or invoice; and CREDIT_ID, which stores the identifier for the associated credit or receipt. The presence of the CREDIT_ID column is central to the user's search context, as it directly links each external charge record to its originating payment credit. The table also includes standard EBS WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) to track the creation and modification history of each row.

Common Use Cases and Queries

A primary use case is reconciling OTC payments with the specific charges they were intended to settle. Financial administrators and auditors query this table to verify that all charges created during a receipt process are properly accounted for. Given the user's focus on "credit_id," a common query pattern involves tracing all external charges linked to a specific payment. For example, to find all charges tied to a particular credit ID for reporting or troubleshooting:

  • SELECT otc.OTC_CHARGE_ID, otc.INVOICE_ID, otc.CREDIT_ID FROM IGS.IGS_FI_OTC_CHARGES otc WHERE otc.CREDIT_ID = :p_credit_id;

Another critical reporting use case is identifying receipts that generated external charges by joining to related invoice or credit header tables, using this table as the central junction.

Related Objects

Based on the provided metadata, the IGS_FI_OTC_CHARGES table does not reference other objects but is itself referenced by an object named IGS_FI_OTC_CHARGES within the APPS context. This is likely a public synonym or a view that provides a more accessible pointer to the underlying IGS table for application code. The table's unique indexes, IGS_FI_OTC_CHARGES_U1 (on OTC_CHARGE_ID) and IGS_FI_OTC_CHARGES_U2 (a composite unique index on CREDIT_ID and INVOICE_ID), enforce data integrity. The composite index is particularly significant as it prevents duplicate charge-credit associations, ensuring a one-to-one relationship between a specific invoice charge and a specific payment credit within the OTC context.