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, the complete OAuth2 chain (role, privilege, privilege-role mapping, privilege-module mapping, OAuth client, client-role grant), 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 errors.

Report Parameters

Section, Validation

Oracle EBS Tables Used

ords_schemas, ords_modules, ords_url_mappings, dba_objects, dual, dba_procedures, ords_handlers, ords_templates, dba_tab_privs, user_ords_roles, user_ords_privileges, user_ords_privilege_roles, user_ords_privilege_modules, user_ords_clients, user_ords_client_roles, gv$session

Report Categories

Enginatics

DBA Blitz Report ORDS Configuration, Blitz Report Add-in Setup Environment, XLA Entity ID Mappings, FND Applications, FND User Login Page Favorites

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 None
Blitz Report™ XML Import DBA_ORDS_Configuration_Validation.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-ords-configuration-validation/

© 2026 Enginatics