Compile Database Objects - 1

There are multiple types of objects in database and different ways of compilation. There are different states for the objects and what we usually want them is to be "VALID".
To check the status of some object we can query user_objects, dba_objects views. Below query may show you the information required.

Tablespace Administration - 3

Temporary tablespace can be monitored/modified similarly, as we do for usual tablespaces. Use below links for details.
Tablespace Administration
Tablespace Administration with ASM
The difference here is the segments are temporary and are not being tracked by the views we have for other tablespaces.
For the files we have dba_temp_files and v$tempfile, and files are represented as tempfile at the place of datafile, and v$temp_space_header keeps track of free space.

So for the space and Usage we can have a query like below:-

Oracle Apps R12 Forms Not Opening

The forms for Oracle Apps EBS may not open for many reasons. Follow below steps to find out:-