oracle hrms, oracle payroll, oracle interview questions, oracle tables, oracle payroll process, oracle tutorial, oracle hrms modules .. A blog for Oracle HRMS, Payroll and HCM Cloud lovers. A place purely for knowledge sharing and learning purpose with a focus on Application modules such as - Oracle E-Business Suite HRMS, Payroll, HCM Cloud, etc.
Labels
Sunday, 31 May 2026
Taleo Connect Client - How to use Last Run Date (LRD) in TCC Export
From Oracle to Outlook - automating SQL query output using Python - Part II
Saturday, 30 May 2026
From Oracle to Outlook - automating SQL query output using Python - Part I
Hello all,
It's been a while since my last post. Things have been busy especially in Australian payroll legislation space - Payday Super, AU Legislative changes after budget, etc. etc. 📜
As I have got some breathing space for now, so here is an attempt from my end to share knowledge around how i have been using Python 🐍 to fetch data from on premise Oracle Database and then capturing the same in outlook email message.
This can be a very useful thing for anyone who want to send a summary email to his/her team or management. The design of my solution is quite generic and the good thing is, you can use the template and can add queries as per your requirement and the output will just get appended in the outlook mail body
I have made this into a two-part blog post. In this first part i'll be writing about the building blocks and components. The next part will have details with a real example
- Setup logging and directories
- Load database credentials
- Open the Oracle connection
- Build the list of SQL query definitions
- Execute each SQL query and convert results to HTML
- Assemble one HTML email body from all sections
- Create an Outlook draft with that HTML content
Monday, 2 March 2026
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)
Wednesday, 4 February 2026
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
Tuesday, 3 February 2026
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
Monday, 26 January 2026
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 :)



