DBA_REGISTRY_SQLPATCH

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.

Column	Datatype	NULL	Description
`PATCH_ID`	`NUMBER`	`NOT NULL`	ID associated with the patch
`PATCH_UID`	`NUMBER`	`NOT NULL`	UPI (Universal Patch ID) associated with the patch
`VERSION`	`VARCHAR2(20)`	`NOT NULL`	4 digit version on which the patch was installed (for example, 12.1.0.2)
`FLAGS`	`VARCHAR2(10)`		One or more of the following: `U`: Patch requires upgrade mode `J`: Patch is a JVM patch `F`: Patch was installed using -force `B`: Patch is a bundle patch
`ACTION`	`VARCHAR2(15)`	`NOT NULL`	`APPLY` or `ROLLBACK`
`STATUS`	`VARCHAR2(15)`		Possible values: `SUCCESS`: Patch application has completed with no errors `WITH ERRORS`: Patch application finished with errors
`ACTION_TIME`	`TIMESTAMP(6)`	`NOT NULL`	Timestamp when the install was performed
`DESCRIPTION`	`VARCHAR2(100)`		Description of this patch from OPatch metadata
`BUNDLE_SERIES`	`VARCHAR2(30)`		If a bundle patch, the series (for example, PSU or DBBP)
`BUNDLE_ID`	`NUMBER`		If a bundle patch, ID in the series
`BUNDLE_DATA`	`XMLTYPE`		If a bundle patch, the bundledata.xml associated with the patch
`LOGFILE`	`VARCHAR2(500)`		Location of the logfile for this apply or rollback attempt