Invalid Object in Instance

How to check for Invalid Objects in an Instance?

select object_name, object_type from dba_objects where status = 'INVALID' order by object_type, object_name;

What should I do?

Forward the issue to the DBA if you are a developer. Subject of the E-Mail would be Recompile all the forms. In most of the cases invalid objects may occur due to no apparent reason. DBA should recompile all forms for every 3 days or so

What DBA Should do?

using adadmin,
- 1. Generate Applications Files menu
- 2. Generate form files
- Enter the number of workers [4] :
- Do you want to generate Oracle Forms objects using this character set [Yes] ?
- Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?
- Do you want to regenerate Oracle Forms menu files [Yes] ?
- Do you want to regenerate Oracle Forms executable files [Yes] ?
- Enter list of products ('all' for all products) [all] : ont
- Generate specific forms objects for each selected product [No] ?
- Enter list of languages ('all' for all of the above) [all] :
- You selected the following languages: US
Is this the correct set of languages [Yes] ?