Results for “pay_cn_arch_payment_methods_v”

26 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PAY_CN_ARCH_PAYMENT_METHODS_V view is an Oracle EBS Payroll (PAY) object owned by the APPS schema. It is a reporting and archival (archive) view that presents an integrated, denormalized picture of payment method information as it applies to employee net pay distributions. Functionally, the view consolidates the relationship between an assignment action, the organizational payment method, the employee's personal payment method, and the associated external bank account details. It is particularly relevant for organizations that need to reconcile, audit, or report on the payment instructions recorded against payroll assignment actions, including the currency and payment amount involved.

The view derives its data from the PAY_ACTION_INFORMATION table filtered to the ACTION_INFORMATION_CATEGORY of 'EMPLOYEE NET PAY DISTRIBUTION' and an ACTION_CONTEXT_TYPE of 'AAP'. This makes it a specialized object oriented toward net pay distribution and payment method analysis rather than general payroll processing.

Underlying Base Objects

The view is defined over five documented base objects, all referenced as synonyms in the APPS schema:

The joins are date-effective, using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE bounds against the action's effective date. The view is structured as a UNION ALL, combining multiple selection branches that align organizational and personal payment attributes into a single column set.

Key Columns

Common Use Cases and Queries

This view is typically used to report or audit employee net pay distributions, reconcile payment amounts against payment methods, and support archival or compliance reporting. A common query locates all distributions for a specific PERSONAL_PAYMENT_METHOD_ID:

SELECT assignment_action_id,
       personal_payment_method_id,
       personal_payment_method_name,
       personal_bank_account_number,
       currency_code,
       payment_amount
  FROM apps.pay_cn_arch_payment_methods_v
 WHERE personal_payment_method_id = :p_personal_payment_method_id;

To summarize net pay by organizational payment method category, an aggregate query can be issued:

SELECT org_payment_category,
       SUM(payment_amount) total_amount
  FROM apps.pay_cn_arch_payment_methods_v
 GROUP BY org_payment_category;

Because the view joins date-effective payment method tables, effective date alignment should be considered when interpreting results. The view is read-only and should not be used for data manipulation.