Search Results igs_fi_lockboxes_pk

Overview

The IGS_FI_LOCKBOXES table is a core data structure 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 the master definition table for user-defined lockbox configurations. In the context of student financials, a lockbox is a banking service that automates the processing of bulk student payments, such as tuition fees. This table stores the essential attributes that link a specific lockbox name to its associated bank account and defines default processing rules for incoming electronic receipts, enabling the automated application of cash against student invoices.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key explicitly identify several critical columns. The central column is LOCKBOX_NAME, which serves as the unique primary key (IGS_FI_LOCKBOXES_PK) and identifies each configured lockbox. The BANK_ACCOUNT_ID column is a foreign key to AP_BANK_ACCOUNTS_ALL, linking the lockbox to a specific bank account within the Payables module. The DEFAULT_CREDIT_TYPE_ID column is a foreign key to IGS_FI_CR_TYPES_ALL, establishing a default credit type (e.g., tuition payment, housing deposit) for receipts processed through this lockbox, which streamlines automated transaction creation.

Common Use Cases and Queries

The primary use case is the setup and maintenance of lockbox processing within the student financials lifecycle. Administrators would use associated forms to create or update records in this table to define new banking interfaces. For reporting and troubleshooting, common queries involve joining this table to related entities. For instance, to list all configured lockboxes with their associated bank account details, a query would join IGS_FI_LOCKBOXES to AP_BANK_ACCOUNTS_ALL on BANK_ACCOUNT_ID. Another typical query would analyze lockbox processing by joining IGS_FI_LOCKBOXES to IGS_FI_CREDITS_ALL on LOCKBOX_NAME to review all credit transactions sourced from a specific lockbox. Furthermore, identifying the default settings for a lockbox involves selecting the LOCKBOX_NAME and the associated DEFAULT_CREDIT_TYPE_ID.

Related Objects

The IGS_FI_LOCKBOXES table maintains integral relationships with several other tables in the IGS module, as documented by its foreign keys.

• Referenced Tables (Outgoing Foreign Keys): This table references AP_BANK_ACCOUNTS_ALL via BANK_ACCOUNT_ID and IGS_FI_CR_TYPES_ALL via DEFAULT_CREDIT_TYPE_ID.
• Referencing Tables (Incoming Foreign Keys): Multiple tables use LOCKBOX_NAME as a foreign key, demonstrating its role as a master definition.
  • IGS_FI_CREDITS_ALL (RECEIPT_LOCKBOX_NUMBER): Links individual credit transactions to their source lockbox.
  • IGS_FI_LB_CR_TYPES (LOCKBOX_NAME): Likely stores lockbox-specific credit type overrides.
  • IGS_FI_LB_FCIS (LOCKBOX_NAME): Likely stores lockbox-specific fee category or item mappings.
  • IGS_FI_LB_RECT_ERRS (LOCKBOX_NAME): Stores error records generated during lockbox receipt processing.
  • IGS_FI_LB_REC_TYPES (LOCKBOX_NAME): Likely defines valid receipt types for a specific lockbox.