Results for “pay_payrolls_x”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_PAYROLLS_X is a date-effective (datetracked) view owned by the APPS schema in Oracle E-Business Suite, belonging to the PAY – Payroll product. It presents the currently active payroll definitions for an enterprise as of the system date. The view is defined over the PAY_PAYROLLS_F base table, applying an effective-date filter so that only rows where the current date falls between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE are returned. In Oracle EBS 12.1.1 and 12.2.2, this pattern mirrors the standard date-tracked object convention: the "_F" object stores all versioned rows, while the "_X" view exposes the single active version for transactional and reporting use. Because the view filters on TRUNC(SYSDATE), it always returns a consistent, point-in-time snapshot of valid payroll records without requiring the caller to supply date parameters. This makes it the preferred source for concurrent programs, reports, and integrations that must reference a payroll's current configuration.
Underlying Base Objects
The documented base object is PAY_PAYROLLS_F (VIEW), from which all columns are inherited. The ETRM metadata lists HR_GENERAL (PACKAGE) and HR_SECURITY (PACKAGE) as supporting references associated with the object. HR_SECURITY is significant because date-effective HR/payroll views commonly embed business-group security predicates at runtime, ensuring the querying session only sees payrolls for organizations it is authorized to access. The view text itself is a direct projection of PAY_PAYROLLS_F columns with the effective-date WHERE clause appended, and no joins are performed within the view definition. In Oracle EBS releases, PAY_PAYROLLS_F provides the versioned data and is conventionally paired with a corresponding _X date-effective view.
Key Columns
The view exposes the full payroll attribute set. The primary key column PAYROLL_ID uniquely identifies each payroll. EFFECTIVE_START_DATE and EFFECTIVE_END_DATE delimit the version's validity window. BUSINESS_GROUP_ID and ORGANIZATION_ID establish ownership and legislative context. The column most relevant to the search term, SUSPENSE_ACCOUNT_KEYFLEX_ID, stores the key flexfield combination identifier for the suspense account to which unresolved payroll entries are posted. Closely related accounting columns include COST_ALLOCATION_KEYFLEX_ID, SOFT_CODING_KEYFLEX_ID, and GL_SET_OF_BOOKS_ID, which govern costing, soft coding, and general ledger mapping. Payment and scheduling behavior is controlled by DEFAULT_PAYMENT_METHOD_ID, CONSOLIDATION_SET_ID, PERIOD_TYPE, CUT_OFF_DATE_OFFSET, PAY_DATE_OFFSET, PAY_ADVICE_DATE_OFFSET, DIRECT_DEPOSIT_DATE_OFFSET, FIRST_PERIOD_END_DATE, MIDPOINT_OFFSET, and NUMBER_OF_YEARS. Flags such as NEGATIVE_PAY_ALLOWED_FLAG, ARREARS_FLAG, and MULTI_ASSIGNMENTS_FLAG control validation rules. Descriptive and audit columns include PAYROLL_NAME, COMMENT_ID, ATTRIBUTE_CATEGORY, ATTRIBUTE1–20, PRL_INFORMATION_CATEGORY, PRL_INFORMATION1–30, and the standard WHO audit columns.
Common Use Cases and Queries
The view is typically used to list active payrolls, retrieve configuration for a specific payroll, or resolve the suspense account flexfield for accounting integrations. A representative query retrieving the suspense account keyflex for all active payrolls is:
- SELECT PAYROLL_ID, PAYROLL_NAME, SUSPENSE_ACCOUNT_KEYFLEX_ID, GL_SET_OF_BOOKS_ID FROM APPS.PAY_PAYROLLS_X WHERE BUSINESS_GROUP_ID = :p_business_group_id;
- SELECT PAYROLL_ID, PAYROLL_NAME, PERIOD_TYPE, PAY_DATE_OFFSET, CUT_OFF_DATE_OFFSET FROM APPS.PAY_PAYROLLS_X ORDER BY PAYROLL_NAME;
- SELECT PAYROLL_ID, COST_ALLOCATION_KEYFLEX_ID, SOFT_CODING_KEYFLEX_ID FROM APPS.PAY_PAYROLLS_X WHERE PAYROLL_ID = :p_payroll_id;
Because the view draws exclusively from PAY_PAYROLLS_F, it is read-only and intended for querying rather than DML. For historical or future-dated versions of a payroll, query PAY_PAYROLLS_F directly with the appropriate date range.
-
View: PAY_PAYROLLS_X 12.1.1
Date-effective view.
APPS.PAY_PAYROLLS_X·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_F·Explore PAY module →
-
View: PAY_PAYROLLS_X 12.2.2
Date-effective view.
APPS.PAY_PAYROLLS_X·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_F·Explore PAY module →
-
VIEW: APPS.PAY_PAYROLLS_X 12.1.1
-
VIEW: APPS.PAY_PAYROLLS_X 12.2.2
-
APPS.PSP_ORIG_LINE_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_X·Explore PSP module →
-
View: HRFV_PAYROLLS 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_PAYROLLS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_SEL_PAYROLL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_X·Explore PER module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_SEL_PAYROLL_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_X·Explore PER module →
-
View: HRFV_PAYROLLS 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_PAYROLLS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·↳ HR_GENERAL·Explore PER module →
-
APPS.PSP_ORIG_LINE_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PAY_PAYROLLS_X·Explore PSP module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_SELECTION_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_CERIDIAN·↳ HR_GENERAL·Explore PER module →
-
View: HR_ADP_WORKERS_COMP_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_WORKERS_COMP_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
Ceridian Source 500 payroll interface view
APPS.HR_CERIDIAN_500_SELECTION_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_CERIDIAN·↳ HR_GENERAL·Explore PER module →
-
View: HR_ADP_WORKERS_COMP_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_WORKERS_COMP_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
VIEW: APPS.HRFV_PAYROLLS 12.1.1
-
View: HR_ADP_ADDRESS_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_ADDRESS_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: HR_ADP_ADDRESS_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_ADDRESS_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
VIEW: APPS.HRFV_PAYROLLS 12.2.2
-
View: HR_ADP_FED_TAX_V 12.2.2
ADP payroll interface view
APPS.HR_ADP_FED_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
APPS.HR_ADP_PAYMENT_METHODS_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →
-
View: HR_ADP_FED_TAX_V 12.1.1
ADP payroll interface view
APPS.HR_ADP_FED_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →