Tuesday, July 9, 2024

The Online Patching Readiness report has identified XXX tables in the YYY schemas that should have editioned views.

 The Online Patching Readiness report has identified XXX tables in the YYY schemas that should have editioned views.

How should these be handled?



How To Check External Dependencies On Possible Obsolete Schemas With E-Business Suite (Doc ID 1995384.1)



The following SQL script can be used to output a list of Obsolete products. 

select a.application_id, a.application_short_name, at.application_name
from apps.fnd_application a
, apps.fnd_application_tl at
where a.APPLICATION_ID = at.APPLICATION_ID
and language='US'
and application_name like '%(_bsolete)%'
order by APPLICATION_NAME;

-- show external dependencies on possibly obsolete schema
set pagesize 1000
set linesize 200
column owner format a15
column name format a30
column type format a18
column referenced_name format a30
column referenced_type format a18

select owner, name, type, referenced_name, referenced_type
from dba_dependencies
where referenced_owner = '<OBSOLETE_SCHEMA_NAME>'
 and owner <> referenced_owner
order by 1,2,3
/

select owner, name, type
from dba_dependencies
where referenced_owner = '<TARGET_OWNER>'
  and referenced_name  = '<TARGET_NAME>'
  and referenced_type   = '<TARGET_TYPE>'
order by 1,2,3
/

No comments:

Post a Comment

Google, Mozilla, and Apple choosing to no longer support Entrust as a publicly trusted certificate authority

Google, Mozilla, and Apple have all decided to stop trusting Entrust’s publicly issued certificates after specific cutoff dates , due to lon...