You'll need to use the decodeBase64ToReference function to set the FileReference. Once you have eventually got your 'GET_FILE' call working, use a FTP adapter to write the file.
Mike is going to do an update on Discoverer migration and interoperability with Oracle BI Suite Enterprise Edition, and I'm going to. It ask for username, password & report server. when i try to log on in BI Publisher option in ms-word. Today i have installed Oracle BI publisher desktop for making reports in ms-word 2007. I am beginner to use Oracle BI publisher for making reports. One of the presentations I'm giving on the Monday at the UKOUG Conference is a joint talk with Mike Durran, the Oracle Discoverer Product Manager. I have installed Oracle 10g database and Oracle 10g developer suite. Here's an example call that you'd have to map in OIC too.ĭDocAccount = `hcm$/dataloader$/export$` dDocTitle `Surabhi` dOriginalName `Very_Large` Email Distribution of Reports using BI Publisher and Discoverer. If the 'File Name' is dynamically named by your BI Report, and therefore you do not know exactly what the file name is, then you will have to run the 'GET_SEARCH_RESULTS' operation (again using the 'GenericSoapPort' connection) with a query to find your specific file in UCM before you use the 'GET_FILE' operation. The 'GET_FILE' operation allows you to provide things like the 'dOriginalName' (File Name) to obtain the file in Base64. When you trying to create new Data Sources - JDBC source (Navigate to Administrator link -> Manage BI Publisher ->JDBC Connection) - with Oracle Database. In a second part, or better still a separate integration, run the 'GET_FILE' operation on an OIC Connection based on the './idcws/GenericSoapPort?WSDL'. The 'submitReport' executes the BI Report, but the output can be placed in a UCM account (folder).
One part to execute the 'submitReport' operation (not the 'runReport' as Kabir brilliantly took us through above).then wait for the report to complete.
I think you would need break the process into 2 parts.