Oracle Application Practice Blog

 List of Scheduled BIP Reports

We can use below Query to fetch the list of scheduled Reports in fusion HCM

SELECT RH.REQUESTID,

  RH.NAME,

  RH.PROCESSSTART,

  RH.PROCESSEND,

  RH.COMPLETEDTIME,

  RH.EXECUTABLE_STATUS,

  RH.SUBMITTER,

  RH.USERNAME,

  RP.VALUE,

  SUBSTR(RP.VALUE,INSTR(RP.VALUE, '/', -1)+1) FN,

  DECODE(SC.VALUE,'false','Private','Public') SCOPE1,

  ROW_NUMBER() OVER ( PARTITION BY RH.USERNAME, RP.VALUE ORDER BY RH.USERNAME, RP.VALUE, RH.PROCESSEND DESC) RN

FROM FUSION_ORA_ESS.REQUEST_HISTORY RH,

  FUSION_ORA_ESS.REQUEST_PROPERTY RP,

  FUSION_ORA_ESS.REQUEST_PROPERTY SC

WHERE RH.REQUESTID = RP.REQUESTID

AND RH.REQUESTID   = SC.REQUESTID

AND SC.NAME        ='isShared'

AND RP.NAME        = 'report_url' 

In Output we can expect columns like Request ID, Name, username, Path, Status etc