BI Publisher – Get the ESS REQUEST LOGS
SELECT ESS_REQUEST_ID,
ERROR_MESSAGE ,
JOB_ITEM_STATUS
FROM MOW_BATCH_ASGN_JOB_ITEMS
WHERE ESS_REQUEST_ID = '{Numeric ID of the Request}'
AND JOB_ITEM_STATUS='-1'
AND rownum <= 10