Enterprise engineering
HRMS Integration
A synchronization integration keeping employee, assignment, supervisor, and organization data aligned between HRMS and Oracle EBS.
- Role
- Oracle EBS technical engineer
- Timeline
- 2024 to Present
- Outcome
- Keeps HR and organizational data consistent across systems without manual re-entry.
The problem
Employee, assignment, supervisor, and organization records are maintained in HRMS but also needed inside Oracle EBS for downstream payroll, reporting, and workflow processes, creating a risk of data drift between systems.
The approach
Implemented a PL/SQL-based synchronization process that validates and propagates employee, assignment, supervisor, and organization data from HRMS into Oracle EBS, with staging and error handling to catch mismatches before they reach base tables.
Implementation
- Employee and assignment data synchronization
- Supervisor hierarchy and organization structure updates
- Staging-based validation before base table updates
- Error handling and reconciliation for failed records
- Scheduled and on-demand synchronization runs
Technology
Oracle E-Business Suite R12, Oracle HRMS, Oracle Database, PL/SQL, Concurrent Processing