Search Results receipt_lockbox_number




Overview
Explore in AI Chat

Overview

The IGS_FI_SA_LOCKBOXES table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle Grants Accounting) product. Its primary function is to manage the association between specific lockbox numbers and sub-accounts. A lockbox is a banking service used to process high volumes of payments, and this table ensures incoming receipts are correctly attributed to the appropriate financial sub-account within the grants management system. It is critical for automating the cash application process. Notably, the ETRM metadata explicitly marks this table and its key functional column, SUBACCOUNT_ID, as "Obsolete," indicating its active use may have been superseded in later application logic, though the table remains present in the schema.

Key Information Stored

The table stores the essential linkage between a lockbox identifier and a sub-account, along with standard audit columns. The key columns are:

The table is enforced with two unique constraints: one on the primary key and another on the RECEIPT_LOCKBOX_NUMBER itself, preventing duplicate lockbox numbers in the system.

Common Use Cases and Queries

The primary use case is validating and routing automated receipts during the lockbox transmission process. When a bank file is received, the system queries this table using the lockbox number from the file to determine the correct IGS sub-account for posting. A typical validation query would be: 

SELECT sa.SUBACCOUNT_CODE, lb.RECEIPT_LOCKBOX_NUMBER
FROM IGS_FI_SA_LOCKBOXES lb,
     IGS_FI_SUBACCTS_ALL sa
WHERE lb.SUBACCOUNT_ID = sa.SUBACCOUNT_ID
  AND lb.RECEIPT_LOCKBOX_NUMBER = '&LOCKBOX_NUMBER_FROM_BANK_FILE';
For reporting and administration, a common query lists all configured lockbox associations: 
SELECT LOCKBOX_SUBACCOUNT_ID,
       SUBACCOUNT_ID,
       RECEIPT_LOCKBOX_NUMBER,
       CREATION_DATE,
       LAST_UPDATED_BY
FROM IGS.IGS_FI_SA_LOCKBOXES
ORDER BY RECEIPT_LOCKBOX_NUMBER;
Given the "obsolete" status, these operations may now be handled by alternative interfaces or tables in standard implementations.

Related Objects

The table has defined relationships with other key IGS financial tables, primarily through foreign key constraints.

  • Primary Key: The table's primary key is named IGS_FI_SA_LOCKBOXES_PK on the column LOCKBOX_SUBACCOUNT_ID.
  • Foreign Key (Outbound): The SUBACCOUNT_ID column references the SUBACCOUNT_ID in the IGS_FI_SUBACCTS_ALL table. This links the lockbox to the broader sub-account definition.
  • Referencing Objects (Inbound): According to the dependency information, the table is referenced by an object within the APPS schema, though the specific object name (likely a view or synonym) is listed simply as IGS_FI_SA_LOCKBOXES. This is typical for EBS, where application logic accesses tables via public synonyms.
These relationships are fundamental for maintaining referential integrity between lockbox configurations and the chart of accounts structure within Grants Accounting.