Oracle EBS – Query to concurrent details for past 60 days
oracle-ebs-query-to-concurrent-details-for-past-60-days SELECT distinct ft.user_concurrent_program_name “Concurrent Program Name”, fr.REQUEST_ID “Request ID”, to_char(fr.ACTUAL_START_DATE,’dd-MON-yy hh24:mi:ss’) “Started Date”, to_char(fr.ACTUAL_COMPLETION_DATE,’dd-MON-yy hh24:mi:ss’) “Completed Date”, decode(fr.PHASE_CODE,’C’,’Completed’,’I’,’Inactive’,’P’,’Pending’,’R’,’Running’,’NA’) “Phasecode”, decode(fr.STATUS_CODE, ‘A’,’Waiting’, ‘B’,’Resuming’, ‘C’,’Normal’, ‘D’,’Cancelled’, ‘E’,’Error’, ‘F’,’Scheduled’, ‘G’,’Warning’, ‘H’,’On Hold’,…
Read More