Search Results igs_fi_sa_lockboxes_pk

Overview

The table IGS_FI_SA_LOCKBOXES is a legacy data object within the Oracle E-Business Suite (EBS) Student System (IGS). Its primary function was to store configuration data linking specific student financial sub-accounts to distinct lockbox numbers used for processing electronic payments. This linkage was critical for automating the application of cash receipts from external sources, such as bank lockbox services, to the correct student financial records. However, as per the official ETRM documentation, this table is explicitly marked as "No longer used" in both EBS 12.1.1 and 12.2.2. This status indicates it is a deprecated object retained for potential data reference or upgrade compatibility but is not actively utilized by the current application logic.

Key Information Stored

Based on the provided metadata, the table's structure centers on the relationship between a lockbox identifier and a financial sub-account. The key columns include LOCKBOX_SUBACCOUNT_ID, which served as the primary sequence identifier for each record, and RECEIPT_LOCKBOX_NUMBER, a unique key column holding the specific lockbox number assigned by a bank or payment processor. A critical foreign key column is SUBACCOUNT_ID, which references the IGS_FI_SUBACCTS_ALL table. This foreign key established the link between a configured lockbox and the specific student financial sub-account to which receipts from that lockbox should be posted.

Common Use Cases and Queries

Given its deprecated status, there are no active operational use cases for this table in standard EBS processes. Its primary relevance is for historical data analysis, audit inquiries, or data cleanup activities during upgrades. Database administrators or functional consultants might query it to understand legacy configuration or to verify the absence of active data before considering archival or removal. A sample query to retrieve all existing mappings would be:

• SELECT lockbox_subaccount_id, receipt_lockbox_number, subaccount_id FROM igs.igs_fi_sa_lockboxes;

Any integration or reporting that requires current lockbox configuration must reference the active tables and APIs that superseded this deprecated object, which are typically found within the Oracle Receivables (AR) module for standard lockbox processing.

Related Objects

The ETRM metadata specifies one primary relationship for this table. It has a foreign key dependency on the IGS_FI_SUBACCTS_ALL table via the SUBACCOUNT_ID column. This relationship enforced referential integrity to the master table of student financial sub-accounts. The table itself defines two primary key constraints: IGS_FI_SA_LOCKBOXES_PK (on LOCKBOX_SUBACCOUNT_ID) and SALO_UK (a unique key on RECEIPT_LOCKBOX_NUMBER). As a deprecated table, it is unlikely to be referenced by other active application tables, views, or public APIs within the current IGS or Financials modules.