DBA Blitz Report ORDS Configuration – 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. Shows ORDS schema enablement, REST module setup, PL/SQL package status, all 27 expected endpoint handlers, OAuth2 security grants, and profile option settings. Use this report to verify that the ORDS integration is complete and all components are properly configured.

Report Parameters

Section, Validation

Oracle EBS Tables Used

ords_schemas, ords_modules, dba_objects, dual, dba_procedures, dba_tab_privs, gv$session

Report Categories

Enginatics

DBA ORDS Configuration Validation, DBA SGA Active Session History, DBA AWR Active Session History, DBA AWR Blocking Session Summary, DBA SGA Blocking Session Summary, DBA Object Access Privileges, DBA Blocking Sessions, DBA SGA Buffer Cache Object Usage, DBA Result Cache Objects and Dependencies

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_Blitz_Report_ORDS_Configuration.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-blitz-report-ords-configuration/

© 2026 Enginatics