Search Results pay

DeepSeek eTRM - PAY Tables and Views in Oracle EBS 12.1.1/12.2.2

Overview

The DeepSeek Electronic Technical Reference Manual (eTRM) provides comprehensive documentation on Oracle E-Business Suite (EBS) tables and views, specifically for the Payroll (PAY) module in versions 12.1.1 and 12.2.2. The PAY module handles payroll processing, compensation management, and statutory compliance, with its underlying database structure comprising hundreds of tables and views that store and process payroll-related data.

Core PAY Tables

The PAY module's data model is organized into logical groupings: 1. Employee Earnings & Deductions:

PAY_ELEMENT_ENTRIES_F - Stores element entries for employees
PAY_ELEMENT_LINKS_F - Links elements to payroll definitions
PAY_RUN_RESULTS - Contains calculated payroll results

2. Payroll Processing:

PAY_PAYROLLS_F - Master table for payroll definitions
PAY_PAYROLL_ACTIONS - Tracks payroll processing steps
PAY_ASSIGNMENT_ACTIONS - Logs assignment-level processing

3. Tax & Compliance:

PAY_TAXABILITY_RULES - Defines tax calculation rules
PAY_US_EMP_FED_TAX_RULES_F - US federal tax rules (country-specific)
PAY_STATUTORY_DEDUCTIONS - Statutory deduction requirements

Key Views

Oracle provides several views that simplify access to payroll data: 1. Reporting Views:

PAY_ELEMENT_ENTRIES_V - Consolidated view of element entries
PAY_PAYROLL_REGISTER_V - Payroll register information

2. Integration Views:

PAY_ALL_PAYROLLS_V - Payroll definitions for integration
PAY_ELEMENT_ENTRY_VALUES_V - Element entry values for interfaces

Technical Architecture

The PAY module follows Oracle's EBS architecture principles:

Effective-dated tables (with _F suffix) for historical tracking
Multi-org enabled tables for multi-organization support
PL/SQL packages (PAY_PAYRL_PKG, PAY_ELE_PKG) for business logic
Concurrent programs for batch processing

Version Differences (12.1.1 vs 12.2.2)

While the core structure remains consistent, 12.2.2 introduces:

Enhanced tables for cloud integration
New views for HCM Analytics
Additional columns in existing tables for new features
Performance optimizations in key tables

Implementation Considerations

When working with PAY tables:

Always use APIs for data modifications
Respect effective dating in custom queries
Consider performance impact when joining large tables
Review Oracle's support recommendations before direct table access

The DeepSeek eTRM provides detailed column-level documentation, indexes, constraints, and relationships for all PAY tables and views, serving as an essential reference for Oracle Payroll implementations, customizations, and integrations.

