Search Results bank_cd




Overview
Explore in AI Chat

Overview

The IGS_FI_LB_CR_TYPES table is a core configuration table within the Oracle E-Business Suite Student System (IGS). Its primary function is to manage the mapping between bank-supplied transaction codes and the application's internal credit types during the processing of electronic payments via a lockbox. A lockbox is a banking service where a financial institution receives and processes customer payments directly, subsequently providing a data file to the organization. This table acts as a critical translation layer, ensuring that payment transactions identified by specific bank codes are correctly categorized into the appropriate, pre-defined credit types within the Oracle Student Financials module for accurate accounting and application against student accounts.

Key Information Stored

The table stores the essential mappings that define how lockbox payment data is interpreted. The structure is centered on a composite primary key and a unique key to enforce data integrity. The most critical columns include LOCKBOX_NAME, which identifies the specific lockbox configuration; BANK_CD, which stores the transaction code provided by the bank in the payment file; and CREDIT_TYPE_ID, which holds the internal identifier linking to a defined credit type (e.g., tuition payment, housing deposit). The primary key (LOCKBOX_NAME, BANK_CD) ensures that within a given lockbox, each bank code is uniquely defined. The unique key (LOCKBOX_NAME, CREDIT_TYPE_ID) prevents the same internal credit type from being mapped multiple times within a single lockbox configuration.

Common Use Cases and Queries

The primary use case is the automated processing of lockbox payment files. During the Lockbox Processing concurrent program execution, the system reads the bank transaction code from the incoming file, queries this table using the LOCKBOX_NAME and BANK_CD to find the corresponding CREDIT_TYPE_ID, and uses that to correctly apply the payment. Common queries involve validating configurations or troubleshooting payment application errors. For example, to list all mappings for a specific lockbox:

  • SELECT lockbox_name, bank_cd, credit_type_id FROM igs.igs_fi_lb_cr_types WHERE lockbox_name = '&LOCKBOX_NAME';

To identify unmapped bank codes found in a processed file, one might compare distinct codes from the staging table (e.g., IGS_FI_LOCKBOX_STAGE) against the mappings defined in IGS_FI_LB_CR_TYPES for the relevant lockbox.

Related Objects

This table has defined dependencies on two key master tables, as per the provided foreign key metadata:

  • IGS_FI_LOCKBOXES: The table is linked via the LOCKBOX_NAME column. This parent table defines the overall lockbox configuration parameters, such as the bank account and processing options.
  • IGS_FI_CR_TYPES_ALL: The table is linked via the CREDIT_TYPE_ID column. This reference ensures that the mapped code points to a valid, active credit type within the system, which dictates the accounting and application rules for the received payment.

These relationships ensure referential integrity, meaning a mapping cannot exist for a non-existent lockbox or an invalid credit type, maintaining the configuration's accuracy and reliability.

  • 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 , 

  • View: IGS_FI_LB_CR_TYPES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_CR_TYPES_V,  object_name:IGS_FI_LB_CR_TYPES_V,  status:VALID,  product: IGS - Student System ,  description: Form view used to show the mapping of bank-supplied codes with pre-defined Credit Types in the context of a Lockbox. ,  implementation_dba_data: APPS.IGS_FI_LB_CR_TYPES_V , 

  • View: IGS_FI_LB_FCIS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_FI_LB_FCIS_V,  object_name:IGS_FI_LB_FCIS_V,  status:VALID,  product: IGS - Student System ,  description: Form View used to show the mapping of bank codes with the fee calendar instances in the context of a Lockbox. ,  implementation_dba_data: APPS.IGS_FI_LB_FCIS_V ,