DBA ORDS Configuration Validation – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Validates the Oracle REST Data Services (ORDS) configuration for Blitz Report webservices. Checks: ORDS schema enablement and URL mapping, REST module status, PL/SQL package validity, all 27 expected endpoint handlers and their ORDS template registrations, execute grants, URL-pattern privileges that intercept xxen_webservices calls and the OAuth client’s role grants (catches HTTP 401 caused by pre-existing catch-all privileges), ORDS URL profile configuration with token endpoint validation, OAuth2 client_id/secret availability, and ORDS connection pool sessions. Use this report to diagnose ORDS connectivity issues including OAuth token 404 and 401 errors.

Report Parameters

Oracle EBS Tables Used

ords_schemas, ords_modules, ords_url_mappings, dba_objects, dual, dba_procedures, ords_handlers, ords_templates, dba_tab_privs

Report Categories

Enginatics

Blitz Report Add-in Environment Setup, DBA Object Access Privileges, DBA AWR Active Session History, DBA SGA Active Session History, DIS End User Layers, DBA AWR Blocking Session Summary, DBA SGA Blocking Session Summary, FND Applications, DBA Table Modifications

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA ORDS Configuration Validation 25-Apr-2026 133958.xlsx
Blitz Report™ XML Import DBA_ORDS_Configuration_Validation.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-ords-configuration-validation/

© 2026 Enginatics