Payroll worker process hanging

[raiq1]

Dear sir,

For last two months we are having a issue on payroll  , HR users are running payroll related jobs.

Especially Retropay by Element / Retropay (Enhanced) are having a performance issue, today also we

have faced same issue and retro are hanging for One company in 45% and it has take 2 hours 30 minute

to completed, we have group of companies and we ran retro program with each companies , issue are

occurred for one company .

Last month also retro are hanging but different company.

Need your advice to fix the performance issue related to HR Retro enhanced job.

For your reference attached the log files.

Regards,
Raiq.Retro_hanging.JPGpayroll_worker_process.JPG

[ErmanArslansOracleBlog]

not enough technical details..  With that, the issue seems functional..
If it is waiting for the database we need a trace -> Level 12 - Raw Trace File

How to Generate SQL Level traces (Level 4, Level 8, Level 12) for Performance Issues [Document 364479.1]
Sort TKPROF using the following syntax:
tkprof .trc .prf explain=apps/pw@yourdb sort='(fchela exeela prsela)'

Also please see ->

Performance is Slow in Retropay by Element or Retropay (Enhanced) (Doc ID 1605506.1)
Enhanced RetroPay: Performance issue detected after RUP (Doc ID 1500546.1)
Payroll Processes (Payroll Run, RetroPay By Element) Performance Issue (Doc ID 2102177.1)