Revolutionizing Oracle EBS 12.2 with Natural Language Query (NLQ): October 2025 Update Adds Procurement Domain

As organizations across the globe continue to rely on Oracle E-Business Suite (EBS) 12.2 for mission-critical operations, the need for faster, intuitive, and more intelligent access to enterprise data has never been greater. Oracle’s latest October 2025 update introduces a major enhancement: the expansion of Natural Language Query (NLQ) capabilities—now including the highly requested Procurement domain.

At Altus, we see this update as a transformative step in modernizing how businesses interact with EBS today. What Is Natural Language Query (NLQ) for Oracle EBS?

Natural Language Query allows Oracle EBS users to ask business questions using plain English, without requiring SQL knowledge or technical expertise.

Examples:

• “Show me all open purchase orders for Supplier ABC.”

• “Which suppliers delivered late in Q3?”

  
  

Backed by Oracle Select AI and LLM-based Generative AI, NLQ automatically converts natural language inputs into optimized SQL queries, executes them securely, and returns results instantly.

This shifts EBS from a data-heavy system to an intuitive insights platform, enabling procurement, finance, HR, operations, and leadership teams to get answers in seconds. What’s New in the October 2025 Update? – Procurement Domain Added

The highlight of the October 2025 release is the introduction of the dedicated Procurement domain, enabling users to easily query:

• Purchase Orders

• Supplier performance metrics

• Approved suppliers

• Payment and receipt status

• Delivery delays

• Pricing trends and historical purchasing data

  
  

This domain has been one of the most demanded additions from organizations worldwide—especially those operating in supply-chain-intensive industries. With this update, procurement teams can now access data and insights that previously required complex SQL scripts or BI support.

How NLQ Works — A Modern Layer on Top of EBS

The NLQ framework leverages multiple Oracle technologies:

• Oracle EBS 12.2 modules

• Oracle APEX for the user interface

• Autonomous Database (or compatible DB) to store metadata

• Oracle Select AI for natural language interpretation and SQL generation

NLQ Workflow:

1. User enters a natural language question.

2. NLQ compiles EBS metadata and domain definitions.

3. LLM generates the appropriate SQL query.

4. SQL executes securely on the EBS database.

5. Results are displayed via the APEX interface.

Importantly, no sensitive business data is shared with the AI model—only metadata—ensuring full enterprise-grade security. Why This Matters for Global EBS Customers Organizations using Oracle EBS benefit from NLQ in several ways:

✔ Empower Non-Technical Users

Teams across procurement, HR, finance, and operations can gain access to real-time insights without requiring technical help.

✔ Faster Decision-Making

Natural language questions deliver instant answers—eliminating dependency on SQL experts.

✔ Reduced IT Reporting Load

IT teams can redirect focus from repetitive reporting tasks to strategic initiatives.

✔ Modern EBS Experience Without Migration

NLQ brings cloud-like analytics capabilities to EBS—ideal for organizations not yet ready for a full migration to Oracle Cloud ERP.

Security: Oracle’s Reinforced Approach NLQ maintains and respects existing EBS security controls:

• Role-Based Access Control (RBAC)

• Virtual Private Database (VPD) policies

• No exposure of transactional data to LLM models

  
  

Only metadata and sanitized prompts are used during AI processing.

This ensures NLQ is safe and compliant for organizations in all regions and industries.

Use Cases for the Procurement Domain

The new domain enables powerful, business-ready insights such as:

• “Which suppliers had delayed deliveries this month?”

• “Show purchase orders pending approval.”

• “List spending by category for the last two quarters.”

• “Top performing suppliers based on delivery score?”

• “Items with the highest price variance this year?”

  
  

These insights enhance procurement visibility and drive better supplier management and purchasing decisions.

How Altus Helps You Implement NLQ for EBS 12.2

As an Oracle Partner with deep expertise in both EBS and Oracle Cloud technologies, Altus supports enterprises worldwide through:

1. End-to-End NLQ Implementation

Configuration, metadata curation, domain setup, and AI integration.

2. Procurement Domain Enablement

Deploying and customizing the latest domain introduced in the update.

3. Custom Domain Extensions

Enabling NLQ for custom EBS tables, forms, and business-specific datasets.

4. Governance & Security Alignment

Ensuring that NLQ usage adheres to internal data governance policies.

5. User Training & Change Adoption

Workshops for procurement, finance, operations, and leadership teams.

Final Thoughts

Oracle’s October 2025 NLQ update marks a major milestone for EBS customers seeking AI-powered, self-service analytics without leaving the EBS platform.

With the new Procurement domain, users can unlock faster, smarter insights across one of the most critical business areas.

Altus is ready to help organizations worldwide leverage NLQ to modernize their EBS environment—securely, efficiently, and strategically.