Search Results igs_fi_bill_dpsts_pk

Overview

The IGS_FI_BILL_DPSTS table is a core data object within the now-obsolete Student System (IGS) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a junction table designed to manage the relationship between student bills and eligible financial deposits. Its primary role is to associate a specific bill (BILL_ID) with one or more credit activities (CREDIT_ACTIVITY_ID) that are considered applicable deposits for settling that bill's charges. This association is critical for tracking prepayments, deposits, or other credits allocated against outstanding student invoices within the legacy student financials framework.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two foreign key columns. This design enforces a unique relationship between a bill and a specific credit activity, preventing the same deposit from being linked to the same bill multiple times. The key columns are:

• BILL_ID: References a specific student invoice or bill record in the IGS_FI_BILL_ALL table. This is the bill against which a deposit is being applied.
• CREDIT_ACTIVITY_ID: References a specific financial credit record in the IGS_FI_CR_ACTIVITIES table. This represents the deposit or prepayment amount being allocated. The user's search for this column indicates its central importance in queries linking deposit transactions to bills.

Common Use Cases and Queries

This table is primarily used in reporting and reconciliation processes for student accounts receivable. A common operational scenario involves generating a report of all deposits allocated to a particular bill or identifying all bills settled by a specific large deposit. For technical consultants and developers, a frequent query pattern involves joining this table to its parent tables to retrieve detailed bill and credit information. For example, to list all deposits for a specific bill, one might use:

SELECT bd.*, ca.credit_amount, ca.credit_date
FROM igs_fi_bill_dpsts bd,
igs_fi_cr_activities ca
WHERE bd.credit_activity_id = ca.credit_activity_id
AND bd.bill_id = :p_bill_id;

Another critical use case is ensuring data integrity during financial data migrations or audits, where validating the complete chain from credit activity to bill application is essential.

Related Objects

The IGS_FI_BILL_DPSTS table has defined foreign key relationships with two primary tables in the student financials schema, as documented in the provided ETRM metadata:

• IGS_FI_BILL_ALL: Linked via the BILL_ID column. This is the parent table for student bill/invoice headers.
• IGS_FI_CR_ACTIVITIES: Linked via the CREDIT_ACTIVITY_ID column. This is the parent table for records of credit transactions, including deposits and payments.

The table itself is defined by its primary key constraint, IGS_FI_BILL_DPSTS_PK, on the (BILL_ID, CREDIT_ACTIVITY_ID) columns. It is important to note the ETRM metadata explicitly states this table was "Not implemented in this database," indicating it may exist in the data dictionary but not be populated in all EBS instances.