Search Results iby_creditcard_issuers_b




Overview
Explore in AI Chat

Overview

The IBY_CREDITCARD_ISSUERS_B table is a core reference data object within the Oracle E-Business Suite (EBS) Payments (IBY) module. It serves as the master repository for defining and maintaining the list of accepted credit card brands or issuers, such as Visa, MasterCard, and American Express. This table is fundamental to the payment processing infrastructure, as it provides the valid set of card issuer codes that can be associated with customer credit cards and used in transaction authorization. Its data is referenced throughout the payment lifecycle, from card registration and validation to transaction routing and reporting.

Key Information Stored

The table's primary purpose is to store a unique identifier and basic attributes for each accepted card brand. The most critical column is CARD_ISSUER_CODE, which acts as the primary key. This short, unique code (e.g., 'VISA', 'MC') is the definitive identifier used to link a card issuer across the entire Payments schema. While the provided ETRM excerpt does not list all columns, typical implementations of such a base table include columns for creation and last update dates, and a flag indicating whether the issuer is currently active. The corresponding translation table, IBY_CREDITCARD_ISSUERS_TL, holds the user-friendly name (e.g., 'Visa', 'MasterCard') for each code in multiple languages.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and setup. A common operational query is to retrieve the list of active card issuers for display in an application's list of values (LOV) when a user is entering a new credit card. For reporting, it is frequently joined to transaction or card data to group results by card brand. Administrators may query this table as part of configuring a new payment system or enabling a new card type.

  • Sample Query to List Active Card Issuers: 
    SELECT card_issuer_code
FROM iby.iby_creditcard_issuers_b
WHERE enabled_flag = 'Y'
ORDER BY 1;
  • Sample Reporting Join to Transaction Data: 
    SELECT iss.card_issuer_code, COUNT(*) transaction_count
FROM iby.iby_creditcard_issuers_b iss,
     iby.iby_creditcard cc
WHERE cc.card_issuer_code = iss.card_issuer_code
GROUP BY iss.card_issuer_code;

Related Objects

The IBY_CREDITCARD_ISSUERS_B table is a central reference point, linked via foreign key relationships to several key transactional and setup tables in the IBY schema. These documented relationships are:

  • IBY_CC_ISSUER_RANGES: Links via CARD_ISSUER_CODE to define valid card number ranges (BIN/IIN ranges) for each issuer, which is critical for card number validation.
  • IBY_CREDITCARD: Links via CARD_ISSUER_CODE. This is the primary table storing registered customer credit card details, ensuring every card is associated with a valid issuer.
  • IBY_CREDITCARD_H: Links via CARD_ISSUER_CODE. This is the history table for IBY_CREDITCARD, preserving the issuer association for historical card records.
  • IBY_CREDITCARD_ISSUERS_TL: Links via CARD_ISSUER_CODE. This is the translation table that provides the descriptive name for each issuer code in supported languages.