Search Results iby_applicable_pmt_mthds




Overview
Explore in AI Chat

Overview

The IBY_APPLICABLE_PMT_MTHDS table is a core repository within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central data structure for defining and enforcing company-specific payment policies. Its primary role is to store the complex rules that determine which payment methods (e.g., Check, Wire Transfer, Electronic Funds Transfer) are applicable and valid for a given transaction based on a set of configurable business factors. This table is essential for the system's payment method validation engine, ensuring that only permitted and logical payment methods are presented or selected during payment processing, thereby enforcing corporate governance and operational controls.

Key Information Stored

The table stores the relationships between payment methods and the business contexts in which they are allowed. While the full column list is not detailed in the provided metadata, the core logical components are defined. Each record establishes a rule linking a specific PAYMENT_METHOD_CODE to a combination of policy factors. The documented factors include the First Party Legal Entity, the First Party Organization (operating unit), the Payment Processing Transaction Type (e.g., Payables Payment, Payroll Payment), and whether the Transaction is Foreign. The primary key, APPLICABLE_PMT_MTHD_ID, uniquely identifies each rule. The table's foreign keys to IBY_PAYMENT_METHODS_B and FND_APPLICATION confirm it references master payment method definitions and the specific EBS application (like Payables or Payroll) for which the rule is defined.

Common Use Cases and Queries

A primary use case is troubleshooting payment method availability during payment process requests, such as when building a payment batch in Payables. Administrators may query this table to audit or verify the active payment policy rules. A common reporting need is to list all payment methods applicable to a specific legal entity and transaction type. A sample query pattern would join this table to the payment methods master table:

  • SELECT apm.*, pmb.method_name FROM iby_applicable_pmt_mthds apm, iby_payment_methods_b pmb WHERE apm.payment_method_code = pmb.payment_method_code AND apm.application_id = 200 /* Payables */ AND [entity/organization conditions];

Another critical scenario is during the customization or extension of payment workflows, where understanding the existing applicability matrix is necessary before adding new rules via the appropriate Oracle APIs.

Related Objects

The table maintains defined foreign key relationships with other central EBS objects, as documented in the metadata:

  • IBY_PAYMENT_METHODS_B: Joined via the PAYMENT_METHOD_CODE column. This relationship retrieves the master details (name, type) of the payment method defined in the applicability rule.
  • FND_APPLICATION: Joined via the APPLICATION_ID column. This links the rule to the specific EBS product (e.g., Oracle Payables, Oracle Receivables) that owns the payment transaction type.

Furthermore, this table is inherently related to the setup tables for the factors it uses, such as HR_ORGANIZATION_UNITS for First Party Organization and XLE_ENTITY_PROFILES for First Party Legal Entity, though these are typically enforced through application logic rather than a direct database foreign key constraint.

  • Table: IBY_APPLICABLE_PMT_MTHDS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_APPLICABLE_PMT_MTHDS,  object_name:IBY_APPLICABLE_PMT_MTHDS,  status:VALID,  product: IBY - Payments ,  description: IBY_APPLICABLE_PMT_MTHDS stores the payment method applicability information for company policy-based factors. The factors include First Party Legal Entity, First Party Organization, Payment Processing Transaction Type, Transaction is Forei ,  implementation_dba_data: IBY.IBY_APPLICABLE_PMT_MTHDS , 

  • Table: IBY_APPLICABLE_PMT_MTHDS 12.1.1

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

  • Table: IBY_PAYMENT_METHODS_B 12.1.1

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

  • Table: IBY_PAYMENT_METHODS_B 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PAYMENT_METHODS_B,  object_name:IBY_PAYMENT_METHODS_B,  status:VALID,  product: IBY - Payments ,  description: IBY_PAYMENT_METHODS stores the payment methods that Oracle Payments supports. A payment method is a payment attribute on a document payable that indicates how the first party payer is going to make the payment. Examples of payment methods i ,  implementation_dba_data: IBY.IBY_PAYMENT_METHODS_B ,