Assign tasks dynamically | Oracle Process Cloud
The most common requirement in all the process workflow is to assign tasks dynamically to the approvers. For example: When you raise requests, such as leaves, requisition, etc, the request […]
Convert Base 64 to PDF in Oracle Visual Builder
We came across one scenario where we need to call an external API that produces the PDF as a base64 string in response to the API and we need to […]
Features of Oracle Integration 3
Oracle Integration 3 is the new upgraded version of Oracle Integration with a new set of features. As of Oracle Integration 22.12, the following are the features of Oracle Integration-3: […]
Working with Cursors in Oracle PL/SQL
In this article I’ll explain several ways Cursors are used in PL/SQL. For basic details on cursors and its types please refer this blog. There are multiple ways we can […]
Invoke BIP Report with Parameters in OIC
In this article, I’ll develop an app-driven integration that will run an ESS job which invokes a BIP report and map the response to the REST connection. This use case […]
Load data in ATP from SFTP using OIC – Performance Enhancement
Loading data from a flat file coming from SFTP/BI Publisher or any third party source is a very common requirement for many of the integration. The traditional way for achieving […]
Load data in ATP from BIP using OIC
In this article, I’ll develop a scheduled integration that will run a BIP report in fusion and insert the data from the file in the ATP table. This use case […]
How to show a table in a select single component in Oracle Visual builder
In this article, I am going to demonstrate how can we embed a table in a select single component in oracle visual builder. What is the use of showing a […]
Place file in Object Storage from BIP using OIC
In this article, I’ll explain how to use Oracle Integration cloud to place file from BI Publisher report to Object Storage. What is Object Storage It is an internet-scale, high-performance […]
Place file in FTP Server from BIP using OIC
In this article, I’ll explain how to use Oracle Integration cloud to place file from BI Publisher report to FTP server. I’ll develop a scheduled integration that will run a […]
Oracle PL/SQL Cursor: Implicit and Explicit
In this article, I’ll explain cursors and different types of cursors(Implicit and Explicit) with examples. When an SQL statement is processed, Oracle creates a memory area known as the context […]
Creating Procedures, Functions, and Packages in PL/SQL
In this tutorial, you will see a detailed description of how to create and execute the named blocks (procedures and functions and packages). What is a Procedure? A Procedure in PL/SQL is […]