How to extract PDF from ESS child job to attach to Email Notification Action

Summary:

How to extract PDF from ESS child job to attach to Email Notification Action

Content (please ensure you mask any confidential information):

I am looking for the best way to extract a PDF file from an ESS Job (or should I say the Child ESS job).

I have the below ESS job (Import Payables Invoices) being triggered from OIC integration:

What I want to do is fetch the PDF file from the child ESS job (Import Payables Invoices Report) as shown above and attach this to an Email Notification Action inf OIC integration as a PDF file:

The first challenge is that I am using the