SQL Series | Using Aggregate Functions - Part I

 Hello Again,

Can’t believe we are already in March! There is a lot happening globally at all levels – geo-politics, technology, you name it, it feels like everything is on steroid mode 🤔 But today I would like to take a step back and focus some of the basic functions in SQL (yeah, you read it right)

We’ll try to look at three ‘Aggregate functions’ from Oracle EBS schema perspective. As the name indicates - Aggregate functions take multiple input rows and return a single summary value per group (or per entire result set).

So, let's get start (the third one is my favorite)

Oracle AI Agent Studio (OAIAS) - Components - TOPICS - Part II

Hello again 🙋
In this second and final part of the post, let's try creating our very own topic from scratch using a simple HCM‑style example: - Employee's Work from Home Policy.

I'll try and break the whole process into elementary steps

Oracle AI Agent Studio (OAIAS) - Components - TOPICS - Part I

Hello again, as promised in my last post, let's try and delve a bit deeper in each of the components. So, today’s topic is (surprise, surprise 😎😎😎 !!) Topics

Simply put, a Topic is how I can define the scope, intent, and purpose of what my agent is allowed to talk about, which tools it should use, and how to respond within a specific area of expertise.

When I add Topics, I’m really tightening the agent’s brief: I’m telling the LLM, in its system prompt, “These are the kinds of conversations you’re here for, and this is how I want you to behave in them."

Good thing is, Topics are reusable in nature and can be used across multiple agents. 

Now that we have a little understanding about it, let's dive straight into the system

Oracle AI Agent Studio - How to Access

First thing first, wishing a very Happy Australia Day and Republic Day to my fellow Aussies and Indian friends respectively 

In today's post I'll try and talk about Oracle AI Agent Studio. For first timers, it's your no-fuss playground for building smart AI agents right inside Oracle Fusion Cloud Applications. Think of it as a drag-and-drop workbench where you can tweak ready-made agent templates, craft custom ones from scratch, or even link multiple agents together for complex workflows. All without leaving the Fusion ecosystem. It taps straight into your app's data stores, tools, and APIs securely, so your agent(s) slot seamlessly into daily processes like HCM approvals, payroll flows and many other such tasks

Below is a high-level snapshot of what are the various components of an AI Agent. I'll create a separate post to dwell deeper into each one of them in coming days

Now first step is off course to gain access to the agent studio and thats what this post is all about :)

Happy New Year ... HRMS Blogging attempt 2.0

Although we're almost a month into 2026, I'm nevertheless wishing you all a very Happy New Year!

After nearly 8-9 years of radio silence here on my blog, I'm making an honest attempt to kick off 2026 by restarting my blogging journey.

Understandably, a lot of water has flown under the bridge in the last 8 years or so. I've progressed in my personal and professional career. Technology has moved at an unprecedented rate. I'm not sure if blog posts are still "a thing" in today's world.​

As part of my attempt to resurrect my blog, I'll expand the knowledge sharing beyond just Oracle EBS HR and Payroll to cover a broader tech stack that mirrors my daily work and experiments—Python, Oracle HCM Cloud, Power BI, Oracle APEX, etc.

I'll also play around with the blog UI, so you might notice a fresh redesign. It's all about readability for those long PL/SQL dives or Python notebooks.

Stick around; it'll be worth it :)