Search Results default_payment_method




Overview
Explore in AI Chat

Overview

HRFV_PAYROLLS is a business view template owned by the APPS schema in Oracle E-Business Suite, classified under the PER (Human Resources) product family. As its description states, it is the "business view template from which the flexfield view is generated." In Oracle EBS 12.1.1 and 12.2.2, this object serves as the source definition that underpins descriptive flexfield (DFF) enabled reporting views for payroll entities. It presents payroll definitions alongside their business group, payroll period type, and default payment method, providing a denormalized, security-filtered read layer over the core payroll tables.

Because it carries the designation '_DF:PAY:PAY_PAYROLLS:PAY' in its "_DF" column, the view is explicitly tied to the PAY_PAYROLLS descriptive flexfield. This makes it a foundational component for exposing flexfield context and segment values in downstream reporting and integration scenarios. The view is created as WITH READ ONLY, confirming its purpose as a query-only reporting object rather than a transactional interface.

Underlying Base Objects

The documented metadata identifies the base objects referenced by HRFV_PAYROLLS. The primary data source is PAY_PAYROLLS_X, the payroll definition view, aliased as PAY. The default payment method is resolved through PAY_ORG_PAYMENT_METHODS_X (aliased OPM) via an outer join on DEFAULT_PAYMENT_METHOD_ID. The business group name is obtained from HR_ALL_ORGANIZATION_UNITS_TL (aliased BGRT), joined on BUSINESS_GROUP_ID and the current language.

Two supporting packages are documented: HR_GENERAL and HR_SECURITY, along with HR_BIS, whose GET_SEC_PROFILE_BG_ID function enforces business group security. The join to HR_ALL_ORGANIZATION_UNITS_TL is a synonym, and the language predicate uses USERENV('LANG') to return translated names. The security predicate PAY.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PAY.BUSINESS_GROUP_ID) restricts rows to authorized business groups when a security profile is active, and returns all rows otherwise.

Key Columns

  • BUSINESS_GROUP_NAME — Translated name of the business group owning the payroll, from HR_ALL_ORGANIZATION_UNITS_TL.
  • PAYROLL_NAME — Name of the payroll definition.
  • PAYROLL_PERIOD_TYPE — The payroll's period type (for example, monthly, weekly, semi-monthly).
  • DEFAULT_PAYMENT_METHOD — The organization payment method name resolved from PAY_ORG_PAYMENT_METHODS_X; the "default payment method" for the payroll.
  • "_DF" — Flexfield descriptor token '_DF:PAY:PAY_PAYROLLS:PAY' identifying the associated DFF.
  • BUSINESS_GROUP_ID — Identifier of the owning business group.
  • DEFAULT_PAYMENT_METHOD_ID — The foreign key to the organization payment method; this is the column users commonly search for as default_payment_method_id.
  • PAYROLL_ID — Primary identifier of the payroll definition.

Common Use Cases and Queries

Analysts use HRFV_PAYROLLS to report payroll configuration, particularly to determine which payment method is assigned by default to each payroll. The DEFAULT_PAYMENT_METHOD_ID column is central to such queries, as the object is frequently searched in that context. A representative query lists payrolls and their resolved payment methods for the current session's business group security:

  • SELECT payroll_name, payroll_period_type, default_payment_method, default_payment_method_id FROM apps.hrfv_payrolls ORDER BY business_group_name, payroll_name;
  • SELECT payroll_id, payroll_name, default_payment_method_id FROM apps.hrfv_payrolls WHERE default_payment_method_id IS NULL; — identifies payrolls lacking a default payment method.
  • SELECT p.payroll_name, o.org_payment_method_name FROM apps.hrfv_payrolls p JOIN apps.pay_org_payment_methods_x o ON p.default_payment_method_id = o.org_payment_method_id; — corroborates the outer join exposed by the view.

The view's read-only nature and security-aware predicate make it suitable for concurrent programs, BI Publisher data models, and integration extracts that must respect HR security profiles.