Integrate with Oracle Fusion Financial Cloud
Oracle Integration Cloud (OIC) provides great connectivity between Oracle Financial Cloud (OFIN) and external applications, automating processes and reducing manual effort. Whether you need real-time event-driven triggers, API calls, or bulk uploads, OIC offers multiple integration approaches to suit different business requirements. In this post, I’ll explore some key integration methods to streamline your workflows with Oracle Financial Cloud. For the sake of simplicity we I’ll focus on invoicing. The image below shows some off the possibilities. SOAP services (1) and REST Services (2) can be invoked to work with OFIN Data. The links to tghe docs are in the image. Also a BI Report residing within OFIN can be invoked with SOAP (3), and from within OFIN business events (4) can be raised which then trigger an Integration.
Below you will find some additional info and use cases on how OIC can interact with OFIN.
API-Based Integration: Retrieve Invoice Data On-Demand
Oracle Financial Cloud exposes REST APIs, allowing OIC to retrieve invoice details dynamically and trigger real-time actions.
Example Use Case
A custom ERP application needs to fetch invoice information when requested.
How It Works
- Call the REST API:
GET https://<fusionhost>/fscmRestApi/resources/11.13.18.05/invoices/{invoiceId}
- Map the API response within OIC to process or display data.
- Transform and route the response to the ERP application.
Why Use This?
✔ Real-time data retrieval – Fetch invoices as needed.
✔ Flexible and customizable – Integrate with multiple systems.
File-Based Data Import (FBDI): Bulk Invoice Processing
For large-scale invoice processing, Oracle Financial Cloud supports File-Based Data Import (FBDI). OIC automates the creation and submission of these batch files. Note, this option was not displayed in the image above.
Example Use Case
Upload multiple invoices from a legacy system into Oracle Financial Cloud.
How It Works
- Generate the FBDI CSV file in OIC.
- Upload the file using the ERP Cloud Adapter.
- Trigger the import job and monitor its execution.
Example CSV for invoice import:
csvCopyEditInvoiceNumber,CustomerName,Amount,Currency,DueDate
INV12345,ABC Corp,2000,USD,2025-02-01
INV12346,XYZ Inc,1500,USD,2025-02-02
Why Use This?
✔ Handles large volumes – Process hundreds of invoices at once.
✔ Ideal for migrations – Move historical data efficiently.
Event-Driven Integration: Automate Invoice Processing
Oracle Financial Cloud generates business events, such as ReceivablesInvoiceCompleted, which OIC can capture to trigger automated workflows.
Example Use Case
When an invoice is completed, OIC automatically:
- Sends an email notification to stakeholders.
- Share the invoice details in a DMS.
- Triggers further processing in other applications.
How It Works
- Subscribe to the ReceivablesInvoiceCompleted event using the ERP Cloud Adapter in OIC.
- Map event data to various actions like notifications and database updates.
- Deploy the integration to automate real-time responses.
Why Use This?
✔ Real-time processing – Immediate action on invoice events.
✔ Automated workflows – No manual intervention needed.
Pre-Built Adapters: Simplify Integration with Oracle ERP Cloud
OIC’s ERP Cloud Adapter provides out-of-the-box integration with Oracle Financial Cloud, eliminating the need for complex API calls or file handling.
Example Use Case
Automatically create invoices in Oracle Financial Cloud when an order is finalized in a CRM.
How It Works
- Configure the ERP Cloud Adapter to execute the Create Invoice operation.
- Map the source system fields to Oracle Financial Cloud.
- Deploy and test the integration.
Example payload for invoice creation:
jsonCopyEdit{
"InvoiceNumber": "INV12347",
"CustomerName": "DEF Ltd.",
"Amount": 500,
"Currency": "USD",
"DueDate": "2025-02-10"
}
Why Use This?
✔ No custom coding – Simplifies complex integrations.
✔ Faster deployment – Pre-built connectivity to Oracle ERP.
Hybrid Approach: Combining Multiple Integration Methods
For complex business requirements, you can combine multiple integration methods to ensure flexibility and scalability.
Example Use Case
A company wants to handle invoice automation with a mix of real-time and batch processing:
- Trigger an event when an invoice is completed.
- Fetch additional details using the REST API.
- Notify and update additional systems.
Why Use This?
✔ End-to-end automation – Handles all invoice scenarios.
✔ Maximum efficiency – Combines real-time and bulk processing.
Troubleshoot Fusion Business events
When using Oracle Financial Cloud business event to trigger integrations, one of the common issues is, that after going through the steps that are supposed to generate the Business Event on Fusion Apps, the integration instance in OIC is not created. This could happen if there are errors when Fusion tries to deliver message to OIC Server, or the event was not created at all on the Fusion Apps server.
There are a couple of APIs that can be used to troubleshoot these issues. Best way to run these API’s is Postman.
To confirm if the Business Event is enabled:
GET http://<fusionhost>:<port>/fscmRestApi/resources/latest/erpBusinessEvents
To confirm if the Business Event is generated.
GET http://<fusionhost>:<port>/soa-infra/PublicEvent/diagnostic/successfulEventsCount?lastHours=24
To confirm if there were any failures in sending the Business Event to OIC
GET http://<fusionhost>:<port>/soa-infra/PublicEvent/diagnostic/failedEventsDetail?lastHours=24
Conclusion
Oracle Integration Cloud provides multiple ways to integrate with Oracle Financial Cloud for invoicing, from real-time event triggers to batch uploads. Choosing the right approach depends on your business needs—whether you require instant updates, bulk processing, or a hybrid solution.
Which integration method works best for you? Let me know in the comments!
Rescouces:
Troubleshoot Fusion Business Events : https://blogs.oracle.com/fusionmiddlewaresupport/post/how-to-confirm-if-a-fusion-apps-business-event-was-released-to-oic