Oracle Fusion: Can BI Publisher interract with a file held in UCM

Hi,

Hoping you might be able to provide some thoughts on a possible way of working with BI Publisher in Fusion.  We have a reporting problem in that we will have some information input directly into a bespoke PaaS application which we need to view alongside financials held in the Fusion SaaS application.  The bespoke app will transfer transactions to Fusion at the end of the month however during the month we need a view of these 'in-flight' transactions within reports (but we do not want these transactions created in Fusion until month end).

A possible way of tackling this I have been asked to explore is: