Search Results iby_external_payees_all

Overview

The IBY_EXTERNAL_PAYEES_ALL table is a core repository within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master table for storing information about external payees, which are individuals or entities outside the organization who receive payments. This includes suppliers, employees, contractors, and other beneficiaries. The table's primary role is to centralize and maintain the detailed payment instructions and preferences for each payee, enabling the accurate and efficient processing of electronic and manual payments. Its 'ALL' suffix indicates it is a multi-organization table, storing data partitioned by the ORG_ID column for use in a Multi-Org environment.

Key Information Stored

The table's structure is designed to capture comprehensive payment details. Its primary key is the EXT_PAYEE_ID, a unique system-generated identifier. Key columns include PAYEE_PARTY_ID, which links to the Trading Community Architecture (TCA) party record, and PAYEE_NAME. Critical payment instruction columns are DEFAULT_PAYMENT_METHOD_CODE (linking to IBY_PAYMENT_METHODS_B), DELIVERY_CHANNEL_CODE (linking to IBY_DELIVERY_CHANNELS_B), and PAYMENT_FORMAT_CODE. The table also stores specific banking instructions and payment reason codes via BANK_INSTRUCTION1_CODE, BANK_INSTRUCTION2_CODE, and PAYMENT_REASON_CODE. The ORG_ID column is essential for data segregation in Multi-Org implementations.

Common Use Cases and Queries

This table is central to payment setup and inquiry processes. Common use cases include validating payee payment instructions before running a payment process, reporting on all payees configured for a specific payment method or delivery channel, and troubleshooting payment failures by examining a payee's setup. A typical query retrieves a payee's complete payment instructions:

• SELECT payee_name, default_payment_method_code, delivery_channel_code, payment_format_code FROM iby_external_payees_all WHERE ext_payee_id = :payee_id AND org_id = :org_id;

Another common pattern joins with the TCA layer to get a comprehensive list:

• SELECT iep.payee_name, iep.default_payment_method_code, hp.party_name FROM iby_external_payees_all iep, hz_parties hp WHERE iep.payee_party_id = hp.party_id AND iep.org_id = :org_id;

Related Objects

IBY_EXTERNAL_PAYEES_ALL is a central hub with several key relationships. It is referenced by the FV_TPP_ASSIGNMENTS_ALL table for Third-Party Payment assignments and by the IBY_PAYMENTS_ALL table, which stores individual payment records. As indicated by its foreign keys, it draws valid values from critical look-up and setup tables: IBY_PAYMENT_METHODS_B, IBY_DELIVERY_CHANNELS_B, and internal code tables for bank instructions and payment reasons. The table is fundamentally linked to the Oracle Trading Community Architecture (TCA) via the PAYEE_PARTY_ID foreign key to HZ_PARTIES, ensuring a single source of truth for entity data.