Below is the query to get Invalid Object in Oracle apps
select object_name, object_type, owner
from dba_objects o
where status = ‘INVALID’
order by
decode(o.owner,’SYS’,’01’,
‘SYSTEM’,’02’,
‘APPS’, ’06’,
‘APPS_MRC’, ’07’,
’03’),
decode(o.objecT_type,’PACKAGE BODY’,’10’,
‘VIEW’,’05’,
‘MATERIALIZED VIEW’,’06’,
‘SYNONYM’,’04’,
‘FUNCTION’,’07’,
‘PROCEDURE’,’07’,
‘PACKAGE’,’08’,
‘TABLE’,’02’,
’01’) ,
o.object_name ;
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Blog posts by Gowtham Raam is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
You are free to:
Share — copy and redistribute the material in any medium or format
Adapt — remix, transform, and build upon the material
for any purpose, even commercially.
The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
pacesettergraam 