Skip to content

DBA Registry SQL Patch

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

DBA Registry SQL Patch

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DBA Registry SQL Patch.sql
DBA Registry SQL Patch.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title DBA Registry SQL Patch | Oracle EBS SQL Report
description DBAREGISTRYSQLPATCH contains information about the SQL patches that have been installed in the database. A SQL patch is a patch that contains SQL scripts…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, DBA, Registry, SQL, Patch, dba_registry_sqlpatch
permalink /DBA%20Registry%20SQL%20Patch/

DBA Registry SQL Patch – Oracle EBS SQL Report

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

Overview

DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database. A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility. Each row contains information about an installation attempt (apply or roll back) for a given patch.

Report Parameters

Applied within x Days, Date From, Date To

Oracle EBS Tables Used

dba_registry_sqlpatch

Report Categories

Enginatics

Related Reports

AR Customer Upload, AR Customers and Sites, AP Supplier Upload

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 Registry SQL Patch 22-Dec-2025 084434.xlsx
Blitz Report™ XML Import DBA_Registry_SQL_Patch.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-registry-sql-patch/

Executive Summary

The DBA Registry SQL Patch report tracks the history of SQL patches applied to the database. In modern Oracle versions (12c+), binary patches (applied via opatch) often require a post-install SQL step (applied via datapatch). This report confirms that the SQL portion of the patch was applied successfully.

Business Challenge

  • Patch Verification: "The binary patch is installed, but did the datapatch utility run successfully?"
  • Audit Trail: "When was the 'Release Update 19.18' applied to this database?"
  • Troubleshooting: "Why are we seeing errors related to a patch that was supposed to be fixed?" (Maybe the SQL step failed).

Solution

This report queries DBA_REGISTRY_SQLPATCH.

Key Features:

  • Patch ID: The Oracle bug number associated with the patch.
  • Action: APPLY or ROLLBACK.
  • Status: SUCCESS or WITH ERRORS.
  • Description: A brief description of what the patch fixes.

Architecture

The report queries DBA_REGISTRY_SQLPATCH.

Key Tables:

  • DBA_REGISTRY_SQLPATCH: The inventory of SQL patches.

Impact

  • Compliance: Proves that security patches have been fully implemented (both binary and SQL).
  • Stability: Prevents "half-patched" states where the binaries are new but the data dictionary is old.
  • Version Control: Provides a clear timeline of database software changes.

Useful Links

© 2026 Enginatics