Friday, July 16, 2021

Difference between FBDI, ADFDI and Web Services in Oracle Fusion

When it comes to Interfaces/Conversions and Integrations, Oracle ERP Cloud offers variety of options to be utilized based on business requirements. FBDI, ADFDI and Web Services are amongst the most commonly used ones.

Let's see how these are different from each other and what then can be used for.

File-Based Data Import (FBDI)

Application Development Framework Desktop Integration (ADFDI)

Web Services 

Recommended for bulk data conversions & feeds from external systems

Recommended for regular loads/updates based on manually compiled data

Standard way to integrate two web-based applications

Data file prepared offline - Not connected to cloud instance

Excel sheet connected to the instance - Similar to WebADI in EBS

Web based APIs that can be accessed by heterogeneous systems

Validation is done after full upload

Excel validation via list of values

Validation after making the web service call

Requires moderate technical expertise

Very user friendly

Highly technical

Extensive data preparation effort

Less effort in preparing excel data

Less effort in preparing data for desired tags in API calls

Very fast upload

Slower upload compared to FBDI

Considerably slower due to row-by-row operations

No plugins required

Works via desktop Excel plugin

Custom integration processes to invoke inbound/outbound SOAP/REST APIs

Bulk load via CSV files

Data upload directly from Excel

Custom integration processes to invoke inbound/outbound SOAP/REST APIs


Wednesday, July 7, 2021

SOAP Webservice to Run a BI Publisher Report in Oracle Fusion

What if we want to create a process in Oracle Fusion, similar to an outbound interface (in EBS) where we write complex queries and the program output is fed to an external system ?

Look no further ! Oracle has provided a webservice ExternalReportWSSService with 'runReport' operation which helps to run a report which is on BIP of Oracle ERP Cloud and retrieve the output in base64 format.

Webservice details -

Webservice - ExternalReportWSSService

Operation - runReport

Service WSDL URL: https://servername/xmlpserver/services/ExternalReportWSSService?WSDL

Below is the Sample payload for this Webservice -

Here, we need to mention the absolute path of the report and we can also pass all necessary parameters to the same.

Once successful, the output will be in Base64 format similar to following sample -

The triggering heterogeneous would be able to decode the Base64 output into plain text and consume the same for further processing.