Concurrent Program: PAYRPEMV(PAY) 12.2.2
execution_filename: PAYRPEMV , product: PAY - Payroll , user_name: PAYRPEMV , description: Worker Organization Movements Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
eTRM - PAY External Dependencies 12.1.1
Concurrent Program: PAYRPEMV(PAY) 12.1.1
execution_filename: PAYRPEMV , product: PAY - Payroll , user_name: PAYRPEMV , description: Worker Organization Movements Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
eTRM - PAY External Dependencies 12.2.2
Lookup Type: PAY GROUP 12.1.1
product: PO - Purchasing , meaning: Valid pay groups , description: Valid pay groups ,
Lookup Type: PAY GROUP 12.2.2
product: PO - Purchasing , meaning: Valid pay groups , description: Valid pay groups ,
eTRM - PAY Tables and Views 12.2.2
description: Temporary table used to hold invalid location addresses. ,
eTRM - PAY Tables and Views 12.1.1
description: Temporary table used to hold invalid location addresses. ,
Lookup Type: DONT PAY REASON 12.1.1
product: AP - Payables , meaning: Dont Pay Reason , description: Reason for not paying an invoice selected for payment ,
Lookup Type: PAY DATE BASIS 12.2.2
product: AP - Payables , meaning: Pay date basis , description: Pay date basis ,
eTRM - PAY Tables and Views 12.1.1
description: Temporary table used to hold invalid location addresses. ,
Lookup Type: DONT PAY REASON 12.2.2
product: AP - Payables , meaning: Dont Pay Reason , description: Reason for not paying an invoice selected for payment ,
eTRM - PAY Tables and Views 12.2.2
description: Temporary table used to hold invalid location addresses. ,
Lookup Type: PAY ON CODE 12.1.1
product: PO - Purchasing , meaning: Pay on code , description: Pay on code ,
Lookup Type: PAY DATE BASIS 12.1.1
product: PO - Purchasing , meaning: Pay date basis , description: Pay date basis ,
Lookup Type: ALLOW FUTURE PAY OPTION 12.2.2
product: AP - Payables , meaning: ALLOW FUTURE PAY OPTION , description: Option that determines whether future dated payments are allowed or not for a payment document ,
Lookup Type: PAY DATE BASIS 12.1.1
product: AP - Payables , meaning: Pay date basis , description: Pay date basis ,
Lookup Type: PAY DATE BASIS 12.2.2
product: PO - Purchasing , meaning: Pay date basis , description: Pay date basis ,
Lookup Type: PAY ON CODE 12.2.2
product: PO - Purchasing , meaning: Pay on code , description: Pay on code ,
Lookup Type: ALLOW FUTURE PAY OPTION 12.1.1
product: AP - Payables , meaning: ALLOW FUTURE PAY OPTION , description: Option that determines whether future dated payments are allowed or not for a payment document ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.1.1
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: PAY US VERTEX INTERFACE 12.1.1
product: PER - Human Resources , meaning: PAY US Vertex Interface , description: List of Different interface options available for Tax Calculation ,
Lookup Type: PAY ON CODE HTML 12.2.2
product: PO - Purchasing , meaning: Pay On Code HTML , description: Pay On Code used in HTML pages ,
Lookup Type: FUTURE PAY ACCT SOURCE 12.2.2
product: AP - Payables , meaning: Future Pay Acct Source , description: Source for future dated payment account ,
Lookup Type: FUTURE PAY LIAB RELIEF 12.2.2
product: AP - Payables , meaning: Future Pay Liab Relief , description: Future dated payments liability relief option ,
Lookup Type: PAY ON CODE HTML 12.1.1
product: PO - Purchasing , meaning: Pay On Code HTML , description: Pay On Code used in HTML pages ,
Lookup Type: FUTURE PAY LIAB RELIEF 12.1.1
product: AP - Payables , meaning: Future Pay Liab Relief , description: Future dated payments liability relief option ,
Lookup Type: PAY US VERTEX INTERFACE 12.2.2
product: PER - Human Resources , meaning: PAY US Vertex Interface , description: List of Different interface options available for Tax Calculation ,
File: FV Treasury Confirmation Pay Instr R12.pdf 12.1.1
product: FV - Federal Financials , size: 22.913 KBytes , file_type: PDF Diagram ,
File: FV Treasury Confirmation Pay Instr R12.pdf 12.2.2
product: FV - Federal Financials , size: 22.913 KBytes , file_type: PDF Diagram ,
APPS.PAY_JP_WIC_PKG dependencies on FND_MESSAGE 12.1.1
APPS.PAY_JP_ITAX_REPORT_PKG dependencies on FND_MESSAGE 12.1.1
APPS.PAY_JP_ITAX_REPORT_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PAY_JP_WIC_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PAY_JP_REPORT_PKG dependencies on FND_MESSAGE 12.1.1
APPS.PAY_ZA_EOY_VAL dependencies on FND_MESSAGE 12.1.1
APPS.PAY_JP_CUSTOM_PKG dependencies on FND_MESSAGE 12.1.1
APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PAY_JP_CUSTOM_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PAY_JP_ISDF_SS_PKG dependencies on FND_MESSAGE 12.1.1
Lookup Type: PAY_GROUP_VALIDATION_TYPE 12.1.1
product: CN - Incentive Compensation , meaning: Pay Group Validation , description: Pay Group Validation ,
Lookup Type: PQP_PENSERVER_EVENT_DESC 12.2.2
product: PQP - Public Sector Payroll , meaning: Penserver service history event description ,
APPS.HR_JP_DATA_MIGRATION_PKG dependencies on FND_MESSAGE 12.2.2
APPS.GHR_CPDF_CHECK8 SQL Statements 12.1.1
APPS.HR_PPU_SHD dependencies on FND_MESSAGE 12.1.1
APPS.HR_SE_VALIDATE_PKG dependencies on FND_MESSAGE 12.1.1
APPS.HR_SE_VALIDATE_PKG dependencies on FND_MESSAGE 12.2.2
Lookup Type: PQP_PENSERVER_EVENT_DESC 12.1.1
product: PQP - Public Sector Payroll , meaning: Penserver service history event description ,
APPS.PAY_BTH_SHD dependencies on FND_MESSAGE 12.1.1
Lookup Type: PAY_GROUP_VALIDATION_TYPE 12.2.2
product: CN - Incentive Compensation , meaning: Pay Group Validation , description: Pay Group Validation ,