Table for Rerport Job History details
SummaryRequire table and columns for Failed SFTP details from Report Job History
I have build a report which will have the details of all extract which got error out and their flow details. I am facing a scenario where the extract run was successful but the BI report was not delivered due to an SFTP issue. This did not get capture in the report since the ERRORED flag from PAY_FLOW_INSTANCES is 'N'. From Extract standpoint it has run successful but the report didn't get delivered due to SFTP issue.
So now I need to get the SFTP error details (from the Report Job History for the HCM Extract ran) captured in My Custom Report inorder to show the error occurred at the delivery end.