Trying to create one common BIP report that will be used to monitor scheduled ESS jobs. I came across these two tables
select * from fusion. ess_request_history
select * from fusion. ess_request_property
But these are not storing the error messages/reason, it simply stores status, parameters, date and time and so on. Ex, If the report failed to send the file to SFTP due to incorrect path the history page shows below error
“Document delivery failed
[INSTANCE_ID=bip.bi_server1] [DELIVERY_ID=-1]
Delivery is completed
[INSTANCE_ID=bip.bi_server1] [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.DeliveryException: Remote directory /Interfaces/POC2 does not exist on the server”
I want these data to be derived from table so that I can use in the common report to display messages to user.