Search Results system_org_pay_method_name




Overview
Explore in AI Chat

Overview

The APPS.PAY_ORG_PAYMENT_METHODS_D view presents organization-level payment method definitions maintained within Oracle Payroll. It is a denormalized, translation-aware reporting view that joins the base payment method entity to its translated display names, the parent payment type hierarchy, and the FND user directory. The "_D" suffix conventionally indicates a descriptive or display-oriented view intended for reporting and integration rather than for transactional data entry.

In Oracle EBS 12.1.1 and 12.2.2, this view serves as a stable, read-only projection of organizational payment method configuration. Consumers query it to resolve the human-readable name of a payment method, its governing payment type, and its effective dating without reconstructing the multi-table join themselves. The view exposes the column alias SYSTEM_ORG_PAY_METHOD_NAME (documented in the ETRM metadata as SYSTEM_ORG_PAY_METHOD_NAME), which is the attribute frequently referenced by users searching for "system_org_pay_method_name."

Underlying Base Objects

Per the documented view text and ETRM metadata for 12.2.2, the view is defined over five referenced base objects, all exposed in the APPS schema as synonyms:

The join is constrained by USERENV('LANG') on both translation tables, ensuring names are returned in the session's current language. The FND_USER join is an outer join, so rows persist even where the updating user cannot be resolved.

Key Columns

  • ORG_PAYMENT_METHOD_ID — unique identifier of the organization payment method; the primary join key across all payment method tables.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date range during which the payment method definition is valid.
  • PAYMENT_TYPE_NAME — the translated name of the parent payment type (for example, a check, direct deposit, or electronic type), sourced from PAY_PAYMENT_TYPES_TL.
  • ORG_PAYMENT_METHOD_NAME — the translated, language-specific organization payment method name, sourced from PAY_ORG_PAYMENT_METHODS_F_TL.
  • SYSTEM_ORG_PAY_METHOD_NAME — an alias of the base name column PAYORG.ORG_PAYMENT_METHOD_NAME from the _F table. This is the column users most often search for via the term "system_org_pay_method_name," as it represents the system (untranslated base) payment method name.
  • LAST_UPDATE_DATE — timestamp of the most recent change to the record.
  • USER_NAME — the FND user name of the last updater, where resolvable.

Common Use Cases and Queries

Typical uses include validating payment method configuration during setup audits, populating downstream payment interfaces, and joining to payroll or payment records that reference ORG_PAYMENT_METHOD_ID. A representative query follows:

  • Retrieve all active payment methods with their type and system name: 
    SELECT org_payment_method_id,
       org_payment_method_name,
       system_org_pay_method_name,
       payment_type_name,
       effective_start_date,
       effective_end_date
FROM   apps.pay_org_payment_methods_d
WHERE  TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
  • Filter by the system column of interest: 
    SELECT org_payment_method_id, system_org_pay_method_name, user_name
FROM   apps.pay_org_payment_methods_d
WHERE  system_org_pay_method_name IS NOT NULL
ORDER  BY system_org_pay_method_name;
  • Audit recently modified definitions: 
    SELECT org_payment_method_name, payment_type_name,
       last_update_date, user_name
FROM   apps.pay_org_payment_methods_d
WHERE  last_update_date >= SYSDATE - 30;