How to Determine Latest Patch Edition in ORACLE ERP

1. Determine the patch edition.
— Connect as apps
sqlplus apps

set linesize 1024
col OLD for a10
col run for a20
col patch for a30

select apps.ad_zd.get_edition(‘OLD’) “OLD”,
apps.ad_zd.get_edition(‘RUN’) “RUN”,
apps.ad_zd.get_edition(‘PATCH’) “PATCH”
from dual;

2. To Identify Invalid Objects

select count(*) from dba_objects where status=’INVALID';