Search Results igs_fi_lockboxes




Overview
Explore in AI Chat

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.
  • Table: IGS_FI_LOCKBOXES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LOCKBOXES,  object_name:IGS_FI_LOCKBOXES,  status:VALID,  product: IGS - Student System ,  description: Table for storing the attributes of a user defined Lockbox Name. ,  implementation_dba_data: IGS.IGS_FI_LOCKBOXES , 

  • Table: IGS_FI_LB_REC_TYPES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_REC_TYPES,  object_name:IGS_FI_LB_REC_TYPES,  status:VALID,  product: IGS - Student System ,  description: Table for mapping bank supplied record type identifiers for each data row in the bank transmission files. ,  implementation_dba_data: IGS.IGS_FI_LB_REC_TYPES , 

  • Table: IGS_FI_LB_RECT_ERRS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_RECT_ERRS,  object_name:IGS_FI_LB_RECT_ERRS,  status:VALID,  product: IGS - Student System ,  description: This entity would be used to store the lockbox receipt records that had validation errors detected during the import process from the interface table. ,  implementation_dba_data: IGS.IGS_FI_LB_RECT_ERRS , 

  • Table: IGS_FI_LB_CR_TYPES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_CR_TYPES,  object_name:IGS_FI_LB_CR_TYPES,  status:VALID,  product: IGS - Student System ,  description: Table to store the mapping of bank-supplied codes to pre-defined Credit Types in the context of a Lockbox. ,  implementation_dba_data: IGS.IGS_FI_LB_CR_TYPES , 

  • Table: IGS_FI_LB_FCIS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_LB_FCIS,  object_name:IGS_FI_LB_FCIS,  status:VALID,  product: IGS - Student System ,  description: Table for mapping bank codes with the fee calendar instance as defined in the system for a lockbox in context. ,  implementation_dba_data: IGS.IGS_FI_LB_FCIS , 

  • Table: IGS_FI_CREDITS_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CREDITS_ALL,  object_name:IGS_FI_CREDITS_ALL,  status:VALID,  product: IGS - Student System ,  description: This table contains information about all credit or payment transactions and is the central repository for all credits and payments related information in Student Finance. ,  implementation_dba_data: IGS.IGS_FI_CREDITS_ALL , 

  • Table: IGS_FI_CR_TYPES_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_CR_TYPES_ALL,  object_name:IGS_FI_CR_TYPES_ALL,  status:VALID,  product: IGS - Student System ,  description: Stores information about the 'credit type' of a credit transaction. The credit type provides the debit and credit account information to a credit transaction along with some other information like credit class etc. ,  implementation_dba_data: IGS.IGS_FI_CR_TYPES_ALL , 

  • View: IGS_FI_LOCKBOXES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LOCKBOXES_V,  object_name:IGS_FI_LOCKBOXES_V,  status:VALID,  product: IGS - Student System ,  description: Form View used for Lockbox Setup. ,  implementation_dba_data: APPS.IGS_FI_LOCKBOXES_V , 

  • View: IGSFV_PERSON_DEPOSITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PERSON_DEPOSITS,  object_name:IGSFV_PERSON_DEPOSITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Student Deposits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PERSON_DEPOSITS , 

  • View: IGSFV_PARTY_CREDITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_PARTY_CREDITS,  object_name:IGSFV_PARTY_CREDITS,  status:VALID,  product: IGS - Student System ,  description: Stores all Party Credits in Student Finance ,  implementation_dba_data: APPS.IGSFV_PARTY_CREDITS ,