Search Results iby_accppmtmthd_uk

Overview

The IBY_ACCPPMTMTHD table is a core data object within the Oracle E-Business Suite Payments module (IBY). It serves as a configuration and validation table, defining the permissible relationships between payment instruments and payees. Specifically, it maintains a list of all payment instrument methods that a given iPayment (a payment entity within the system) is configured to accept. This table is essential for enforcing business rules during payment processing, ensuring that only authorized and compatible payment methods can be used for transactions associated with specific payees and external payment applications.

Key Information Stored

The table's structure centers on establishing links between key entities in the payment ecosystem. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its critical data points. The composite primary key (IBY_ACCPPMTMTHD_UK) consists of ACCTTYPEID, ECAPPID, and PAYEEID. This indicates that a unique record defines the acceptance of a specific payment instrument type (ACCTTYPEID) for a particular payee (PAYEEID) within the context of a given external payment application (ECAPPID). The foreign key columns, MPAYEEID and ACCTTYPEID, enforce referential integrity by linking to the IBY_PAYEE and IBY_ACCTTYPE master tables, respectively.

Common Use Cases and Queries

This table is primarily referenced for validation and reporting on payment method setup. A common operational use case is verifying which payment methods are enabled for a payee before initiating a payment batch. For reporting, administrators may query the table to audit payment acceptance rules across the enterprise. A typical query would join IBY_ACCPPMTMTHD with its referenced master tables to produce a human-readable list.

• Sample Query: SELECT ptm.payeeid, p.payee_name, ptm.accttypeid, at.account_type_name FROM iby_accppmtmthd ptm, iby_payee p, iby_accttype at WHERE ptm.mpayeeid = p.payee_id AND ptm.accttypeid = at.accttypeid ORDER BY p.payee_name;
• Validation Logic: Payment APIs will internally query this table to confirm that a submitted payment instruction's instrument type is valid for the intended payee and application context.

Related Objects

IBY_ACCPPMTMTHD is a junction table with strong dependencies on master data tables, as defined by its foreign key constraints.

• IBY_PAYEE: Contains master payee information. The MPAYEEID column in IBY_ACCPPMTMTHD references this table to identify the payee for whom the payment method rule is defined.
• IBY_ACCTTYPE: Contains master payment instrument types (e.g., Credit Card, Bank Account). The ACCTTYPEID column references this table to specify the accepted payment method.
• IBY_EXTERNAL_PAYERS_ALL (inferred): While not explicitly listed, the ECAPPID (External Application ID) column typically references a table storing external payment system configurations, such as IBY_EXTERNAL_PAYERS_ALL, linking acceptance rules to a specific payment gateway or processor setup.