-
Continue reading →: Oracle Database 23ai: Boolean Data TypeThe Boolean Data Type has been introduced in Oracle Database 23ai. In this post, we will look at how we can use this new data type. Let us create a table called INVOICES with two columns – Invoice Number and Paid Status. We use the Boolean Data Type for the…
-
Continue reading →: Installing Oracle Database 23ai on DockerIn my previous post, I have shown how you can install Oracle Database 23ai Free in VirtualBox Box. In this post we will see the steps to configure Oracle Database 23ai Free on Docker. Prerequisites Download Docker from here. Installation Once you have installed Docker, login to Docker. Open up…
-
Continue reading →: Setup an Oracle AI Data Platform Workspace instance in OCI
As organizations continue adopting AI and analytics solutions, having a centralized environment for data science and collaboration becomes increasingly important. Oracle AI Data Platform provides a unified platform that helps teams manage data, run analytics workloads, and develop AI-driven solutions efficiently. One of the first steps in getting started is…
-
Continue reading →: Setting Up Workspaces, Clusters and Notebooks in Oracle AI Data Platform
Oracle AI Data Platform provides a unified environment where teams can organize data, run analytics, and build AI solutions collaboratively. One of the key components of the platform is the AIDP Workbench, which allows users to create workspaces, configure compute clusters, and develop notebooks for data analysis and machine learning…
-
Continue reading →: Creating RAG-Based AI Agents in Oracle Fusion HCM
In my previous blog, I had demonstrated how to setup the security for Oracle Fusion AI Agent Studio for Oracle HCM. In this particular blog, I will demonstrate how we can create a RAG-Based agent using AI Agent Studio. For demonstration purposes, I will be creating a policy agent. I…
-
Continue reading →: Setting Up Security for AI Agent Studio in Oracle Fusion HCM
Oracle Fusion’s AI Agent Studio enables automation and intelligent workflows, but accessing it often requires proper security configurations. This blog provides a step-by-step guide for administrators to set up user roles and permissions, allowing them to effectively access and configure AI Agents within Oracle Fusion Cloud Human Capital Management.
-
Continue reading →: Transforming OIC Projects into MCP‑Enabled AI Tools
Enterprise AI is evolving rapidly, but in many organisations the primary bottleneck is no longer model capability – it’s execution. While large language models can summarise, reason, and plan effectively, enterprises typically cannot allow them to directly call APIs or trigger business processes without robust governance, controls, and oversight. This…
-
Continue reading →: Create a Confidential Application to Connect to OIC using Client Credential Grant Type
In modern enterprise ecosystems, seamless integration between applications is critical. When working with Oracle Integration Cloud (OIC), secure communication becomes a top priority. This is where OAuth 2.0-based authentication and confidential applications come into play. A confidential application is a secure client that can safely store credentials such as a…
-
Continue reading →: Decrypting Files with PGP in OIC: A Step-by-Step GuideIn my previous blog, we walked through generating public and private PGP keys and used the public key to encrypt a CSV file in OIC. In this follow‑up, we’ll build the reverse flow — decrypting that encrypted file using OIC. This time, we’ll use the private PGP key to restore…
-
Continue reading →: Encrypting Files with PGP in OIC: A Step-by-Step Guide
In today’s integration landscape, secure file exchange isn’t just a best practice – it’s a non‑negotiable requirement. Whether you’re exchanging data with external third-party applications, moving files across internal systems, or automating business processes, encryption plays a central role in protecting sensitive information. Oracle Integration Cloud (OIC) makes this easier…
-
Continue reading →: Create Your First Oracle Generative AI RAG Agent
In my previous blog, we learnt about the pre-requisite steps for provisioning an Oracle Generative AI RAG Agent in Oracle Cloud Infrastructure (OCI). In the subsequent blog, Creating a Knowledge Base for creating Oracle Generative AI RAG Agent, we learnt how to create a storage bucket and then created a…
-
Continue reading →: Creating a Knowledge Base for creating Oracle Generative AI RAG Agent
This is the second blog of the series Create an Oracle Generative AI RAG Agent. For simplicity, I have broken the post down into 3 parts: In my previous blog, we discussed the steps that you need to perform if your tenancy is not subscribed to any of the regions…
-
Continue reading →: Enabling Oracle Generative AI Agent for OCI Regions
What are Generative AI RAG Agents? Generative AI Agent is a fully managed service that combines the power of Large Language Models (LLMs) with AI technologies, to create intelligent virtual agents, that can provide accurate, personalized and contextually-relevant responses to end-user queries, and creates a highly engaging customer experiences. The…
-
Continue reading →: Creating a basic OIC Integration with REST
This post would be particularly useful for those who are just starting their learning journey with Oracle Integration Cloud. We will create a basic and fundamental integration to call and invoke a simple REST web service in an orchestrated integration. We will learn how to: So let us begin. Create…
-
Continue reading →: Manage File Server Settings in Oracle Integration 3
In one of the previous posts we learnt how to create a Oracle Integration 3 instance. In the next one, we saw how to enable the File Server. In this particular post, we will explore some of the basic configuration for the File Server from the Oracle Integration instance. More…
-
Continue reading →: Managing Users and User Groups in OCI
You can create an user or user groups if you are granted identity domain administrator or user administrator role in the Administrators page Identity Cloud Services console(IDCS). In this blog we’ll learn how to create users and user groups from the IDCS page within the OCI console. Create User To…
-
Continue reading →: Enabling File Server in Oracle Integration 3
If you are looking to design a file-based integration, then you need to use a File Server. Oracle Integration comes bundled with an SFTP server which you can use to store, share, and receive files, including files for SaaS integrations and third-party transfers. Oracle provides you with 500 GB of…
-
Continue reading →: Creating an Oracle Integration 3 Instance
Oracle Integration Cloud instances help you to design integration between the cloud applications and on-premise applications. It is a fully managed, pre-configured environment loaded with hundreds of pre-built adapters to connect with Oracle and other third-party applications. You can automate business processes, develop visual applications, use an SFTP-compliant file server…
-
Continue reading →: How to Bulk Upload Value Sets in Oracle FusionIn this blog we will look at how we can bulk upload Value Sets into Oracle Fusion. We will learn the process to import both Independent and Dependent Value Sets. Similar to Bulk Upload Lookup Types and Lookup Codes, we will be using File Based Loader. The process consists of…
-
Continue reading →: Bulk Upload Lookup Types and Lookup Codes in Oracle FusionIn this blog we will look at how we can bulk upload Lookup Types and corresponding Lookup Codes into Oracle Fusion. We can use File Based Loader for this purpose. The process is fairly simple and consists of the following steps. So let’s understand each step in more detail. Prepare…
-
Continue reading →: Generating an API Signing Key through OCI Console
In this post, we will look into the step-by-step process of how you can generate a private key/public key pair from the OCI Console. When the OCI console is used to generate the API signing key pair, a configuration file preview snippet is generated with the following keys and OCIDs.…
-
Continue reading →: Step-by-Step Guide to Oracle Database API for MongoDBUsing Oracle Database API for MongoDB, you can manipulate collection of JSON documents stored in an Oracle Database. If you are using ORDS version 22.3 or later, then you can use Oracle Database MongoDB API with any Oracle Database Release 21c or later, or Oracle Autonomous Database 19c or later(serverless,…
-
Continue reading →: Configuring Oracle Cloud Infrastructure (OCI) Bastion ServiceOracle Cloud Infrastructure Bastion provides restricted and time-limited access to target resources that don’t have public endpoints. Bastions let authorized users connect from specific IP addresses to target resources using Secure Shell (SSH) sessions. The target instance can be a compute instance or a DB system, an Autonomous Database for Transaction Processing…
-
Continue reading →: Oracle Database 23ai: Direct Joins for UPDATE and DELETE Statements
Oracle 23ai allows directs joins in update and delete statements. Let us understand how this works. Lets say we have two tables DEPARTMENT1. SQL> SELECT * FROM department_1; DEPTNO DNAME LOC_________ _____________ ___________ 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON And DEPARTMENT_2. SQL> SELECT…
-
Continue reading →: Oracle Database 23ai : Group By and Having using Column Aliases
Oracle Database 23ai allows us to use Column Aliases in GROUP BY and HAVING clauses. It also allows us to use Column-position in GROUP BY clause. Let’s see, how. To demonstrate this enhancement, we will work with the EMP table and the DEPT table. SQL> SELECT * from emp; EMPNO…
-
Continue reading →: Uploading File from OCI Object Storage to Oracle Autonomous DatabaseI have shown in my previous post, how you can create an Oracle ATP Database 23ai on Oracle Cloud free Tier. In this post let us understand, how we can create Upload a File containing data from OCI Object Storage to a table in the database, using the DBMS_CLOUD Package.…