Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
Payroll Worker Process running slow
EBS 12.1.3 RDBMS 11.2.0.3.0
Payroll Worker Process is taking more than 8 hours to complete.This database is running on Exadata server.
Most of the time it is running followign query
SELECT EEV.SCREEN_ENTRY_VALUE
FROM PAY_INPUT_VALUES_X IV, PAY_ELEMENT_ENTRY_VALUES_F EEV
WHERE EEV.ELEMENT_ENTRY_ID = :B2
AND IV.INPUT_VALUE_ID = EEV.INPUT_VALUE_ID
AND IV.NAME = :B1
Cell Single block physical read is highest wait event for above query.Explain plan is using Indexes.
Any help to tune the program is greatly appreciated.
Thanks in advance.