Oracle Fusion invoking BI as webservice

This feature can be used to extract data from Cloud applications for further analysis and for importing into external systems via XML, EXCEL, CSV, or other file types.

Integration is an obvious requirement as businesses migrate from legacy on-premise systems to Oracle Fusion Cloud.

During the migration, different businesses could have different requirements. For example, some would prefer to run a parallel system along with Oracle Fusion Cloud while others could opt for a co-existence solution to analyse Fusion data in their legacy systems. Additionally, a few others may require real-time data even before the integration is complete. For example, a legacy system where payroll is implemented, is expected to have real-time salary or absenteeism data.

Oracle’s SaaS applications provide robust integration functionality such as extract, BI, HCM data loader, and web services. For instance, Oracle Fusion’s inbuilt feature, a BI report, built in Fusion can be invoked by a webservice and can help to automate real-time data in a faster and efficient way.

To know more about Fusion Practices' Oracle Implementation Services

BI as a Webservice

This feature can be used to extract data from Cloud applications for further analysis and for importing into external systems via XML, EXCEL, CSV, or other file types.

Oracle BI Publisher can then be used to export data that needs to be imported into external systems. It allows developers to build custom queries on transactional data, the output of which can be downloaded to Excel. Developers can also configure an OTBI or BI Publisher Report and generate the output based on their organisation’s specific requirements. Report output extraction can also be automated using report service.

Organisations can save a lot of cost and effort by automatically pulling BI reports and loading them to external systems as per business needs.

Oracle Fusion offers many such robust, scalable, and easy to plug-in features, however organisations must choose what suits them the most after careful consideration. At Fusion Practices, our team of domain experts help businesses to map their requirements strategically and build a solution that best serves their needs.

Below is a sample of a BI report created to get team leave details.


Report Path     : Custom/Human Capital Management/Interfaces /Leave Calendar/ Team Leave Calendar.xdo
Output format: XML
Parameter Name: From_Date ,To_Date

Fusion BI service can be leveraged to call BI report and get the output.

BI Webservices details:

1. WSDL :

2. Method : runReport ()

3. Authentication : In this case, we have taken JWT based authentication, however, it can also be basic, which simply needs user and password.

Header: Authorization

Value: Bearer eyJ4NXQiOiJsdsadvSnBCTlFKeUZuemg4UkY2N3V3cFk9IiwidHlwIjoiSldUIiwiYWxnIjoiUlMyNTYifQ.eyJpYXQiOjE1Mzk3ODU4NjEcscsYiI6IjExMTU1NSIsImlzcyI6IlVPVE1fU0VSVkVSX1VBVCIsImV4cCI6MTU0NDk2OTg2MSwicHJuIjoiMTExNTU1In0.lAd_kkIM78Kl7cdJd_18AbvUPbNW7TsD2JXkw2KXRLsX1jtvnyINx0wzEKGTJqP0AUNyBz70eqbQnGHGKZrEtFyysDmlGpEzwAuxyO_Kx2O01Pi6cCjEMyOcnNimKjMnTscsdchFD-ZEMM1lng4Q0Xz9lWPC9RqGDxqM5SIgXTbxnNUh4srft_M7XaI9f9NuFsH6K1x9AHKMLlWlBANauINh5d4eNAivno7gvNnr29iD3Fd4Nqz-zwCMZb73s9GJ66gYBuU5j9rhHwbNfhLLka7R-kYfA_11kyZGfLhwn5AcsdcYGPTnajC7JhKqzVn05ywrLZ0C9oH_iSqw1llWSg

 4. Input Payload

<soap:Envelope xmlns:soap=”” xmlns:pub=””>






               <!–Zero or more repetitions :–>




                     <!–Zero or more repetitions :–>







                     <!–Zero or more repetitions :–>





            <pub:reportAbsolutePath>Custom/Human Capital Management /Interfaces /Leave Calendar/Team Leave Calendar.xdo</pub:reportAbsolutePath>






5. Output : The output is always in decoded format ‘Base64’

<env:Envelope xmlns:env=””>



      <ns2:runReportResponse xmlns:ns2=””>




















            <ns2:reportFileID xsi:nil=”true” xmlns:xsi=””/>

            <ns2:reportLocale xsi:nil=”true” xmlns:xsi=””/>

            <ns2:metaDataList xsi:nil=”true” xmlns:xsi=””/>





6. Steps to decrypt the Output (Base64):


–Decoded Response

<?xml version=”1.0″ encoding=”UTF-8″?>

<!–Generated by Oracle BI Publisher -Dataengine, datamodel:_Custom_Human_Capital_Management_Interfaces_ _Leave_Calendar_DM1_xdm –>














Author : Roopesh Madan is a Principal Consultant at Fusion Practices.

Get in touch with us