I would recommend to explore the use of the activity ‘Invoke VBA’ and and the VBA coding provided by Oracle in the file found under C:\oracle\SmartView\bin\smartview.bas. You can find help in the Developers Guide: https://docs.oracle.com/cd/E51367_01/financialsop_gs/FASVD/toc.htm
‘Invoke VBA’ and ‘Excecute Macro’ activities are very sensitive to Security settings in the Excel document. Even though you have done everything correct in ‘Trust Center’, you can get error Messages that Macros are disabled. You have to find the best way to create new doccuments that work in your environment. Inheriting Excel documents created on other PC’s/VDI’s or i.e. retrieved from SharePoint, would often result in error messages telling you that macros are disabled.
My experience so far with ‘Invoke VBA’ instead of clicking on ‘SmartView’ icons is that it is more reliable and robust, but still have challenges and you dont always get any error Message when things dont work.