Check the Bi Loads  status.

Connect to <PREFIX>_BIA_ODIREPO/*****  connect to bi repository schema



SELECT TRUNC(SSR.SESS_END) AS SESSION_RAN_DATE,
SSR.CONTEXT_CODE,
SS.SCEN_NAME AS SCENARIO_NAME ,
SS.SCEN_VERSION AS SCEN_VERSION ,
null AS SESS_NO,
SSR.SESS_DUR AS DUR,
SSR.SESS_BEG,
SSR.SESS_END,
DECODE(SSR.SESS_STATUS,'D','SUCCESSFUL','E','FAILED')AS STATUS,
SSR.NB_ROW AS ROW_PROCESSED,
SSR.NB_INS AS ROWS_INSERTED,
SSR.NB_UPD AS ROWS_UPDATED,
SSR.NB_DEL AS ROWS_DELETED,
SSR.NB_ERR AS ERROR_RECORD
FROM PRD_BIA_ODIREPO.SNP_SCEN SS, PRD_BIA_ODIREPO.SNP_SESSION  SSR
WHERE
SS.scen_name=SSR.scen_name
AND SESS_STATUS ='D'
and TRUNC(SSR.SESS_END) =to_Date('05/11/2018','MM/DD/YYYY')
ORDER BY SSR.SESS_END asc ;