{"id":3369,"date":"2025-04-14T09:02:11","date_gmt":"2025-04-14T09:02:11","guid":{"rendered":"https:\/\/www.bohort.nl\/?p=3369"},"modified":"2025-04-14T09:02:11","modified_gmt":"2025-04-14T09:02:11","slug":"oracle-integration-cloud-series-1","status":"publish","type":"post","link":"https:\/\/www.bohort.nl\/en\/2025\/04\/14\/oracle-integration-cloud-series-1\/","title":{"rendered":"Oracle Integration Cloud Series \u2013 1"},"content":{"rendered":"<h2 class=\"wp-block-heading has-text-align-center\">Integrate with Oracle Fusion Financial Cloud<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">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\u2019ll explore some key integration methods to streamline your workflows with Oracle Financial Cloud. For the sake of simplicity we I&#8217;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.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-1024x422.png\" alt=\"\" class=\"wp-image-3373\" srcset=\"https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-1024x422.png 1024w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-300x124.png 300w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-768x316.png 768w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-1536x632.png 1536w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image-18x7.png 18w, https:\/\/www.bohort.nl\/wp-content\/uploads\/2025\/02\/image.png 1666w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Below you will find some additional info and use cases on how OIC can interact with OFIN. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>API-Based Integration: Retrieve Invoice Data On-Demand<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Financial Cloud exposes <strong>REST APIs<\/strong>, allowing OIC to retrieve invoice details dynamically and trigger real-time actions.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example Use Case<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A custom ERP application needs to fetch invoice information when requested.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How It Works<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Call the REST API<\/strong>: \n<ul class=\"wp-block-list\">\n<li><code>GET https:\/\/&lt;fusionhost&gt;\/fscmRestApi\/resources\/11.13.18.05\/invoices\/{invoiceId}<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Map<\/strong> the API response within OIC to process or display data.<\/li>\n\n\n\n<li><strong>Transform and route<\/strong> the response to the ERP application.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why Use This?<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u2714 <strong>Real-time data retrieval<\/strong> \u2013 Fetch invoices as needed.<br>\u2714 <strong>Flexible and customizable<\/strong> \u2013 Integrate with multiple systems.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>File-Based Data Import (FBDI): Bulk Invoice Processing<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For large-scale invoice processing, Oracle Financial Cloud supports <strong>File-Based Data Import (FBDI)<\/strong>. OIC automates the creation and submission of these batch files. Note, this option was not displayed in the image above. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example Use Case<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Upload multiple invoices from a legacy system into Oracle Financial Cloud.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How It Works<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Generate the FBDI CSV file<\/strong> in OIC.<\/li>\n\n\n\n<li><strong>Upload the file<\/strong> using the <strong>ERP Cloud Adapter<\/strong>.<\/li>\n\n\n\n<li><strong>Trigger the import job<\/strong> and monitor its execution.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Example CSV for invoice import:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">csvCopyEdit<code>InvoiceNumber,CustomerName,Amount,Currency,DueDate  \nINV12345,ABC Corp,2000,USD,2025-02-01  \nINV12346,XYZ Inc,1500,USD,2025-02-02  \n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why Use This?<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u2714 <strong>Handles large volumes<\/strong> \u2013 Process hundreds of invoices at once.<br>\u2714 <strong>Ideal for migrations<\/strong> \u2013 Move historical data efficiently.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Event-Driven Integration: Automate Invoice Processing<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Financial Cloud generates business events, such as <strong>ReceivablesInvoiceCompleted<\/strong>, which OIC can capture to trigger automated workflows.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example Use Case<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">When an invoice is completed, OIC automatically:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sends an email notification to stakeholders.<\/li>\n\n\n\n<li>Share the invoice details in a DMS.<\/li>\n\n\n\n<li>Triggers further processing in other applications.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How It Works<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Subscribe<\/strong> to the <strong>ReceivablesInvoiceCompleted<\/strong> event using the ERP Cloud Adapter in OIC.<\/li>\n\n\n\n<li><strong>Map<\/strong> event data to various actions like notifications and database updates.<\/li>\n\n\n\n<li><strong>Deploy<\/strong> the integration to automate real-time responses.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why Use This?<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u2714 <strong>Real-time processing<\/strong> \u2013 Immediate action on invoice events.<br>\u2714 <strong>Automated workflows<\/strong> \u2013 No manual intervention needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Pre-Built Adapters: Simplify Integration with Oracle ERP Cloud<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">OIC\u2019s <strong>ERP Cloud Adapter<\/strong> provides out-of-the-box integration with Oracle Financial Cloud, eliminating the need for complex API calls or file handling.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example Use Case<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Automatically create invoices in Oracle Financial Cloud when an order is finalized in a CRM.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>How It Works<\/strong><\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Configure the ERP Cloud Adapter<\/strong> to execute the <strong>Create Invoice<\/strong> operation.<\/li>\n\n\n\n<li><strong>Map<\/strong> the source system fields to Oracle Financial Cloud.<\/li>\n\n\n\n<li><strong>Deploy<\/strong> and test the integration.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Example payload for invoice creation:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">jsonCopyEdit<code>{\n   \"InvoiceNumber\": \"INV12347\",\n   \"CustomerName\": \"DEF Ltd.\",\n   \"Amount\": 500,\n   \"Currency\": \"USD\",\n   \"DueDate\": \"2025-02-10\"\n}\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why Use This?<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u2714 <strong>No custom coding<\/strong> \u2013 Simplifies complex integrations.<br>\u2714 <strong>Faster deployment<\/strong> \u2013 Pre-built connectivity to Oracle ERP.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Hybrid Approach: Combining Multiple Integration Methods<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For complex business requirements, you can <strong>combine multiple integration methods<\/strong> to ensure flexibility and scalability.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example Use Case<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">A company wants to handle invoice automation with a mix of real-time and batch processing:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Trigger an event<\/strong> when an invoice is completed.<\/li>\n\n\n\n<li><strong>Fetch additional details<\/strong> using the REST API.<\/li>\n\n\n\n<li><strong>Notify and update additional systems<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Why Use This?<\/strong><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u2714 <strong>End-to-end automation<\/strong> \u2013 Handles all invoice scenarios.<br>\u2714 <strong>Maximum efficiency<\/strong> \u2013 Combines real-time and bulk processing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Troubleshoot Fusion Business events <\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">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. &nbsp;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.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are a couple of APIs that can be used to troubleshoot these issues. Best way to run these API&#8217;s is Postman. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To confirm if the Business Event is enabled:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>GET&nbsp;<\/strong>http:\/\/&lt;fusionhost&gt;:&lt;port&gt;\/fscmRestApi\/resources\/latest\/erpBusinessEvents<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To confirm if the Business Event is generated.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>GET&nbsp;<\/strong>http:\/\/&lt;fusionhost&gt;:&lt;port&gt;\/soa-infra\/PublicEvent\/diagnostic\/successfulEventsCount?lastHours=24<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To confirm if there were any failures in sending the Business Event to OIC<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>GET<\/strong>&nbsp;http:\/\/&lt;fusionhost&gt;:&lt;port&gt;\/soa-infra\/PublicEvent\/diagnostic\/failedEventsDetail?lastHours=24<\/code><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Conclusion<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Integration Cloud provides multiple ways to integrate with Oracle Financial Cloud for invoicing, from <strong>real-time event triggers<\/strong> to <strong>batch uploads<\/strong>. Choosing the right approach depends on your business needs\u2014whether you require instant updates, bulk processing, or a hybrid solution.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Which integration method works best for you? Let me know in the comments!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rescouces:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Troubleshoot Fusion Business Events : <a href=\"https:\/\/blogs.oracle.com\/fusionmiddlewaresupport\/post\/how-to-confirm-if-a-fusion-apps-business-event-was-released-to-oic\">https:\/\/blogs.oracle.com\/fusionmiddlewaresupport\/post\/how-to-confirm-if-a-fusion-apps-business-event-was-released-to-oic<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>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&#8230;<\/p>","protected":false},"author":1,"featured_media":3373,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[101,110],"tags":[4,111,5,102,112,103],"class_list":["post-3369","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oic","category-oracle-fusion","tag-bohort","tag-fusion","tag-luc-bors","tag-oic","tag-oracle-fusion-financial-cloud","tag-oracle-integration-cloud"],"_links":{"self":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/comments?post=3369"}],"version-history":[{"count":11,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3369\/revisions"}],"predecessor-version":[{"id":3414,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/posts\/3369\/revisions\/3414"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/media\/3373"}],"wp:attachment":[{"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/media?parent=3369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/categories?post=3369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bohort.nl\/en\/wp-json\/wp\/v2\/tags?post=3369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}