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

Read More

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.

Read More