<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by SumanthKoditala on Medium]]></title>
        <description><![CDATA[Stories by SumanthKoditala on Medium]]></description>
        <link>https://medium.com/@sumanthkoditala?source=rss-93463fbc19f3------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*gLCdlO1qZ9_gTiTBF9i1bg.jpeg</url>
            <title>Stories by SumanthKoditala on Medium</title>
            <link>https://medium.com/@sumanthkoditala?source=rss-93463fbc19f3------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 15:07:04 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sumanthkoditala/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Invoking Oracle Fusion BI Publisher Reports from Oracle Integration Cloud (OIC Gen3)]]></title>
            <link>https://sumanthkoditala.medium.com/invoking-oracle-fusion-bi-publisher-reports-from-oracle-integration-cloud-oic-gen3-33f9fdd5eb15?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/33f9fdd5eb15</guid>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[oracle-fusion]]></category>
            <category><![CDATA[oracle-bi-publisher]]></category>
            <category><![CDATA[oracle-fusion-technical]]></category>
            <category><![CDATA[oicgen3]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Thu, 23 Jul 2026 19:12:42 GMT</pubDate>
            <atom:updated>2026-07-23T19:12:42.752Z</atom:updated>
            <content:encoded><![CDATA[<p>Synchronous and Asynchronous Approaches</p><h4>Overview</h4><p>Oracle Fusion BI Publisher is one of the convenient ways to extract data from Oracle Fusion. It enables developers to write anything from simple to complex SQL queries and generate reports in formats such as CSV and XML, both of which can be easily consumed and parsed within OIC.</p><p>In this article, we’ll compare the different approaches available to invoke <strong>BI Publisher reports</strong> from OIC Gen3, including both synchronous and asynchronous execution models. We’ll then take a detailed look at implementing the asynchronous callback-based approach, which is particularly useful for long-running report execution.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U3tAwB0v6x34dp_JK36OA.png" /></figure><h4>Different ways to invoke BI Publisher reports</h4><p>BI Publisher reports can be invoked from OIC using either synchronous or asynchronous approaches, depending on the integration requirements.</p><blockquote><strong>Synchronous Approach</strong></blockquote><p>Oracle Fusion Applications provides SOAP web services to execute BI Publisher reports <strong>synchronously </strong>and retrieve the report output immediately. Two types of services are available:</p><p><strong>Public Services</strong> — Credentials are passed in the SOAP request body.</p><p><strong>Protected Services</strong> — Credentials are passed in the SOAP header. Oracle <strong>recommends </strong>using these services for synchronous BI Publisher report execution.</p><p>· <strong><em>ExternalReportWSSService</em></strong>: runReport method</p><p>xmlpserver/services/ExternalReportWSSService?wsdl</p><p>· <strong><em>ScheduleReportWSSService</em></strong>: getDocumentData method</p><p>xmlpserver/services/ScheduleReportWSSService?wsdl</p><blockquote><strong>Asynchronous Approach</strong></blockquote><p>For long-running or large BI Publisher reports, Oracle recommends using an asynchronous approach instead of synchronous execution to avoid latency and payload size limitations.</p><p>One recommended approach is to create a custom ESS job to execute the BI Publisher report and invoke it using the ERP Integration Service <strong>exportBulkData </strong>operation with <strong>EnableEvent=Y</strong>. Once the report execution completes, Oracle Fusion publishes the ErpExportBulkDataEvent callback, which provides the <strong>documentId </strong>required to retrieve the report output from UCM.</p><h4>Configuration &amp; setup for asynchronous callback</h4><ol><li>Create a BIP Report</li></ol><p>I created a data model using a sample AP Invoice SQL query and then created a report based on that data model.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/921/1*_xiu23loywa7hiBEn6zLeA.png" /></figure><p>Note down the report path by clicking on Schedule option on report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/1*TTQ-pHr2WpHOev4T9w2-Tg.png" /></figure><p>2. Create custom ESS job</p><p>Navigation: Setup and Maintenance -&gt; Search -&gt; Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications -&gt; Click on + icon</p><p>Provide the details shown in the image below and save the changes.</p><p>Notice Job Type is <strong>BIPJobType, </strong>also provide BIP Report path which we obtained in setp 1 into <strong>ReportID </strong>field.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*u96aoVRLecWlkGIpWHnWKQ.png" /></figure><p>Note down the Name and Path, as they are required when invoking the ESS job from the OIC integration.</p><p>3. Create an OIC integration trigger</p><p>Created the following OIC integration to invoke the custom ESS job created above.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NbwVhXRiezuHRGDcNz3yFg.png" /></figure><p>Here we need to configure ERP adapter invocation with <strong>ErpIntegrationService </strong>and operation needs to be <strong>exportBulkData.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/347/1*rF_-_xXUvGqMvI9jL-Wn2A.png" /></figure><p><strong>Note</strong>: The ERP Integration Service also provides the <strong>submitESSJobRequest </strong>operation to run ESS jobs. However, during my testing, I observed that only <strong>exportBulkData </strong>generated the callback event. <em>This is because Oracle ERP</em> Cloud publishes callback events only for the events available through the Event Catalog API, where the <strong>ErpExportBulkDataEvent </strong>event is exposed. <strong>Catalog API</strong>: GET /soa-infra/PublicEvent/catalog</p><p>Also, provide the following mappings for this invocation:</p><ul><li><strong>jobName:</strong> Prefix ‘/oracle/apps/ess/custom’ to the <strong>Path</strong> from Step 2 and append the <strong>Name</strong>, as shown below.</li><li><strong>jobOptions:</strong> EnableEvent=Y (required for callback)</li><li><strong>notificationCode:</strong> 30</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*G0eoAw9MmTalY1oywFiK0Q.png" /></figure><p>4. Create an OIC integration for callback</p><p>Created the following OIC integration to receive the callback and then download the ZIP file from UCM using the documentId received in the callback payload.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5s7QIir5upWGKYMm8swzUg.png" /></figure><p>The callback is triggered once the BIP report completes execution and writes the report output to UCM.</p><p>Configure the integration Trigger with ERP Cloud adapter connection and select <strong>ERP Integration Outboud event </strong>under <strong>Receive Business Events raised within ERP Cloud </strong>purpose. Also, provide the following filter query.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/510/1*Poqv7cW4wju9qK7GDeNe1w.png" /></figure><p>Filter Expression</p><pre>&lt;xpathExpr xmlns:ns_0=&#39;http://xmlns.oracle.com/apps/financials/commonModules/shared&#39;&gt;$inputVariable/ns_0:JOBS/ns_0:JOBNAME=&#39;Custom AP Invoice BIP ESS Job SK&#39; &lt;/xpathExpr&gt;</pre><p>To download the ZIP file from UCM, I have configured the getDocumentForDocumentId operation under the ErpIntegrationService and passed the documentId received in the callback payload.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/457/1*wm4X6UeatZzYm5GpQS_RRQ.png" /></figure><p>For this blog, the file reference received in the Content field from this invocation is passed to the Notification action.</p><p>5. Execution</p><p>Upon running the OIC trigger integration, the custom ESS job is invoked. Once the job execution completes, the callback is received by the OIC callback integration.</p><p>Custom ESS Job executed</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/992/1*Eg-lVz2ZrqbPgUZTnkkxSQ.png" /></figure><p>Received OIC Callback</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/734/1*-j1fzHwTHCdop-KvpWWPhQ.png" /></figure><p>zip file includes ESS job log file, report output files in csv and xml format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/355/1*zBkb6GPCWDPWghmFK7DQYg.png" /></figure><h4>Things to Note</h4><p>Below are some observations from my implementation:</p><p>1.We can verify whether the OIC callback integration is registered successfully by checking the entry in the Oracle Fusion Subscription API.</p><p><strong>Subscription API</strong>: GET /soa-infra/PublicEvent/subscriptions</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AT0lY5_6oqTejrBvwS3_ww.png" /></figure><p>2.Whenever a new event is generated, Oracle Fusion checks the event name, filter, and state is true. Only then it invokes the OIC integration. So, if callbacks are not received, check the event subscriptions first.</p><p>3. When a BI Publisher report is invoked <strong>synchronously</strong>, the report output is returned as a <strong>Base64-encoded</strong> string in the SOAP response. And the synchronous services <strong>do not</strong> support attachments, so enabling <strong>MTOM </strong>in the SOAP Adapter has <strong>no effect</strong>.</p><p>4.No additional configurations are required for publishing the BIP report output to UCM server.</p><p>5.<strong>Design Consideration</strong>: If the requirement involves retrieving a small amount of data using one or two Fusion REST API calls, invoking the REST APIs directly is often the simpler approach, because it avoids the effort of creating and maintaining a BI Publisher data model and report. However, when data needs to be consolidated from multiple Fusion objects, implementing the solution through numerous REST API calls can increase integration complexity, error handling, and monitoring effort. In such scenarios, BI Publisher can provide a cleaner and more maintainable solution.</p><h4>Conclusion</h4><p>Oracle Fusion provides multiple ways to invoke BI Publisher reports. Depending on the report execution time and output file size, you can choose either the synchronous or asynchronous approach. For asynchronous execution, the exportBulkData operation can be used to receive a callback once the report completes.</p><h4>References</h4><ul><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/erp-adapter/business-event-issues.html#GUID-56072A39-3D7C-44D9-9178-C87170E6B7A5">Using the Oracle ERP Cloud Adapter with Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/erp-adapter/trigger-request-page.html#GUID-0EEEF200-64AE-470C-86AC-063BCC72D3ED">Using the Oracle ERP Cloud Adapter with Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en/cloud/saas/financials/25c/oeswf/erpintegrationservice-d16510e420.html#Relationships">SOAP Web Services for Financials</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/soap-adapter/call-oracle-fusion-applications-business-intelligence-publisher-report-services.html">Using the SOAP Adapter with Oracle Integration 3</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=33f9fdd5eb15" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Configuring Customer Tenancy Method for Email Notifications in Oracle Integration Cloud- OIC Gen3]]></title>
            <link>https://sumanthkoditala.medium.com/configuring-customer-tenancy-method-for-email-notifications-in-oracle-integration-cloud-oic-gen3-bdff4f9e244f?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/bdff4f9e244f</guid>
            <category><![CDATA[oic]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[oci-email-delivery]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Fri, 17 Jul 2026 06:56:40 GMT</pubDate>
            <atom:updated>2026-07-17T06:56:40.224Z</atom:updated>
            <content:encoded><![CDATA[<p>Setup, Considerations and Limitations</p><h4>Overview</h4><p>Oracle Integration provides two options for sending outbound email notifications: the <strong>Default Method</strong> and the <strong>Customer Tenancy Method</strong>. Oracle recommends using the <strong>Customer Tenancy Method,</strong> however, both options have their own benefits and limitations depending on your organization’s requirements. In this blog, I focus on the Customer Tenancy Method, highlighting its advantages and walking through the configuration steps required to set it up.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U3tAwB0v6x34dp_JK36OA.png" /></figure><h4><strong>Choosing Between the Customer Tenancy Method and the Default Method</strong></h4><p>The choice between the <strong>Customer Tenancy Method</strong> and the <strong>Default Method</strong> depends on your organization’s email notification requirements.</p><p>The<strong> </strong>Default Method is an out-of-the-box option that is simple to configure and works well for organizations with moderate email notification needs. It allows you to manage approved senders and the suppression list directly from the <strong>Notifications</strong> page in Oracle Integration. However, it has certain limitations, including a maximum attachment size of <strong>2 MB</strong> and a limit of <strong>10,000 email units</strong> within a rolling 24-hour period.</p><p>The Customer Tenancy Method is better suited for organizations with higher email notification requirements. It supports sending more than <strong>10,000 email units</strong> in a rolling 24-hour period and allows attachments larger than <strong>2 MB</strong>. It also provides better control over the suppression list and sent email management through Oracle Cloud Infrastructure (OCI). However, it requires additional setup, including SMTP configuration in OCI and email domain configuration.</p><p>If your integrations send notification emails for success or error scenarios to a large number of recipients, the Customer Tenancy Method is generally the better choice. Keep in mind that Oracle counts email usage in email units. Each recipient counts as one email unit, and for attachments larger than <strong>2 MB</strong>, every additional 2 MB is counted as another email unit. For example, sending a <strong>10 MB</strong> attachment to <strong>5 recipients</strong> consumes <strong>25 email units</strong> ((10 ÷ 2) × 5).</p><h4>Configuring the <strong>Customer Tenancy Method</strong></h4><ol><li><strong><em>Generate SMTP Credentials</em></strong></li></ol><p>I have generated the SMTP credentials with admin user.</p><p>Navigate through Profile Menu -&gt; User settings -&gt; Scroll down to <strong>SMTP credentials</strong></p><p>Click <strong>Generate Credentials</strong> under the <strong>SMTP Credentials</strong> section, then immediately copy and save the generated username and password before closing the dialog box. Once the dialog box is closed, these credentials cannot be retrieved again.</p><p><em>Included the oracle documentation in reference section for steps to create SMTP credentials for other users if you are administrator.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/963/1*7sAUCNhdHgyGntdkHN8S2A.png" /></figure><p><strong><em>2. Create an email domain</em></strong></p><p>Navigate to <strong>Email Delivery</strong> service under <strong>Developer Services</strong> section in OCI console and click on <strong>Email Domains</strong></p><p>For this blog purpose, I have created “gmail.com” domain.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*S75dhMTK3cO2sVIjdJ0MHw.png" /></figure><p>Notice that DKIM Signing is “Inactive”.</p><blockquote>For enterprise environments, it is recommended to configure both <strong>SPF</strong> and <strong>DKIM</strong> for your email domain. These email authentication mechanisms help verify the authenticity of outbound emails, improve email deliverability, and reduce the risk of emails being marked as spam or spoofed. I am not covering the configuration of SPF and DKIM in this blog, as they are managed at the domain level. However, the <a href="https://blogs.oracle.com/cloud-infrastructure/step-by-step-instructions-to-send-email-with-oci-email-delivery"><strong>attached blog</strong></a> provides a detailed, step-by-step guide for configuring both SPF and DKIM.</blockquote><p><strong><em>3. Create an Approved Sender</em></strong></p><p>I have provided a gmail address</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*0Y6VZUJSEtgOoGUzgS-rOA.png" /></figure><p><strong><em>4. Configure the SMTP details in OIC and Test the connection</em></strong></p><p>Navigation : Oracle Integration -&gt; Settings -&gt; Notifications -&gt; SMTP configuration</p><p>Now enable “Use my SMTP configuration” and provide SMTP username and password which we have generated in <strong>Step 1</strong>. Once adding the required details Click “Test” button to test the configuration is successful.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*KD5t-P5HgDGnUaFjCWkXlA.png" /></figure><p><strong><em>5. Sending a test email</em></strong></p><p>Once the SMTP configuration is complete, the Notification action in Oracle Integration starts sending emails through the OCI Email Delivery service.</p><p><strong>Note</strong>: No additional changes are required in OIC notification action.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/966/1*Rdxq7nMc74GgGi0e3Mvrrw.png" /></figure><p>You can check the delivery status in Deliverability Dashboard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*V_8xHEboHShcryOZRxj2KQ.png" /></figure><h4><strong>Things to Note</strong></h4><p>By default, OCI Email Delivery supports emails up to <strong>2 MB</strong> (including the message body, headers, and attachments), and every 2 MB is counted as one email unit toward your daily sending limits. Based on your requirements, you can open a service request and request an increase in the maximum message size (up to <strong>60 MB</strong>) and email sending limits. However, configuring <strong>SPF</strong> and <strong>DKIM</strong> for your sending domain and approved sender is a prerequisite for requesting these limit increases.</p><h4>Conclusion</h4><p>The Customer Tenancy Method requires a few additional configuration steps compared to the Default Method, but it is a valuable option for organizations with higher email notification requirements or those that need greater control over email delivery. By leveraging OCI Email Delivery, customers can overcome the limitations of the default method while managing outbound notification emails through their own tenancy.</p><h4>References</h4><ul><li><a href="https://docs.oracle.com/en-us/iaas/Content/Email/Reference/gettingstarted_topic-create-smtp-credentials.htm">Creating SMTP Credentials</a></li><li><a href="https://blogs.oracle.com/cloud-infrastructure/step-by-step-instructions-to-send-email-with-oci-email-delivery">Step-by-step instructions to send email with OCI Email Delivery</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/configure-notification-emails.html#GUID-0C7843FC-9933-458A-8DF9-F73C0AE83765">Using Integrations in Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en-us/iaas/Content/Email/Concepts/overview.htm#Service">Overview of Email Delivery</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bdff4f9e244f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using Tracking Variables Effectively in Oracle Integration Cloud Gen3]]></title>
            <link>https://sumanthkoditala.medium.com/using-tracking-variables-effectively-in-oracle-integration-cloud-gen3-e5029211bb38?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/e5029211bb38</guid>
            <category><![CDATA[oracle-integration]]></category>
            <category><![CDATA[oic]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Fri, 10 Jul 2026 12:12:19 GMT</pubDate>
            <atom:updated>2026-07-10T12:12:19.887Z</atom:updated>
            <content:encoded><![CDATA[<h4>Tips &amp; Tricks for updating and searching tracking variables</h4><p>In this post, we’ll look at how to populate tracking variables within integration flows and explore the different ways to use them when searching for integration instances in the Gen3 monitoring experience.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U3tAwB0v6x34dp_JK36OA.png" /></figure><p>Business identifiers play a key role in any OIC environment, making it much easier to monitor integration instances and troubleshoot issues in production. They become even more valuable when your environment doesn’t use persistent audit logging, such as ATP, where quickly locating the right integration instance is often the first step in debugging.</p><p>Generally, we configure business identifiers in the <strong>Business Identifiers</strong> section of an integration. While configuring them, the values can only be selected from the trigger variables.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*GBCN1I4_pT9wp3iZpHMfzQ.png" /></figure><p>However, in many scenarios, the actual key values are generated only after the integration starts executing. For example, a key value may be returned from an external REST API or retrieved from a database. To handle such scenarios, Oracle Integration provides a way to update the tracking variables from within the integration flow.</p><h4>Updating tracking variables</h4><p>Out of the three tracking variables, only the second and third tracking variables can be updated using the <strong>Assign</strong> action, as shown below. The first tracking variable is considered the primary tracking variable and cannot be updated within the integration flow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/819/1*XnEjklagOefz5FpPHFjErg.png" /></figure><p>Since we are updating the tracking variable values using the <strong>Assign</strong> action, it is a good practice to <strong>rename </strong>the tracking variables in the <strong>Business Identifiers</strong> section, as shown below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*CSx-GMLWDao91xICnlMYkg.png" /></figure><h4>Searching tracking variables</h4><p><strong><em>Simple Search</em></strong></p><p>This search works similar to a web browser search, where each word in the search string is treated as a separate value.</p><p>In the example below, when searching for “<strong>US1 Business Unit”</strong>, Oracle Integration treats <strong>US1</strong>, <strong>Business</strong>, and <strong>Unit</strong> as individual search terms and returns all integration instances that contain any of these values.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YFcmtpJ2UFQ78H-qB8uUTQ.png" /></figure><p><strong><em>Phrase Match Search</em></strong></p><p>This search is useful when the search string contains special characters or when you know the exact phrase in your identifier but you are not sure whether it is prefixed or suffixed with other values.</p><p>To perform a phrase match search, enclose the search string in double quotes Ex: <strong>“Australia Business”</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ugvycFkW-C-QtEwbgLj13g.png" /></figure><p><strong><em>Exact Match Search</em></strong></p><p>If you know the exact identifier value, enclose the search string in square brackets. For example, use <strong>[US1 Business Unit]</strong> to return only the integration instances whose identifiers <strong>exactly </strong>match the specified value.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qcaYMg_ZcqYwWemMITxb7A.png" /></figure><blockquote><strong><em>Things to Keep in Mind</em></strong></blockquote><ol><li>Partial word searches are not supported.</li></ol><p>For the examples I am following above, if we search with word ‘US’ instead of ‘US1’, no results will be returned.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nFvWMIGjRoPGsL5xSt1Iyw.png" /></figure><p>2. Underscores are <strong>not</strong> considered as word separators.</p><p>For example word <strong>INV_SK_0808_06 </strong>is considered as one complete word, and searching with <strong>INV_SK </strong>will not return any results.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5S_mAm_OUbSS7AyXTUS5tw.png" /></figure><p>Searching complete word <strong>INV_SK_0808_06 </strong>will return the result as below</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*POs8kwcHkhUpP5Y_olDrlA.png" /></figure><p>3. Searching only primary business identifier values</p><p>Search the primary identifier value using <em>primary: value or Primary: value</em>. Ex: <strong>primary: Australia</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iuNw2ufdsdd9Ah6fPueWbQ.png" /></figure><p>Without <strong>primary </strong>key word, the search will be done across primary and secondary identifiers as shown below.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*thlrC6DbclGQ40UXgFiCJw.png" /></figure><h4>Conclusion</h4><p>Although configuring and searching business identifiers is simple, using them effectively can make a significant difference when monitoring integrations and troubleshooting issues in production environments.</p><h4><strong>References</strong></h4><ul><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/assign-business-identifiers-tracking-fields-messages.html#GUID-F54D8654-15FE-4CC6-A14D-258FD7AE487D">Using Integrations in Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/search-business-identifiers.html#GUID-0CBC8D49-A68F-453C-90E2-A2412403B6D5">Using Integrations in Oracle Integration 3</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e5029211bb38" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Building an OIC Scheduler Operations MCP Server and Consuming It in Langflow]]></title>
            <link>https://sumanthkoditala.medium.com/building-an-oic-scheduler-operations-mcp-server-and-consuming-it-in-langflow-08c2242b11dc?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/08c2242b11dc</guid>
            <category><![CDATA[ai-agent]]></category>
            <category><![CDATA[langflow]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[mcps]]></category>
            <category><![CDATA[model-context-protocol]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Fri, 03 Jul 2026 19:04:37 GMT</pubDate>
            <atom:updated>2026-07-03T19:14:16.502Z</atom:updated>
            <content:encoded><![CDATA[<h3>Overview</h3><p>In this blog, I’ll show how to build a scheduler utility project, which I’ll refer to as the <strong>Scheduler Operations</strong> project. I’ll then expose this project as an MCP Server and consume it from an AI Agent built using Langflow.</p><p>I’ll start by explaining the Scheduler Operations project, the utility integrations it contains, the integration pattern used, and how each integration is exposed as an MCP tool. I’ll then walk through the steps to configure the MCP Server in OIC and consume it from Langflow.</p><p>Finally, I’ll demonstrate how the AI Agent can retrieve scheduler statuses and perform start, stop, pause, and resume operations across OIC projects using natural language.</p><p>The following architecture illustrates the overall flow, where Langflow acts as the MCP client, discovers the tools exposed by the OIC MCP Server, invokes the appropriate scheduler operation, and presents the response back to the user.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jGK14uJJSLHkwQgD7YjB3Q.png" /></figure><h3>Building the Scheduler Operations Project</h3><p>To simplify scheduler management, I created a dedicated OIC project called <strong>Scheduler Operations</strong>. This project contains a collection of utility integrations responsible for different scheduler-related operations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hTYfoR-3AyWJVjrAKBdLDQ.png" /></figure><p>This Scheduler Operations project consists of utility integrations like retrieving the list of available projects, fetching scheduler statuses, and performing start, stop, pause, and resume operations on scheduled integrations. Each integration has a single responsibility and is exposed as an individual MCP tool, this will allow any AI agent to invoke only the required operation based on the user’s request.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uEPZPRjFBxWN49CqHoWuAg.png" /></figure><p>Now, this project acts as a common utility layer for scheduler-related operations and is later exposed as an MCP Server so that external AI applications can discover and invoke the available tools.</p><h4>Common Integration Pattern</h4><p>Although each integration performs a different scheduler operation, they all follow the same implementation pattern.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I0CSZ93nMnc4Ri7dMNcg9Q.png" /></figure><p>Each integration performs the following steps:</p><ol><li>Receive the project_id from the AI Agent.</li><li>Using the OIC developer API, pull all the integrations whose schedulers are defined.</li></ol><p><em>Ex: GET /ic/api/integration/v1/projects/{projectId}/integrations with query param as q = {status : ‘ACTIVATED’, style : ‘freeform_scheduled’}, and ofcourse the instancename</em></p><p>3. Loop through each integration and perform either start/stop/pause/resume/status etc</p><p><em>Ex: POST /ic/api/integration/v1/projects/{projectId}/integrations/{integrationId}/schedule/stop</em></p><p><strong>Note</strong>: For get all projects integration, which retrieves the list of available projects in the environment, only one developer API call is used.</p><p><em>GET /ic/api/integration/v1/projects</em></p><h4><strong>Creating Agentic AI tools from the integrations</strong></h4><p>Once the utility integrations are complete. Each integration is registered as an MCP tool with an appropriate name and description, allowing external AI applications to discover and invoke the available operations dynamically.</p><p>Each tool description and guidelines follow similar context.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VdFD09NXdpbQVuyINm4CmA.png" /></figure><p>All the utility integrations in the scheduler operations project are created as agentic AI tools.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BKQMIlCow2PwkFD7YfuP5g.png" /></figure><h4><strong>Exposing the Project as an MCP Server</strong></h4><p>And the Scheduler Operations project can be enabled as an MCP Server.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/399/1*8G5HpevPeMMJEF7KtisG7A.png" /></figure><h4>Configuring the AI Agent in Langflow</h4><p>After exposing the Scheduler Operations project as an MCP Server in OIC, the next step is to consume it from Langflow.</p><p>For this use case, I created a simple AI Agent in Langflow and configured it to connect to the OIC MCP Server. Once connected, MCP Tools component in Langflow automatically discovers all the tools exposed by the MCP Server, making them available to the AI Agent without any additional implementation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dZvjY9beOHDyG4u6gOBWIQ.png" /></figure><h4>Configuring the MCP Server</h4><p>The MCP Tool component in Langflow requires the URL of the OIC MCP Server along with the necessary authentication details.</p><p>Once the connection is established, Langflow retrieves the list of available tools exposed by the Scheduler Operations project.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/510/1*CEuWZTQv6T3FPCmirY469w.png" /></figure><h4>Configuring the AI Agent</h4><p>The AI Agent is configured with a simple prompt describing the supported scheduler operations and the available MCP tools.</p><p>Since the business logic resides within the OIC utility integrations, the prompt remains concise and mainly guides the agent on when to invoke each tool.</p><p><strong>Prompt:</strong></p><p>The following prompt defines the operational scope of the AI Agent, the available MCP tools, input validation, execution rules, and safety guardrails. It ensures that scheduler operations are performed only on validated projects using the appropriate tool and that the updated scheduler status is presented after every successful operation.</p><pre>You are an operational utility agent for Oracle Integration Cloud (OIC) Gen3.<br><br>Your responsibility is strictly limited to managing scheduled integrations within valid OIC projects.<br><br>Supported Operations:<br><br>* Start scheduled integrations<br>* Stop active scheduled integrations<br>* Pause scheduled integrations<br>* Resume paused scheduled integrations<br><br>Available Tools:<br><br>* GET_ALL_PROJECTS_TOOL<br><br>  * Retrieves the list of valid projects in the OIC instance.<br>  * Must be used to validate user-provided Project IDs before performing any operation.<br><br>* START_INTEG_SCHED_IN_PROJE_TOOL<br><br>  * Starts scheduled integrations within a validated project.<br><br>* STOP_INTEG_SCHED_IN_PROJE_TOOL<br><br>  * Stops active scheduled integrations within a validated project.<br><br>* PAUSE_INTEG_SCHED_IN_PROJE_TOOL<br><br>  * Pauses scheduled integrations within a validated project.<br><br>* RESUM_INTEG_SCHED_IN_PROJE_TOOL<br><br>  * Resumes paused scheduled integrations within a validated project.<br><br>* GET_INTE_SCHE_STAT_IN_PROJ_TOOL<br>   * Gets the statues of the schedulers within a validated project.<br><br>Input Rules:<br><br>* Accept either:<br><br>  * a Project Module name<br>  * or a full Project ID<br>* If only a module name is provided, construct the Project ID using:<br>  PROJECT_&lt;module_name&gt;<br><br>Validation Rules:<br><br>* Always validate the Project ID using GET_ALL_PROJECTS_TOOL before performing any operation.<br>* Never proceed if the project does not exist.<br>* Never assume project names, environments, or identifiers.<br><br>Execution Rules:<br><br>* Identify the requested operation:<br>  * start<br>  * stop<br>  * pause<br>  * resume<br>  * status<br>* Invoke only the appropriate tool for the requested operation.<br>* After executing the operation:<br>Show the scheduler status of the requested project(s) by using GET_INTE_SCHE_STAT_IN_PROJ_TOOL tool, and present the details to the user in a tabular format with columns as IntegrationName &amp; SchedulerStatus.<br><br><br>Operational Guardrails:<br><br>* Only operate within the validated Project ID explicitly provided by the user.<br>* Never operate on integrations outside the target project.<br>* Never perform create, delete, update, deployment, activation, deactivation, or configuration modification operations.<br>* Never invoke tools unrelated to the requested operation.<br>* Never fabricate projects, integrations, statuses, or execution outcomes.<br>* Invoke only one operational tool per user request.<br><br>Error Handling:<br><br>* If a tool execution fails, clearly report the error.<br>* Do not guess or simulate execution results.<br>* Ask for clarification if the request is ambiguous or incomplete.<br><br>Safety Principles:<br><br>* Operate conservatively.<br>* Prioritize operational safety, traceability, and accuracy.<br>* Minimize unintended operational impact.</pre><blockquote><strong>Note</strong>: In my OIC environment, the OIC projects are organized based on business modules such as <strong>SCM</strong>, <strong>CRM</strong>, and <strong>CPQ</strong>. Each scheduler operation accepts one or more project names as input and performs the requested operation on the corresponding module. <strong>Ex:</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WONhq2H_7lWGr2-jN5ewKw.png" /></figure><h4>Executing the AI Agent</h4><p>Once the AI Agent is configured, it can interact with the Scheduler Operations project using natural language.</p><p>For example, the following requests can be executed:</p><ul><li>Show scheduler status for SCM</li><li>Show scheduler status across all projects</li><li>Stop schedulers in SCM</li><li>Pause schedulers in CRM and CPQ</li><li>Resume schedulers in CPQ</li></ul><p>The AI Agent interprets the user’s request, invokes the appropriate MCP tool, and presents the response in a user-friendly format.</p><p>Langflow playground chat:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/1*OrKcRkZz4NT8BYG5NgVKsg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/811/1*akWtGYqBo7oSdsSlUBClQg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/877/1*adzE67D2d-zMYWi45UWRTA.png" /></figure><p>Ex: This has paused the integrations in Project_CPQ &amp; Project_CRM projects.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*041Jb8G9c3gXcT0BbgxInA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X0gmBe6NA_WUedjtpMgCdw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/805/1*cTfRNfl99qQxwfQUn9SRSw.png" /></figure><p>This has resumed the CPQ schedulers</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Zh5XdR5d_d0kcKLqezebJA.png" /></figure><h4>Multi-Project Execution</h4><p>One advantage of exposing the utility project through MCP is that the AI Agent can handle requests involving multiple OIC projects.</p><p>For example, when the user requests the scheduler status across multiple projects, the AI Agent invokes the <strong>Get Scheduler Status</strong> tool for each project and consolidates the results into a single response.</p><p>Similarly, operations such as start, stop, pause, and resume can also be performed across multiple projects using a single natural language request.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/884/1*YvlOU_akbRRb_UQT7JEvNQ.png" /></figure><h3>Final Thoughts</h3><p>This approach demonstrates how existing OIC utility integrations can be exposed as tools in a MCP Server and easily consumed by external AI applications such as Langflow.</p><p>By separating the operational logic into reusable OIC integrations and exposing them as MCP tools, the same services can be reused by different AI clients without modifying the underlying implementation.</p><h4>References</h4><ul><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/aiagents/use-integrations-tools-mcp-server.html">Using Agentic AI in Oracle Integration 3</a></li><li><a href="https://sumanthkoditala.medium.com/from-integrations-to-ai-tools-using-oracle-oic-mcp-tools-in-langflow-with-cohere-llm-a48adab59889">From Integrations to AI Tools: Using Oracle OIC MCP Tools in Langflow with Cohere LLM</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=08c2242b11dc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Event-Driven Invoice Processing for Oracle Fusion ERP Using OCI Events, Streaming, OCI Document…]]></title>
            <link>https://sumanthkoditala.medium.com/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-cbe5c8e9f878?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/cbe5c8e9f878</guid>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[ai-oracle]]></category>
            <category><![CDATA[oracle-fusion]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Wed, 17 Jun 2026 04:25:38 GMT</pubDate>
            <atom:updated>2026-06-17T04:25:38.909Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Event-Driven Invoice Processing for Oracle Fusion ERP Using OCI Events, Streaming, OCI Document Understanding, and OIC</strong></h3><h4>Part 2: Implementation &amp; Execution</h4><p><a href="https://medium.com/@sumanthkoditala/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-dbd5272f44dd">In the previous part of this blog</a>, I covered the architecture overview, prerequisites, and the configurations required across OCI services to enable this event-driven invoice processing solution.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZoB3SKcfwucbq-hdbWsvFA.png" /></figure><p>In this part, I will focus on the Oracle Integration implementation, including the integration flow, OCI Document Understanding invocation, supplier master data enrichment using OIC lookups, and the creation of supplier invoices in Oracle Fusion ERP Cloud. Finally, I will demonstrate the end-to-end execution of the solution, from uploading an invoice to OCI Object Storage through to the automatic creation of an invoice in Fusion ERP.</p><h3><strong>OIC Integration implementation:</strong></h3><h4>1. Configure OCI Steaming adapter connection</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/704/1*DpJba7vInLmtiN6IgWWxhA.png" /></figure><p>You can obtain the Username and generate the Password by following the <strong>Step2 </strong>of <a href="https://medium.com/@sumanthkoditala/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-dbd5272f44dd">my previous blog part</a>. Also, the steps to generate the keystore file can be found in the <strong>Prerequisites</strong> section of the previous blog part.</p><h4>2. Configure REST Adapter connection for Fusion ERP Cloud</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/573/1*EfdJ9eTIorOwjTho46jMKg.png" /></figure><h4>3. OIC Flows</h4><p>For this solution, I have implemented two OIC integrations.</p><p>The first integration is responsible for consuming events from OCI Streaming whenever a new invoice document is uploaded to OCI Object Storage. Upon receiving the event, it extracts the file details and invokes the second integration.</p><p>The second integration receives the file name from the first integration, invokes OCI Document Understanding to extract the invoice details from the document, enriches the extracted data using OIC lookups, and finally creates the supplier invoice in Oracle Fusion ERP Cloud.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*kWP_q5Eryvh6R6EWrBFztw.png" /></figure><p>a. Object storage file event trigger flow</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*zdUNiUZnMWgQPxpfVd7XQA.png" /></figure><p>OCI Steaming Connection configuration in the flow</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/539/1*tMYSRs4mpMm09QXj6eExaw.png" /></figure><p>Sample payload:</p><pre>{<br>    &quot;eventType&quot;: &quot;com.oraclecloud.objectstorage.createobject&quot;,<br>    &quot;cloudEventsVersion&quot;: &quot;0.1&quot;,<br>    &quot;eventTypeVersion&quot;: &quot;2.0&quot;,<br>    &quot;source&quot;: &quot;ObjectStorage&quot;,<br>    &quot;eventTime&quot;: &quot;2026-05-16T20:42:55Z&quot;,<br>    &quot;contentType&quot;: &quot;application/json&quot;,<br>    &quot;data&quot;: {<br>        &quot;compartmentId&quot;: &quot;ocid1.compartment.oc1..aaaaaaaawXXXXXXXXXXq&quot;,<br>        &quot;compartmentName&quot;: &quot;iPaaS-Compartment-2026&quot;,<br>        &quot;resourceName&quot;: &quot;Screenshot6.png&quot;,<br>        &quot;resourceId&quot;: &quot;/n/xxxxxxx/b/bucket-oic-ailearn/o/Screenshot6.png&quot;,<br>        &quot;availabilityDomain&quot;: &quot;HYD-AD-1&quot;,<br>        &quot;additionalDetails&quot;: {<br>            &quot;bucketName&quot;: &quot;bucket-oic-ailearn&quot;,<br>            &quot;versionId&quot;: &quot;c1bbf99e-14f3-41c5-XXX-f485728e1253&quot;,<br>            &quot;archivalState&quot;: &quot;Available&quot;,<br>            &quot;namespace&quot;: &quot;xxxxxxx&quot;,<br>            &quot;bucketId&quot;: &quot;ocid1.bucket.oc1.ap-hyderabad-1.aaaaaaaag5scjXXXXXhdcq&quot;,<br>            &quot;eTag&quot;: &quot;e9a162d9-2844-492a-9890-XXXd82caa3&quot;<br>        }<br>    },<br>    &quot;eventID&quot;: &quot;e3a399d4-4d3f-3911-d036-5c957187a687&quot;,<br>    &quot;extensions&quot;: {<br>        &quot;compartmentId&quot;: &quot;ocid1.compartment.oc1..aaaaaaaawXXXXXXXXXXq&quot;<br>    }<br>}</pre><p>b. Document understanding and invoice creation flow — This flow will receive the filename from the first flow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*ffyUhBZUObGM3eYug965jQ.png" /></figure><p>Drag and drop the OCI Document Understanding action which is under OCI AI Services in Actions palette.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/570/1*ydm05G-FEAyLYReKKtgeTg.png" /></figure><p>Configure as below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/697/1*6yvFgMtSpEIg_o59ZfpY2Q.png" /></figure><p>Next, select the compartment, Input source as Object storage and input storage bucket as the bucket in which you are placing the invoice file.</p><p><strong>Note:</strong> OCI Document Understanding supports both <strong>Inline</strong> and <strong>Object Storage</strong> as input sources. When using <strong>Inline</strong>, the document content must be provided in Base64 format within the request payload. When using <strong>Object Storage</strong>, OIC reads the document directly from the specified Object Storage bucket, and only the file name needs to be passed in the mapper.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/613/1*9Ve82VZDClzM4UYk1JHv9A.png" /></figure><p>Configure REST connection configuration invoice creation in ERP</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/716/1*TtVBEOMoecdpk-VkHWmiEg.png" /></figure><p>Provided below sample payload for invoice creation, this is the minimal payload required to create an invoice.</p><pre>{<br>  &quot;BusinessUnit&quot; : &quot;US1 Business Unit&quot;,<br>  &quot;InvoiceNumber&quot; : &quot;INV_SK_0206_2&quot;,<br>  &quot;InvoiceAmount&quot; : 1000,<br>  &quot;InvoiceCurrency&quot; : &quot;USD&quot;,<br>  &quot;InvoiceDate&quot; : &quot;2026-06-01&quot;,<br>  &quot;Supplier&quot; : &quot;ABC Consulting&quot;,<br>  &quot;SupplierSite&quot; : &quot;ABC US1&quot;<br>}<br><br></pre><p>Note: SupplierSite and Business Unit are stored in a lookup in OIC for this demo.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iTSEuW4xpWiJUak_q840fw.png" /></figure><h3><strong>Execution</strong>:</h3><p>Upload the file into the bucket that emits the object create event.</p><p>Invoice uploaded for this demo:</p><p>I have highlighted the values we are interested in.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*MLcC4GTTTRjB-kiJDJF-IA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*2JlK65V7QszcvWTRaALiAQ.png" /></figure><p>OCI Stream Event has triggered the integrations</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*bF6k8vqEfg7B7J1gEiu_sA.png" /></figure><p>Key value pairs of Invoice are extracted as shown at runtime in the OIC by document understanding action.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/681/1*FfSKfb3uiEYzXPsmTRlFpQ.png" /></figure><p>Finally, invoice is created in Fusion ERP Cloud.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*9P7WEmyMC_idAf83_7LvTg.png" /></figure><h4>Conclusion:</h4><p>In this blog series, we built an event-driven invoice processing solution using OCI services and Oracle Integration. By leveraging OCI Events and OCI Streaming, invoice processing is automatically initiated whenever a document is uploaded to OCI Object Storage, eliminating the need for polling-based integrations.</p><p>OCI Document Understanding further simplifies the process by extracting invoice information directly from the uploaded document, enabling the automatic creation of supplier invoices in Oracle Fusion ERP Cloud. Together, these services provide a scalable and efficient approach to automating invoice processing while reducing manual effort.</p><h4>Possible Enhancements:</h4><p>OCI Document Understanding provides confidence scores for extracted fields. As a future enhancement, these scores could be used to implement validation thresholds and exception handling, allowing low-confidence invoices to be reviewed before being created in Oracle Fusion ERP Cloud.</p><h4>References:</h4><ul><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/invoke-object-storage-oci-object-storage-action.html">Using Integrations in Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/stream-service-adapter/understand-streaming-service-adapter.html">Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en-us/iaas/Content/Object/Tasks/managingbuckets_topic-To_enable_or_disable_emitting_events_for_object_state_changes.htm">Managing Emitting Events for Object State Changes in an Object Storage Bucket</a></li><li><a href="https://lavanya-siliveri.medium.com/triggering-an-oic-integration-via-oci-events-the-oci-streaming-service-approach-ce06438a4aa4">Triggering an OIC Integration via OCI Events - the OCI Streaming Service Approach</a></li><li><a href="https://docs.oracle.com/en-us/iaas/Content/Events/Concepts/eventsoverview.htm">Overview of Events</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cbe5c8e9f878" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Event-Driven Invoice Processing for Oracle Fusion ERP Using OCI Events, Streaming, OCI Document…]]></title>
            <link>https://sumanthkoditala.medium.com/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-dbd5272f44dd?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/dbd5272f44dd</guid>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[oraclecloudinfrastructure]]></category>
            <category><![CDATA[fusion]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Mon, 15 Jun 2026 14:44:34 GMT</pubDate>
            <atom:updated>2026-07-24T16:47:25.577Z</atom:updated>
            <content:encoded><![CDATA[<h3>Event-Driven Invoice Processing for Oracle Fusion ERP Using OCI Events, Streaming, OCI Document Understanding, and OIC</h3><h4>Part 1: Setup &amp; Configuration</h4><h3><strong>Overview</strong></h3><p>In this two-part blog series, I will demonstrate how to build an event-driven invoice processing solution that automatically creates supplier invoices in Oracle Fusion ERP Cloud when invoice documents are uploaded to an OCI Object Storage bucket.</p><p>To implement this solution, I have leveraged several Oracle Cloud Infrastructure services, including OCI Object Storage, OCI Events, OCI Streaming, OCI Document Understanding, and Oracle Integration.</p><p>The following diagram provides a high-level overview of the solution architecture, followed by a detailed explanation of the solution flow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZoB3SKcfwucbq-hdbWsvFA.png" /></figure><h3>Solution Flow</h3><ol><li>An invoice document is uploaded to an OCI Object Storage bucket.</li><li>OCI Object Storage emits an event when the file is created.</li><li>OCI Events captures the event and routes it to OCI Streaming based on configured rules.</li><li>Oracle Integration consumes the event from OCI Streaming.</li><li>Using the uploaded file name, Oracle Integration invokes OCI Document Understanding to extract invoice details from the document stored in Object Storage.</li><li>The extracted invoice information is enriched with ERP-specific master data using an OIC lookup.</li><li>Finally, Oracle Integration invokes Oracle Fusion ERP Cloud APIs to create the supplier invoice automatically.</li></ol><p>To implement this end-to-end solution, a few prerequisite configurations are required. You can find the detailed steps in the <strong>Prerequisites</strong> section later in this blog.</p><h3>Focusing on the core flow</h3><h4>1. Create a OCI bucket in OCI Object Storage and enable “Emit object events”.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/624/1*O7dhabNgU7k5W2nxJ-_VYg.png" /></figure><h4>2. Create a Stream Pool &amp; Steam</h4><p><em>Navigation</em>: Analytics &amp; AI -&gt; Messaging -&gt; Streaming</p><p>Create a Steam along with new stream pool and leave other settings as default</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/726/1*ajed2zB_hW2Mi_m5O2IKMQ.png" /></figure><p>Now note down the Kafka connection setting, which is later used in as <strong>username</strong> for configuring OCI Streaming adapter connection in OIC.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/823/1*L8X-hfsowW46tVCZrXAjtw.png" /></figure><p>Next, we need to provide User profiles ‘AUTH_TOKEN’ as <strong>password </strong>for configuring <strong>OCI Streaming adapter connection in OIC</strong>, follow the below sequence to generate the token. Once generated, note down the token as you cannot revisit to copy again.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*nsJmP8b5_dpCaf_ZU3lmAw.png" /></figure><h4>3. Create event rule by setting up Conditions &amp; Actions</h4><p>Choose the steam you created in Step2</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/635/1*dNAaBwJumfyOdLK5wvGAtw.png" /></figure><h4>4. Explore OCI Document Understanding Service</h4><p><em>Navigation</em>: Analytics &amp; AI -&gt; AI Services -&gt; Document Understanding -&gt; Key value extraction</p><p>For Document Source as Local files -&gt; Setup an output location as below -&gt; Upload your Invoice file to analyse the data extraction</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*MzgbA_RuTa8rGTdkLUFCqg.png" /></figure><p>Analyse results and its key values for the uploaded Invoice.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*L5JbShgbe0zMneeTaRnC8g.png" /></figure><p>The analysed results look good for invoice creation in ERP, which I will demonstrating in my next <a href="https://sumanthkoditala.medium.com/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-cbe5c8e9f878?sharedUserId=sumanthkoditala">part</a>.</p><h3>Prerequisites:</h3><p>Create a <strong><em>dynamic group</em></strong> and set the matching rule as resource.id = &lt;your OIC instance OAuth ClientID&gt;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*t4y4arY54NXlfQ86IV0Jng.png" /></figure><h4><strong>For Object Storage:</strong></h4><p>Set IAM Policies</p><pre>Allow dynamic-group identity_domain/group_name to manage object-family in compartment compartment_name<br><br>Allow dynamic-group identity_domain/group_name to inspect compartments in compartment compartment_name</pre><h4>For OCI Document Understanding:</h4><p>Set IAM Policy</p><pre>Allow dynamic-group identity_domain/group_name to manage ai-service-document-family in compartment compartment_name</pre><h4>For OCI Streaming Service:</h4><p>Generate a certificate file and import into a keystore</p><pre>openssl s_client -connect streaming.ap-hyderabad-1.oci.oraclecloud.com:9092 | sed -ne  &#39;/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p&#39; &gt; OCIStreaming.cert<br><br>keytool -keystore streaming_truststore.jks -alias OSSStream -import -file OCIStreaming.cert</pre><p>Easiest way to generate these files is to use OCI Cloud Shell and then download the files using Download option under Menu. Refer below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*c1GHDphK9TcTq_m0ZqCUTQ.png" /></figure><p>In <a href="https://sumanthkoditala.medium.com/event-driven-invoice-processing-for-oracle-fusion-erp-using-oci-events-streaming-oci-document-cbe5c8e9f878?sharedUserId=sumanthkoditala"><strong>Part 2</strong></a>, we’ll configure the OCI Streaming Adapter, invoke OCI Document Understanding directly from OIC, and automatically create AP invoices in Oracle Fusion ERP from uploaded PDF invoices.</p><h4>References:</h4><ul><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/invoke-object-storage-oci-object-storage-action.html">Using Integrations in Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en/cloud/paas/application-integration/stream-service-adapter/understand-streaming-service-adapter.html">Using the Oracle Cloud Infrastructure Streaming Service Adapter with Oracle Integration 3</a></li><li><a href="https://docs.oracle.com/en-us/iaas/Content/Object/Tasks/managingbuckets_topic-To_enable_or_disable_emitting_events_for_object_state_changes.htm">Managing Emitting Events for Object State Changes in an Object Storage Bucket</a></li><li><a href="https://lavanya-siliveri.medium.com/triggering-an-oic-integration-via-oci-events-the-oci-streaming-service-approach-ce06438a4aa4">Triggering an OIC Integration via OCI Events - the OCI Streaming Service Approach</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dbd5272f44dd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Optimizing OIC Integrations with Fusion ERP REST API Batch Actions]]></title>
            <link>https://sumanthkoditala.medium.com/optimizing-oic-integrations-with-fusion-erp-rest-api-batch-actions-88406b42535e?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/88406b42535e</guid>
            <category><![CDATA[oracle-integration]]></category>
            <category><![CDATA[oracle-fusion-cloud]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Mon, 25 May 2026 14:09:41 GMT</pubDate>
            <atom:updated>2026-05-25T17:13:47.088Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U3tAwB0v6x34dp_JK36OA.png" /></figure><p><strong>Overview: </strong>There are many cases where Fusion ERP Cloud REST APIs accept/respond with only one object at a time (for example: Account creation in CX or retrieving Items from SCM). However, in OIC integrations, we may receive 10–15 accounts from the source system in a single request for create/update operations. Typically, the integration is designed using a For Each action in OIC, where the REST API is invoked individually for every account.</p><p>This approach works completely fine and is suitable for many scenarios. However, it results in multiple invocations towards Fusion applications, and generally Oracle recommends avoiding overly chatty integrations wherever possible. As an alternative approach, Oracle provides Batch Actions support, where multiple operations can be sent within a single HTTP request. This can help reduce the number of invocations, minimize traffic towards Fusion ERP Cloud, and improve overall integration performance in applicable use cases.</p><p><strong>Batch Actions</strong></p><blockquote>We can combine multiple operations into a single HTTP request (batch actions) to improve performance.</blockquote><blockquote>The request body is a JSON object with field named parts, and it is an array of objects. Each object in the array contains below four fields:</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hL0pKTLkMz0JRKmzwQp34Q.png" /></figure><p>Sample Request:</p><pre>{<br>  &quot;parts&quot; : [ {<br>    &quot;id&quot; : &quot;part1&quot;,<br>    &quot;path&quot; : &quot;/itemsV2?onlyData=true&amp;fields=ItemNumber,ItemStatusValue,LifecyclePhaseValue,StyleItemNumberValue,PrimaryUOMValue&amp;q=ItemNumber=SK-0001_0520&quot;,<br>    &quot;operation&quot; : &quot;get&quot;<br>  }, {<br>    &quot;id&quot; : &quot;part2&quot;,<br>    &quot;path&quot; : &quot;/itemsV2?onlyData=true&amp;fields=ItemNumber,ItemStatusValue,LifecyclePhaseValue,StyleItemNumberValue,PrimaryUOMValue&amp;q=ItemNumber=SK-0002_0520&quot;,<br>    &quot;operation&quot; : &quot;get&quot;<br>  } ]<br>}</pre><p>Sample Response:</p><pre>{<br>    &quot;parts&quot;: [<br>        {<br>            &quot;id&quot;: &quot;part1&quot;,<br>            &quot;path&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2&quot;,<br>            &quot;operation&quot;: &quot;get&quot;,<br>            &quot;payload&quot;: {<br>                &quot;items&quot;: [<br>                    {<br>                        &quot;ItemNumber&quot;: &quot;SK-0001_0520&quot;,<br>                        &quot;ItemStatusValue&quot;: &quot;Active&quot;,<br>                        &quot;LifecyclePhaseValue&quot;: &quot;Production&quot;,<br>                        &quot;StyleItemNumberValue&quot;: &quot;SK_STYLE1_0520&quot;,<br>                        &quot;PrimaryUOMValue&quot;: &quot;Each&quot;<br>                    }<br>                ],<br>                &quot;count&quot;: 1,<br>                &quot;hasMore&quot;: false,<br>                &quot;limit&quot;: 25,<br>                &quot;offset&quot;: 0,<br>                &quot;links&quot;: [<br>                    {<br>                        &quot;rel&quot;: &quot;self&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2&quot;,<br>                        &quot;name&quot;: &quot;itemsV2&quot;,<br>                        &quot;kind&quot;: &quot;collection&quot;<br>                    },<br>                    {<br>                        &quot;rel&quot;: &quot;action&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2/action/addItemsToDeleteGroup&quot;,<br>                        &quot;name&quot;: &quot;addItemsToDeleteGroup&quot;,<br>                        &quot;kind&quot;: &quot;other&quot;<br>                    },<br>                    {<br>                        &quot;rel&quot;: &quot;action&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2/action/addSupplierAssociationsToDeleteGroup&quot;,<br>                        &quot;name&quot;: &quot;addSupplierAssociationsToDeleteGroup&quot;,<br>                        &quot;kind&quot;: &quot;other&quot;<br>                    }<br>                ]<br>            }<br>        },<br>        {<br>            &quot;id&quot;: &quot;part2&quot;,<br>            &quot;path&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2&quot;,<br>            &quot;operation&quot;: &quot;get&quot;,<br>            &quot;payload&quot;: {<br>                &quot;items&quot;: [<br>                    {<br>                        &quot;ItemNumber&quot;: &quot;SK-0002_0520&quot;,<br>                        &quot;ItemStatusValue&quot;: &quot;Active&quot;,<br>                        &quot;LifecyclePhaseValue&quot;: &quot;Production&quot;,<br>                        &quot;StyleItemNumberValue&quot;: &quot;SK_STYLE2_0520&quot;,<br>                        &quot;PrimaryUOMValue&quot;: &quot;Each&quot;<br>                    }<br>                ],<br>                &quot;count&quot;: 1,<br>                &quot;hasMore&quot;: false,<br>                &quot;limit&quot;: 25,<br>                &quot;offset&quot;: 0,<br>                &quot;links&quot;: [<br>                    {<br>                        &quot;rel&quot;: &quot;self&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2&quot;,<br>                        &quot;name&quot;: &quot;itemsV2&quot;,<br>                        &quot;kind&quot;: &quot;collection&quot;<br>                    },<br>                    {<br>                        &quot;rel&quot;: &quot;action&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2/action/addItemsToDeleteGroup&quot;,<br>                        &quot;name&quot;: &quot;addItemsToDeleteGroup&quot;,<br>                        &quot;kind&quot;: &quot;other&quot;<br>                    },<br>                    {<br>                        &quot;rel&quot;: &quot;action&quot;,<br>                        &quot;href&quot;: &quot;https://&lt;hostname&gt;:443/fscmRestApi/resources/11.13.18.05/itemsV2/action/addSupplierAssociationsToDeleteGroup&quot;,<br>                        &quot;name&quot;: &quot;addSupplierAssociationsToDeleteGroup&quot;,<br>                        &quot;kind&quot;: &quot;other&quot;<br>                    }<br>                ]<br>            }<br>        }<br>    ]<br>}</pre><p>Now lets see how to implement in OIC (by using the get Items use case)</p><ol><li>Configure REST connection with Fusion ERP Cloud hostname (Ex: https://&lt;hostname&gt;) and provide the credentials.</li><li>Overall OIC Flow (Request — response)</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xT21sI0PitJpiGWRch3VTg.png" /></figure><p>3. Configure the Invoke (GetItemDetails for BatchAction) as shown below using the connection created in step1.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/503/1*WfdI_GYNKmXcn-uM4BsKvA.png" /></figure><p>3. Provide request &amp; response payloads as shown in sample requests/response section above and select Content-Type for request headers.</p><p>5. XSLT Mapper for GetItemDetails</p><pre>a.  Provide Content-Type as &#39;application/vnd.oracle.adf.batch+json&#39;<br>b.  Generate id for each part using position() function for readbility</pre><pre>&lt;nstrgmpr:execute xml:id=&quot;id_12&quot;&gt;<br> &lt;nstrgmpr:HTTPHeaders&gt;<br>  &lt;ns23:StandardHTTPHeaders&gt;<br>   &lt;ns23:Content-Type&gt;<br>    &lt;xsl:value-of select=&quot;&#39;application/vnd.oracle.adf.batch+json&#39;&quot;/&gt;<br>   &lt;/ns23:Content-Type&gt;<br>  &lt;/ns23:StandardHTTPHeaders&gt;<br> &lt;/nstrgmpr:HTTPHeaders&gt;<br> &lt;ns25:request-wrapper&gt;<br>  &lt;xsl:for-each select=&quot;/nssrcmpr:execute/ns21:request-wrapper/ns21:items&quot;&gt;<br>   &lt;ns25:parts&gt;<br>    &lt;ns25:id&gt;<br>     &lt;xsl:value-of select=&quot;concat (&#39;part&#39;,position())&quot;/&gt;<br>    &lt;/ns25:id&gt;<br>    &lt;ns25:path&gt;<br>     &lt;xsl:value-of select=&quot;concat (&#39;/itemsV2?onlyData=true&amp;fields=ItemNumber,ItemStatusValue,LifecyclePhaseValue,StyleItemNumberValue,PrimaryUOMValue&amp;q=ItemNumber=&#39;, ns21:itemNumber )&quot;/&gt;<br>    &lt;/ns25:path&gt;<br>    &lt;ns25:operation&gt;<br>     &lt;xsl:value-of select=&quot;&#39;get&#39;&quot;/&gt;<br>    &lt;/ns25:operation&gt;<br>   &lt;/ns25:parts&gt;<br>  &lt;/xsl:for-each&gt;<br> &lt;/ns25:request-wrapper&gt;<br>&lt;/nstrgmpr:execute&gt;</pre><p>6. Final OIC execution</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/742/1*TdU7s9Xw0bfjDu9jEXe3Gg.png" /></figure><p><strong>Caveats:</strong></p><p>1. If a single part in the batch fails, then all other parts will fail because these batch actions are <strong>all or none actions</strong>. So, it may be wise to avoid this feature if you anticipate regular failure’s in target system as it would increase the backlog, because one part failure can <strong>stop </strong>all the other parts to process and the retries wont help untill the failure part is eliminated or fixed.</p><p>However, the good thing is that only the failed part is listed in the response, and the successful parts are not included. <strong>Still, overall processing will not happen for any part.</strong></p><p>Ex:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rEnCsZnIi64eAwWlPtVq7A.png" /></figure><p>2. Based on observed behavior during testing, the operations inside a batch request appear to be processed <strong>independently/parallelly</strong> (this behavior is not explicitly documented by Oracle). Because of this, batch actions may <strong>not </strong>be suitable for dependent operations that require sequential execution.</p><p>For example, creating an Account and its corresponding Address within the same batch request may fail, since the Address creation depends on the Account being created first and available for reference.</p><p><strong>Conclusion: </strong>Batch Actions improves the performance by combining mutiple api calls into single http request. We can leverage batch actions in OIC, which would reduce the traffic between OIC to Fusion and increase the overall performance.</p><p><strong>References:</strong></p><p><a href="https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/26b/fasrp/Batch_Actions.html">https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/26b/fasrp/Batch_Actions.html</a><br><a href="https://docs.oracle.com/en/cloud/saas/sales/faaps/Perform_Batch_Actions.html">https://docs.oracle.com/en/cloud/saas/sales/faaps/Perform_Batch_Actions.html</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=88406b42535e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Oracle Integration Extension Functions for Timezone Conversion (Including Daylight Saving)]]></title>
            <link>https://sumanthkoditala.medium.com/oracle-integration-extension-functions-for-timezone-conversion-including-daylight-saving-4e190d74a6c4?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/4e190d74a6c4</guid>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[oracle-integration]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Wed, 20 May 2026 15:17:16 GMT</pubDate>
            <atom:updated>2026-05-20T16:09:16.685Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8U3tAwB0v6x34dp_JK36OA.png" /></figure><p><strong>Overview: </strong>It is a common requirement in integrations to convert a dateTime value from one timezone to another timezone, including handling Daylight Saving Time (DST). However, in many scenarios, we generally don’t find a direct and reliable way to perform timezone conversions when DST comes into picture.</p><p>Traditionally, we used to maintain lookups with timezone offsets and DST flags, or to an extent use custom JavaScript programs hosted on separate servers and invoke them over REST to get the converted datetime details. But with the Extension Functions provided by Oracle Integration, it is now a much more direct and reliable approach to convert dateTime values between timezones while automatically handling DST changes.</p><p>Below are the steps and function details:</p><ol><li>Create a JavaScript function using Oracle Integration extension function as below:</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/907/1*fSbqjrdsrZUwZE_eMkPN9g.png" /></figure><p>This function has three inputs:</p><p><strong>source_datetime</strong> — Provide the datetime of the source in ISO date time format (without the time zone information). Ex: 2026–05–09T09:53:10</p><p><strong>source_timezone_id</strong> — Provide the source timezone id in IANA timezone identifier format. Ex: America/Los_Angeles</p><p><strong>target_timezone_id — </strong>Provide the target<strong> </strong>timezone id in IANA timezone identifier format.</p><p>2. Create a library in OIC by uploading above JavaScript function</p><p>Ensure no validation errors and JavaScript function as below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/907/1*G2y1gAXQ0m1BkAKmtZ0K9A.png" /></figure><p>3. Drag the drop the function from the User Defined section:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/907/1*cFISurPf9BU8ER-PDDNEuQ.png" /></figure><p>Note: For this example, I am using XSLT mapper for converting, but this user-defined function can be used in Assign or in JavaScript action.</p><p>4. Execution</p><p>a. With Day Light Savings (May-2026) UTC-7hrs</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/540/1*q8sqYWI6DdFqsMHYpe9rXg.png" /></figure><p>b. Without Day Light Savings (Dec-2026) UTC-8hrs</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/542/1*0Q4eFrE02K04cqr9kB8xVw.png" /></figure><p><strong>Conclusion: </strong>Using this out-of-the-box Oracle Integration Extension Function, we can easily convert dateTime values from one timezone to another timezone, including handling Daylight Saving Time (DST).</p><p>Since the conversion is handled directly within Oracle Integration, the approach is much more reliable, cleaner, and easier to maintain, with minimal implementation effort.</p><p><strong>References</strong>:</p><p><a href="https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/import-library-file.html#GUID-D9638CD4-ADCE-4C8A-B5B3-1969086E642E">https://docs.oracle.com/en/cloud/paas/application-integration/integrations-user/import-library-file.html#GUID-D9638CD4-ADCE-4C8A-B5B3-1969086E642E</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4e190d74a6c4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Integrations to AI Tools: Using Oracle OIC MCP Tools in Langflow with Cohere LLM]]></title>
            <link>https://sumanthkoditala.medium.com/from-integrations-to-ai-tools-using-oracle-oic-mcp-tools-in-langflow-with-cohere-llm-a48adab59889?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/a48adab59889</guid>
            <category><![CDATA[oic]]></category>
            <category><![CDATA[cohere]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <category><![CDATA[mcp-server]]></category>
            <category><![CDATA[langflow]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Sun, 22 Mar 2026 10:05:59 GMT</pubDate>
            <atom:updated>2026-03-22T10:05:59.290Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*i8iA7KKGplAHS4LHQv5rWQ.png" /></figure><p>In my previous two blogs, I demonstrated how an <a href="https://medium.com/@koditaalasumanth/from-integrations-to-ai-tools-turning-oracle-integration-cloud-projects-into-mcp-servers-ef511ab676ad">Oracle Integration Cloud (OIC) project can be enabled as a Model Context Protocol (MCP) server</a> and how these tools can be <a href="https://medium.com/@koditaalasumanth/from-integrations-to-ai-tools-consuming-oic-mcp-tools-in-oracle-ai-agent-studio-26a-4ce8296fa1c9">consumed within Oracle AI Agent Studio 26A</a>.</p><p>In this blog post, we see the next step by exploring OIC MCP tools usage in a non-oracle stack, i.e., how the same OIC MCP tools can be leveraged within the Langflow platform with Cohere LLM (using a free trial key).</p><blockquote>Overview</blockquote><ol><li>Setting up the environment</li><li>Adding MCP Server in Langflow</li><li>Designing the Agent Flow</li><li>Flow execution and validation</li></ol><blockquote><strong>1. Setting up the environment</strong></blockquote><p><strong>Install Langflow Desktop Application</strong></p><p>Though we have multiple ways of installing langflow application, downloading Langflow desktop is the least complicated setup.</p><p>Ref: [<a href="https://www.langflow.org/desktop">langflow-desktop</a>]</p><p><strong>Setup trial API keys for Cohere LLM</strong></p><p>Cohere provides free trial Keys for evaluation purposes. Register yourself to get the keys:</p><p>Ref: [<a href="https://dashboard.cohere.com/welcome/register">cohere-register</a>]</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/774/1*ohb0OwvmT4jsULJH5niY8A.png" /></figure><blockquote><strong>2. Adding MCP Server in Langflow</strong></blockquote><p>Configure MCP Server by providing OIC MCP URL &amp; authorization. Navigate through MCP-&gt; Add MCP Server</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/539/1*7HFCAa6HqR23618UrH4-BA.png" /></figure><blockquote><strong>3. Designing the Agent Flow</strong></blockquote><p><strong>Create a Blank Flow &amp; explore the components</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/505/1*eUSDyR_AWUMvR1TOF6jc4Q.png" /></figure><p>Now, add these components Chat Input, Agent, MCP Tools, Current Date, Chat Output to the flow. Also, add Cohere Language Models component from Bundles.</p><ul><li><em>*Bundles contain custom components that support specific third-party integrations with Langflow. You add them to your flows and configure them in the same way as Langflow’s core components.</em></li></ul><p><strong>Configure MCP Tools</strong></p><p>In the MCP tool component, search for the MCP Server that you have created in step 2 and then enable the Tool Mode.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/421/1*mc_k2aPtjZGxtFQfHGRBow.png" /></figure><p>Also, we can explore and choose the tools that are required for the agent execution.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*5xsFCNZhHZkOm6vczPVm1w.png" /></figure><p><strong>Create a global variable for the Cohere API key and use it in the Cohere Language Models configuration</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/1*_tArTrvTQgV-GK5pLUiY5A.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/352/1*FpNsyZvqi9e3A6zrU8jYIw.png" /></figure><p><strong>Prompt or Agent Instructions</strong></p><p>Slightly modified my agent prompt compared to my previous blog, just to accommodate the “Current Date” tool, which was available as context variable in Oracle AI Agent Studio.</p><pre>***RESPONSIBILITIES***<br>Retrieve order details using customer reference<br>Evaluate delivery status and estimated delivery date<br>Ask CSR for confirmation before raising escalation<br>Raise escalation request if approved<br><br>***SESSION SETUP***<br>At the beginning of the session, invoke the attached MCP tool once to retrieve available tool descriptions.<br>Use <strong>get_current_date</strong> tool to get Today&#39;s date.<br>Use <strong>get_current_date</strong> tools date for all delivery date comparisons.<br><br>***PROCESS FLOW FOR EACH NEW ORDER***<br><br>1.Retrieve Order Details<br>Use GETORDERDETAILSBYCUSTOMERREFERENCE<br>Pass the customer reference provided by the CSR<br>Extract:<br>deliveryStatus<br>estimatedDeliveryDate<br>If no order is found, inform the CSR and stop.<br><br>2️. Evaluate &amp; Summarize for Escalation<br>Compare estimatedDeliveryDate with {{$context.$system.$currentDate}}<br>Escalation can be considered if:<br>Delivery is delayed<br>Estimated delivery date has already passed<br>If delivery is completed or date is in the future, escalation is not required.<br><br>Summarize the order status and explain why escalation is recommended (if applicable).<br><br>3. CSR Confirmation &amp; Escalation<br>Ask clearly:<br>&quot;Would you like me to proceed with raising an escalation request?&quot;<br>If the CSR confirms:<br>Immediately invoke RAISEORDERESCALATIONREQUEST<br>Confirm that the escalation has been successfully created<br>Share the escalationReference, expectedResolutionDate &amp; supportMessage returned<br><br>If the CSR declines:<br>Do not raise escalation<br>End the process politely<br><br>***IMPORTANT RULES***<br>The agent must not propose any action that does not directly map to an available tool.<br>The agent must not simulate or describe escalation creation before invoking the escalation tool.<br>Always follow: Retrieve - Evaluate - confirm &amp; raise<br>Never raise escalation without CSR confirmation<br>Use only <strong>get_current_date</strong> tool to get Today&#39;s date and for date validation<br>Do not fabricate data</pre><p><strong>Finally wire the components</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*5dW7msoGZQjNZHYYU6iJtA.png" /></figure><blockquote><strong>4. Flow execution and validation</strong></blockquote><p>For testing purposes, the logic in the OIC <em>GET_ORDER_DETAILS_BY_CUSTOMER_REFERENCE</em><strong> </strong>integration is implemented such that if the order (<em>customerReference</em>) starts with <strong>200*</strong>, the estimated<strong> </strong>delivery date is set in the past and the order status is marked as Pending. For all other orders, the delivery date is set in the future and the status is marked as Delivered.</p><p>Click on Playground button for chat interface</p><p>Escalating case (order starts with 200***):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*wcpG7OfZYOprrI9MoNYtGg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*SCLxg-bgSS3ZuVxXkV2yRg.png" /></figure><p>Non-Escalating case:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*GFJBURgypC7Gox0bTNXmBg.png" /></figure><p>OIC Instances:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/903/1*3JygZpbjRYKUMxFmjoAJbg.png" /></figure><p><strong>Conclusion: </strong>This demonstrates that OIC MCP tools are not limited to a specific platform. Langflow is one such example, highlighting how MCP enables interoperability and reuse of enterprise integrations across different AI platforms.</p><p><strong>References:</strong></p><p><a href="https://docs.langflow.org/">https://docs.langflow.org/</a></p><p><a href="https://docs.cohere.com/docs/the-cohere-platform">https://docs.cohere.com/docs/the-cohere-platform</a></p><p><a href="https://www.oracle.com/database/model-context-protocol-mcp/">https://www.oracle.com/database/model-context-protocol-mcp/</a></p><p><a href="https://medium.com/@jones.ncosta/from-zero-to-rag-building-ai-agents-with-langflow-and-oracle-autonomous-free-tier-420dcef84e3a">https://medium.com/@jones.ncosta/from-zero-to-rag-building-ai-agents-with-langflow-and-oracle-autonomous-free-tier-420dcef84e3a</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a48adab59889" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Integrations to AI Tools: Consuming OIC MCP Tools in Oracle AI Agent Studio 26A]]></title>
            <link>https://sumanthkoditala.medium.com/from-integrations-to-ai-tools-consuming-oic-mcp-tools-in-oracle-ai-agent-studio-26a-4ce8296fa1c9?source=rss-93463fbc19f3------2</link>
            <guid isPermaLink="false">https://medium.com/p/4ce8296fa1c9</guid>
            <category><![CDATA[ai-agent]]></category>
            <category><![CDATA[oracle-fusion-cloud]]></category>
            <category><![CDATA[mcp-protocol]]></category>
            <category><![CDATA[oracle-ai-agent-studio]]></category>
            <category><![CDATA[oracle-integration-cloud]]></category>
            <dc:creator><![CDATA[SumanthKoditala]]></dc:creator>
            <pubDate>Fri, 06 Mar 2026 05:46:16 GMT</pubDate>
            <atom:updated>2026-03-06T05:46:16.329Z</atom:updated>
            <content:encoded><![CDATA[<p>In the <a href="https://medium.com/@koditaalasumanth/from-integrations-to-ai-tools-turning-oracle-integration-cloud-projects-into-mcp-servers-ef511ab676ad">previous blog</a>, we enabled an Oracle Integration Cloud project as a Model Context Protocol (MCP) server and exposed integrations as AI tools.</p><p>In this post, we will add one more tool to that MCP server and then we will try to consume those tools inside Oracle AI Agent Studio 26A and see how an agent can safely execute enterprise actions (i.e., OIC integrations).</p><h3><strong>Overview:</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*-Rfn4-DTtZo4RVsvuaTgPw.png" /></figure><ol><li>Extend the previously created MCP Server by adding another tool<br> -Add a new integration to the existing OIC project and register it as an agent tool.</li><li>Create MCP Tool in Oracle AI Agent Studio.<br> -Configure the OIC MCP Server as an MCP Tool within Oracle AI Agent Studio.</li><li>Create an AI Agent and configure the MCP Tool.</li><li>Create an AI Agent Team and Test the End-to-End Flow<br> -Build an AI agent team using the configured agent and perform debugging and testing to validate the tool invocation.</li></ol><h3><strong>Demo Step-by-Step</strong></h3><ol><li>As we have already covered creation of MCP server on a OIC Project in my <a href="https://medium.com/@koditaalasumanth/from-integrations-to-ai-tools-turning-oracle-integration-cloud-projects-into-mcp-servers-ef511ab676ad">previous blog</a> but with only one integration/tool. Let’s add one more integration to this project and publish the same as AI Agent tool.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/482/1*ZwvZIVmakpIxePsIMF4gMw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*RmStgpKzuMKW-k0XM2XYPA.png" /></figure><p>Testing this tool response in postman</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*-yN-c3ssZx0WpVw5zIbbCg.png" /></figure><p>2. Create MCP Tool in Oracle AI Agent Studio and configure the OIC MCP Server.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*A77BFyiWUqZPloz8LuK20w.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*YqvQWVWon2jKL78DL2dV1Q.png" /></figure><p>3. Create an AI Agent and configure the above created MCP Tool</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/449/1*7EIz6etHdkBZlhVPEbwbYg.png" /></figure><p>Below is the system prompt for the agent. (took ChatGPT help to build this structured prompt after few iterations, though there is still room for further improvement)</p><pre>***RESPONSIBILITIES***<br>Retrieve order details using customer reference<br>Evaluate delivery status and estimated delivery date<br>Ask CSR for confirmation before raising escalation<br>Raise escalation request if approved<br><br>***SESSION SETUP***<br>At the beginning of the session, invoke the attached MCP tool once to retrieve available tool descriptions.<br>Today&#39;s date is {{$context.$system.$currentDate}}<br>Use this date for all delivery date comparisons.<br><br>***PROCESS FLOW FOR EACH NEW ORDER***<br><br>1.Retrieve Order Details<br>Use <em>GETORDERDETAILSBYCUSTOMERREFERENCE</em><br>Pass the customer reference provided by the CSR<br>Extract:<br>deliveryStatus<br>estimatedDeliveryDate<br>If no order is found, inform the CSR and stop.<br><br>2️. Evaluate &amp; Summarize for Escalation<br>Compare estimatedDeliveryDate with {{$context.$system.$currentDate}}<br>Escalation can be considered if:<br>Delivery is delayed<br>Estimated delivery date has already passed<br>If delivery is completed or date is in the future, escalation is not required.<br><br>Summarize the order status and explain why escalation is recommended (if applicable).<br><br>3. CSR Confirmation &amp; Escalation<br>Ask clearly:<br>&quot;Would you like me to proceed with raising an escalation request?&quot;<br>If the CSR confirms:<br>Immediately invoke <em>RAISEORDERESCALATIONREQUEST</em><br>Confirm that the escalation has been successfully created<br>Share the escalationReference, expectedResolutionDate &amp; supportMessage returned<br><br>If the CSR declines:<br>Do not raise escalation<br>End the process politely<br><br>***IMPORTANT RULES***<br>The agent must not propose any action that does not directly map to an available tool.<br>The agent must not simulate or describe escalation creation before invoking the escalation tool.<br>Always follow: Retrieve - Evaluate - confirm &amp; raise<br>Never raise escalation without CSR confirmation<br>Use only {{$context.$system.$currentDate}} for date validation<br>Do not fabricate data</pre><p>Now add previously created MCP Tool (CSR Tool) into Agent</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*jzl2SUeUHo5Wnj9GR-gcEw.png" /></figure><p>4. Add the above created agent into Agent Team as below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/603/1*8vFWCUcdGLt_q2HojYaUbQ.png" /></figure><p>Now let’s test the agent team and, in parallel validate the integration execution in OIC.</p><p>For testing purposes, the logic in the OIC <em>GET_ORDER_DETAILS_BY_CUSTOMER_REFERENCE</em><strong> </strong>integration is implemented such that if the order (<em>customerReference</em>) starts with <strong>200*</strong>, the estimated<strong> </strong>delivery date is set in the past and the order status is marked as Pending. For all other orders, the delivery date is set in the future and the status is marked as Delivered.</p><p>Escalating case (order starts with 200***):</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/569/1*Z8UVbVrTxzA5Nj_7Y4gRRA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/600/1*caje732cfBtZHstE9-huFQ.png" /></figure><p>Non escalating case:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*66Nr0HYl_381kyWLXV3AbA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/602/1*SWVbbEKyKHq6bnZTW_lP6Q.png" /></figure><p><strong>Conclusion</strong>: Agent does reasoning — MCP provides tool discovery — OIC executes integration (a governed execution layer)</p><p><strong>References </strong>:</p><p><a href="https://docs.oracle.com/en/cloud/paas/application-integration/aiagents/use-integrations-tools-mcp-server.html">https://docs.oracle.com/en/cloud/paas/application-integration/aiagents/use-integrations-tools-mcp-server.htm</a>l</p><p><a href="https://docs.oracle.com/en/cloud/saas/readiness/common/26a/common26a/26A-common-wn-f42183.htm">https://docs.oracle.com/en/cloud/saas/readiness/common/26a/common26a/26A-common-wn-f42183.htm</a></p><p><a href="https://niallcblogs.blogspot.com/2026/02/1118-fusion-ai-agent-studio-using-oic.html">https://niallcblogs.blogspot.com/2026/02/1118-fusion-ai-agent-studio-using-oic.html</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4ce8296fa1c9" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>