Request completed with error 

SELECT f.user_name, r.request_id, prg.concurrent_program_name Module, p.USER_CONCURRENT_PROGRAM_NAME,
decode(r.phase_code,
'C' , 'Completed',
'I' , 'Inactive',
'P' , 'Pending',
'R' , 'Running',r.phase_code) Phase_Desc,
  decode( r.status_code,
'A' , 'Waiting'
,'B' , 'Resuming'
,'C' , 'Normal'
,'D' , 'Cancelled'
,'E' , 'Error'
,'F' , 'Scheduled'
,'G' , 'Warning'
,'H' , 'On Hold'
,'I' , 'Normal'
,'M' , 'No Manager'
,'Q' , 'Standby'
,'R' , 'Normal'
,'S' , 'Suspended'
,'T' , 'Terminating'
,'U' , 'Disabled'
,'W' , 'Paused'
,'X' , 'Terminated'
,'Z' , 'Waiting',r.status_code)
 Status_Desc, r.actual_start_date, r.actual_completion_date
FROM fnd_concurrent_requests r,fnd_concurrent_programs_tl p,fnd_concurrent_programs prg, fnd_user f
WHERE r.program_APPLICATION_ID=p.APPLICATION_ID and
r.CONCURRENT_PROGRAM_ID =p.CONCURRENT_PROGRAM_ID and
r.requested_by = f.user_id and
r.program_APPLICATION_ID=prg.APPLICATION_ID and
r.CONCURRENT_PROGRAM_ID =prg.CONCURRENT_PROGRAM_ID
and r.status_code in ('E','G')
and trunc(r.actual_completion_date) = trunc(sysdate - 1)
-- and f.user_name in ('SYSADMIN','TKMINFYADMIN','TKMP2POUTBOUND','TKMINTERFACE');