Search Results pay_run_results
The PAY_RUN_RESULTS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Payroll module, storing detailed payroll calculation results for employees. This table serves as the foundation for payroll processing, capturing computed earnings, deductions, taxes, and other elements generated during a payroll run. Below is a detailed technical overview of its structure, purpose, and integration within Oracle EBS.
1. Purpose and Functionality
The PAY_RUN_RESULTS table stores granular payroll results for each employee processed in a payroll run. It records:- Earnings: Regular pay, overtime, bonuses, and other compensations.
- Deductions: Statutory or voluntary deductions like taxes, benefits, or loans.
- Tax Calculations: Tax withholdings at federal, state, or local levels.
- Accruals: Leave balances or other accrual-based payments.
2. Key Columns and Relationships
The table includes critical columns such as:- RUN_RESULT_ID: Primary key, uniquely identifying each payroll result.
- ASSIGNMENT_ACTION_ID: Foreign key linking to PAY_ASSIGNMENT_ACTIONS, which ties results to payroll runs.
- ELEMENT_TYPE_ID: References PAY_ELEMENT_TYPES_F to identify the payroll element (e.g., salary, tax).
- STATUS: Indicates result status (e.g., 'PAID', 'VOIDED').
- AMOUNT: Monetary value of the result.
- TAX_UNIT_ID: Links to tax jurisdiction details in PAY_TAX_UNITS.
- PAY_ELEMENT_ENTRIES_F: Source of element entries for calculations.
- PAY_PAYROLL_ACTIONS: Parent payroll run context.
- PER_ALL_ASSIGNMENTS_F: Employee assignment details.
3. Technical Implementation
The table is populated during payroll execution via:- Payroll Run Process: The Payroll Process (PYUGEN) generates results based on element entries, rules, and formulas.
- Retro Pay: Adjustments for past periods create new rows with corrected amounts.
- QuickPay: Ad-hoc payments insert additional rows.
4. Integration and Reporting
PAY_RUN_RESULTS feeds downstream processes:- Payslip Generation: Results are aggregated for employee payslips.
- General Ledger: Posted via Payroll Transfer to GL (PYTGL).
- Tax Reporting: Used for year-end filings (e.g., W-2, 1099).
- Third-Party Payments: Exported for bank or benefit provider processing.
5. Common Customizations and Considerations
- Formula Adjustments: Custom formulas may modify results before insertion.
- Retroactive Processing: Requires careful handling to avoid data corruption.
- Performance: Large payroll runs may necessitate partitioning or archiving.
Conclusion
The PAY_RUN_RESULTS table is central to Oracle Payroll, capturing the output of payroll calculations for compliance, reporting, and payment processing. Its design supports complex payroll scenarios while maintaining data integrity through relationships with other core tables. Understanding its structure is essential for troubleshooting, customization, and optimizing payroll operations in Oracle EBS.-
Table: PAY_RUN_RESULTS
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_RESULTS, object_name:PAY_RUN_RESULTS, status:VALID, product: PAY - Payroll , description: Result of processing a single element entry. , implementation_dba_data: HR.PAY_RUN_RESULTS ,
-
Table: PAY_RUN_RESULTS
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PAY.PAY_RUN_RESULTS, object_name:PAY_RUN_RESULTS, status:VALID, product: PAY - Payroll , description: Result of processing a single element entry. , implementation_dba_data: HR.PAY_RUN_RESULTS ,
-
APPS.PAY_JP_RETRO_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_SA_ARCHIVE dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_IE_BIK dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_SOE_GLB dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PYNEGNET01 dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PQP_CLM_BAL dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_TRGL_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_CTY_BUS dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_BALANCE_UPLOAD dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_NZ_REC_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PSP_PAYTRN dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_CNT_BUS dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_SA_GOSI_REPORTS dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_NL_SOE dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.HR_GBBAL dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_KR_REPORT_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_MX_YREND_ARCH dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.BEN_EXT_RUNRSLT dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_FR_OVERTIME dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_PURGE_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_DK_PR_ASG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_AU_SOE_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_DK_PR_ELE dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.BEN_EXT_PERSON dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_IN_TAX_UTILS dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_BAL_ADJUST dependencies on PAY_RUN_RESULTS
12.1.1
-
APPS.PAY_KR_SAMPLE_SEP_PKG dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.HR_ENTRY dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PY_ZA_TX_01032012 dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_DK_PR_ORG dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PQP_CLM_BAL dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_CTY_BUS dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.HR_US_FF_UDFS dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_NL_REM_REPORT dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_SA_SOE dependencies on PAY_RUN_RESULTS
12.2.2
-
APPS.PAY_EMP_ACTION_ARCH dependencies on PAY_RUN_RESULTS
12.2.2