Enterprise engineering
Payroll, PMS & Leave Encashment Integration
Automated processing of payroll, performance management, and leave encashment data within Oracle EBS.
- Role
- Oracle EBS technical engineer
- Timeline
- 2024 to Present
- Outcome
- Cuts manual processing time for recurring payroll and leave-related payment cycles.
The problem
Payroll, PMS-linked pay components, and leave encashment amounts are calculated from multiple inputs and previously required manual assembly before they could be processed and posted.
The approach
Built PL/SQL processing routines and concurrent programs that validate and prepare payroll, PMS, and leave encashment data for scheduled processing, reducing manual intervention in each pay cycle.
Implementation
- Automated payroll data processing workflows
- PMS-linked pay component handling
- Leave encashment calculation and processing
- Concurrent programs for scheduled payroll cycles
- Validation and error handling before posting
Technology
Oracle E-Business Suite R12, Oracle HRMS, Oracle Payroll, PL/SQL, Concurrent Processing, Oracle Reports