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 Integration Repository and eTRM

As a lot of companies and users shift their focus towards the Cloud Products, sometimes it's easy to forget that an enormous number of customer still utilize EBS and will continue to do so for years to come. As such, those customers will continue to integrate their EBS environments with other systems, like early payment engines, OCR engines, tax engines, third party SCM systems, other ERP's and more. The following two resources are extremely powerful when planning integration work for EBS, and I have leveraged them countless times.

First, I wanted to remind everyone that the Integration Repository responsibility in EBS is a great resource to see whether there is already an Oracle API to accomplish a specific task. Please make use of it when building solutions to address customer needs or if you have doubts in regards to whether the vendor you are working with for your project, or your own development team, is building a custom function for an existing standard function or procedure, as you always want to leverage seeded functionality that will be supported by Oracle and doesn't break when upgrades happen.

For those that are not familiar with the Integration Repository, you simply need to add it as a responsibility under your user and browse the different modules to drill down to the specific service interface you want to look at. Once you drill into a specific API, you will see a list of the details including function names, parameters, rules, and much more.

Browsing the repository:

• I am showing Projects related API's in the screenshot.

Additionally, remember the Oracle eBusiness Suite Electronic Technical Reference Manual (eTRM), is also available to us with our Oracle Support accounts.

This one is especially useful to see EBS database design and dependency information, you can also browse the FND model and the Data Dictionary with it! This is an extremely powerful tool to see what happens to those database objects that you rely on when upgrades occur, as those changes will likely impact your custom concurrent programs, reports, alerts, and other extensions.

Link: http://etrm.oracle.com