Labels

2017 absence absence management Account accounting Agents AIM aliases AME and APEX API application application utilities lookups approval assignments ATO Australia Automation Bank bi publisher budget business business groups Business Objects CAGR candidates cartisian product case CEMLI Center Stage channels Classification Cloud competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing count coverage area customization data database date DateTracked deductions define design develop DFF diagnostics distinct document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GenAI GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links listagg lists localization location management New Year OAIAS obia obiee OLF onboarding oracle Oracle ACE Oracle AI Agent Studio oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM Oracle HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position Power BI primary key process profile programs project Python qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax TCC termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Sunday, 31 May 2026

Taleo Connect Client - How to use Last Run Date (LRD) in TCC Export

Hello all, Happy Sunday!

Some time back i posted couple of videos on my YouTube channel talking about Taleo Connect Client (TCC) its export and import functionalities. 

Today i thought of sharing some more info in regard to a key feature when it comes to TCC exports - Last Run Date (LRD).

From Oracle to Outlook - automating SQL query output using Python - Part II

Ok, here is the second and final part of this topic. So lets resume from where we left off

Now that the building blocks are clear, let’s walk through what actually happens when you run the script


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

From a high level, the flow is:
  1. Setup logging and directories
  2. Load database credentials
  3. Open the Oracle connection
  4. Build the list of SQL query definitions
  5. Execute each SQL query and convert results to HTML
  6. Assemble one HTML email body from all sections
  7. 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

image_01

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

Oracle AI Agents - Components

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 :)