AI Enhances Oracle Cloud HCM Support: Elevating Insight with the Oracle HCM Intel CLI

🤖 Oracle Gen AI + Public HCM Metadata = Limitless Insight

The Oracle HCM Intel CLI Tool is a professional-grade command-line assistant that uses your extracted HCM metadata and combines it with the capabilities of Oracle’s OCI Generative AI service (powered by Cohere) or OpenAI, or the LLM of your choice, giving you intelligent insights relative to HCM data structures. And it's all done securely and locally—no sensitive data leaves your environment.

By referencing public HCM data definitions, this project demonstrates just how powerfully Oracle Gen AI, and other AI offerings, can be applied in the enterprise to support analysts, developers, and architects with tasks such as:

• Generating SQL queries based on natural language
• Suggesting joins between key Oracle HCM tables
• Explaining and optimizing existing SQL
• Creating BI Publisher-ready templates
• Performing semantic metadata searches

Project GitHub: oracle_hcm_intel_cli

Demo: Watch Demo

---

Built With Practical Enterprise Needs in Mind

The tool includes features that any real-world implementation would benefit from:

• Encrypted .env handling using runtime secrets
• Markdown output for reporting or Copilot/Teams usage
• Audit mode for logging what metadata was passed to the LLM
• Modular provider support for OpenAI or Oracle Gen AI
• Interactive prompt chaining for analysts and non-developers

It’s optimized for real users working in real environments—offering flexibility without sacrificing security or precision.

---

Powered by Oracle Technology, Honoring Oracle’s Vision

This CLI tool is powered by Oracle’s own public documentation and showcases the capabilities of Oracle Cloud Infrastructure’s Generative AI platform. It's a clear example of how AI and metadata can be responsibly applied in the enterprise, especially when building tooling around Oracle’s HCM ecosystem.

Oracle’s Gen AI service is the star of the show here—it brings context, comprehension, and creative query generation to the hands of business users and technical professionals alike.

Earlier this month, I introduced a Metadata Extractor CLI Tool built to programmatically parse Oracle Cloud HCM’s public documentation and extract table and view metadata into JSON format. That foundational tool—available on GitHub at oracle_hcm_metadata_extractor—has enabled this powerful second act: the Oracle HCM Intel CLI.

---

Get Started

1. Extract metadata using: oracle_hcm_metadata_extractor

2. Query and explore with: oracle_hcm_intel_cli

Whether you’re working in HCM data architecture, reporting, or support—this is your AI-powered sidekick.

---

I hope this project inspires others to build upon Oracle’s cloud platform and apply Generative AI responsibly. The future of enterprise tooling is intelligent, secure, and deeply integrated—and with Oracle Gen AI, that future is now.

—
Julio @ OracleSpot.net

EBS Seeded Comparison Reports

Hello everyone, I haven’t written about EBS in a while since I’ve been focused on the Cloud products, but I wanted to bring to your attention the below seeded reports provided by Oracle which can be used to compare environments with different patch sets, to better assess the impact of applying those patches/upgrades and see differences at a low level. This is as relevant as ever since EBS patching hasn’t slowed down, and many new features continue to come in.

Below are descriptions of each report with the respective Oracle notes with all the relevant information. Most of the content and report description come straight from Oracle Support, the idea is to consolidate them here for your awareness.

They are all very useful, and one of them specially is of interest to me and I have used it extensively in order to compare different ATG versions to assess impact and help build a test plan. The ATG patch family is important because EBS continues to enhance through different avenues like enhanced Mobile support and the Enterprise Command Centers, and these rely heavily on your ATG readiness.

The EBS File Comparison Report provides a comprehensive comparison of file system artifacts between different Oracle E-Business Suite releases for important file types. As part of Oracle E-Business Suite upgrade planning, this report can assist customers to get a clear idea of "what is different in a new release" (additions, removals and modifications for Oracle E-Business Suite delivered files).

The report also covers some special artifacts that span the file system and database (for example, Oracle E-Business Suite delivered Oracle Application Framework (OAF) personalizations, Oracle Application Framework (OAF) based pages, Oracle Business Intelligence Publisher reports and so on).The EBS File Comparison Report is intended to complement other already available reports such as EBS Data Model Comparison report and EBS ATG Seed Data Comparison report.

The EBS data model comparison report provides the static database object definition changes between two EBS releases to help users to preview the database object definition changes before upgrading their instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows. Users can select a product and navigate the database object definition differences for each supported database object type.

The EBS ATG Seed Data Comparison Report provides a static delta between different EBS releases by documenting the seed data changes delivered by the product data loader files (.ldt extension) based on EBS ATG loader control (.lct extension) files.

The below Oracle Notes cover how to install and navigate the reports. All of these Oracle docs continue to get updated as releases occur and support up to 12.2.9 has been delivered for each of the below:

o EBS Data Model Comparison Report Overview (Doc ID 1290886.1)
o EBS File Comparison Report [VIDEO] (Doc ID 1446430.1)
o EBS ATG Seed Data Comparison Report (Doc ID 1327399.1)