Search Results iby_transmit_protocols_b




Overview
Explore in AI Chat

Overview

The IBY_TRANSMIT_PROTOCOLS_B table is a core reference table within the Oracle E-Business Suite Payments (IBY) module. It functions as the master repository for defining electronic transmission protocols used for communication with external financial institutions. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is critical for configuring and executing payment-related transmissions, including funds transfers, settlement queries, and payment status verifications. It stores the technical definitions that enable the Oracle Payments engine to interact with banking networks and payment gateways using specific communication standards and methods.

Key Information Stored

The table's primary key is the TRANSMIT_PROTOCOL_CODE, which uniquely identifies each transmission protocol. While the full column list is not detailed in the provided metadata, the foreign key relationships indicate it stores protocol definitions referenced by various payment system profiles and transmission configurations. The associated translation table, IBY_TRANSMIT_PROTOCOLS_TL, stores the user-facing name and description for each protocol code, supporting multiple languages. The data in this table is foundational, as the protocol code is used to link to specific transmission configurations (IBY_TRANSMIT_CONFIGS_B) and their associated parameters (IBY_TRANSMIT_PARAMETERS_B).

Common Use Cases and Queries

This table is primarily referenced during the setup and maintenance of payment systems. Administrators query it to verify available protocols when configuring a new payment system profile or transmission method. Common SQL patterns involve joining the base table with its translation table to retrieve meaningful names and with related configuration tables for troubleshooting. For instance, to list all configured transmission protocols with their descriptions, a query such as the following is typical:

  • SELECT b.TRANSMIT_PROTOCOL_CODE, tl.NAME, tl.DESCRIPTION FROM IBY.IBY_TRANSMIT_PROTOCOLS_B b, IBY.IBY_TRANSMIT_PROTOCOLS_TL tl WHERE b.TRANSMIT_PROTOCOL_CODE = tl.TRANSMIT_PROTOCOL_CODE AND tl.LANGUAGE = USERENV('LANG');

Another critical use case is impact analysis before modifying a protocol definition, requiring queries to identify all dependent payment system profiles and configurations via the documented foreign key relationships.

Related Objects

The IBY_TRANSMIT_PROTOCOLS_B table is centrally linked to numerous key objects in the Payments module, as evidenced by its foreign key constraints. Key relationships include:

  • IBY_SYS_PMT_PROFILES_B: Payment system profiles reference a protocol via TRANSMIT_PROTOCOL_CODE.
  • IBY_TRANSMIT_CONFIGS_B & IBY_TRANSMIT_PARAMETERS_B: Store the detailed configuration and parameters for a specific protocol code.
  • IBY_PMT_SYS_TRANSMISSIONS: Logs individual transmission instances using the defined protocol.
  • Payment System Profile Tables: Specifically referenced for Credit Card (IBY_FNDCPT_SYS_CC_PF_B), Direct Debit (IBY_FNDCPT_SYS_DC_PF_B), and Electronic Funds Transfer (IBY_FNDCPT_SYS_EFT_PF_B) profiles for settlement, query, and funds transfer operations.
  • IBY_TRANSMIT_PROTOCOLS_TL: The translation table for multilingual support, joined on TRANSMIT_PROTOCOL_CODE.