Search Results ext_pmt_party_id




Overview
Explore in AI Chat

Overview

The table IBY_EXT_PARTY_PMT_MTHDS is a core data object within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) Releases 12.1.1 and 12.2.2. It serves as a master repository for defining and storing the valid payment methods available for external payment parties. An external payment party is an entity, such as a supplier or customer, with whom the organization conducts financial transactions. This table establishes the critical link between a party, the payment methods they can use (e.g., Check, Wire Transfer, Electronic Funds Transfer), and the specific payment function (e.g., Disbursements, Receipts). It is fundamental for enforcing payment rules and ensuring that payment processing workflows adhere to pre-configured business and compliance requirements.

Key Information Stored

The table's structure is designed to uniquely identify a party's payment method configuration. Its primary key is the system-generated identifier, EXT_PARTY_PMT_MTHD_ID. A unique key constraint ensures that a combination of PAYMENT_FLOW, EXT_PMT_PARTY_ID, PAYMENT_METHOD_CODE, and PAYMENT_FUNCTION is not duplicated, enforcing business rule integrity. Key columns include EXT_PMT_PARTY_ID, which references the external party; PAYMENT_METHOD_CODE, a foreign key to IBY_PAYMENT_METHODS_B that defines the specific payment instrument; PAYMENT_FUNCTION, which specifies the transaction context (e.g., 'PAYABLES_DISB', 'RECEIPTS'); and PAYMENT_FLOW, indicating the direction of funds (e.g., Outbound, Inbound). This design allows for granular control, enabling different payment methods for the same party across different business functions.

Common Use Cases and Queries

A primary use case is validating and determining the permissible payment methods for a supplier during invoice payment or a customer during receipt application. System processes query this table to present valid options in payment workbenches. Common reporting needs include auditing payment method assignments by party or identifying parties configured for a specific payment method like Electronic Funds Transfer (EFT). A typical query pattern is:

  • SELECT ext_pmt_party_id, payment_method_code, payment_function FROM iby_ext_party_pmt_mthds WHERE payment_flow = 'OUTBOUND' AND payment_function = 'PAYABLES_DISB';

This would retrieve all outbound disbursement payment methods configured for external parties. Troubleshooting often involves joining with IBY_PAYMENT_METHODS_B to get the method name or with party tables (e.g., AP_SUPPLIERS via external reference) for party details.

Related Objects

IBY_EXT_PARTY_PMT_MTHDS is centrally connected to other critical Payments tables. Its foreign key relationship with IBY_PAYMENT_METHODS_B (via PAYMENT_METHOD_CODE) is essential for obtaining the descriptive name and attributes of the payment method. The EXT_PMT_PARTY_ID column typically references an external identifier that links to trading community architecture (TCA) or specific product module party tables, such as AP_SUPPLIERS or AR_CUSTOMERS. While the provided metadata shows a foreign key relationship to itself (a self-referential or hierarchical relationship), this is less common and may support advanced hierarchical party structures. The table is a foundational reference for payment processing engines and setup UIs within the IBY module.

  • Table: IBY_EXT_PARTY_PMT_MTHDS 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_EXT_PARTY_PMT_MTHDS,  object_name:IBY_EXT_PARTY_PMT_MTHDS,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_EXT_PARTY_PMT_MTHDS , 

  • Table: IBY_PMT_INSTR_USES_ALL 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PMT_INSTR_USES_ALL,  object_name:IBY_PMT_INSTR_USES_ALL,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_PMT_INSTR_USES_ALL , 

  • Table: IBY_PMT_INSTR_USES_ALL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PMT_INSTR_USES_ALL,  object_name:IBY_PMT_INSTR_USES_ALL,  status:VALID,  product: IBY - Payments ,  description: "This table contains records of the relationship between payment instruments and Payer/Payee. Data can be entered manually. IBY_PMT_INSTR_USES_ALL table assigns payment instruments to external party payers and payees. This table is shared ,  implementation_dba_data: IBY.IBY_PMT_INSTR_USES_ALL , 

  • Table: IBY_EXT_PARTY_PMT_MTHDS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_EXT_PARTY_PMT_MTHDS,  object_name:IBY_EXT_PARTY_PMT_MTHDS,  status:VALID,  product: IBY - Payments ,  description: IBY_EXT_PARTY_PMT_MTHDS stores payment method applicability driven by the preferences of the external party. A payment method is applicable to a party and payment function combination and, optionally and additionally, to a party site and/or ,  implementation_dba_data: IBY.IBY_EXT_PARTY_PMT_MTHDS ,