DBA Registry

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Database components installed, such as Oracle Text, JServer or XML Database, with their version and status.

A component with a status other than VALID can cause errors in the Oracle EBS functionality that depends on it and is usually fixed by running utlrp.sql or the component's validation procedure.
select
dr.comp_name,
dr.comp_id,
dr.version,
dr.status,
dr.modified,
dr.schema,
dr.other_schemas,
dr.control,
dr.namespace,
dr.procedure validation_procedure
from
dba_registry dr
where
1=1
order by
dr.comp_name
Parameter NameSQL textValidation
Invalid only
dr.status<>'VALID'
LOV
Download
Related Blitz Reports
DBA Registry SQL Patch AR Customer Upload AR Customers and Sites JL Brazilian Payables Import Bank Collection Documents Report- Not Supported: Reserved For Future Use AR Customer Relationships Listing MDS TEST AP Supplier Upload AP Supplier Upload AP Suppliers COPY OF: AP Supplier Upload
Blitz Report™