Recompile invalids EBS

3 ways...

1. Adadmin -> Compile/Reload Applications Database Entities menu -> Compile APPS schema

2. Manually -> alter [object] [object's name] compile

3. Database -> sqlplus / as sysdba @utlrp.sql

Show Hidden parameters 11g

Show DB 11g hidden parameters:

SELECT a.ksppinm "Parameter",
       b.ksppstvl "Session Value",
       c.ksppstvl "Instance Value"
FROM   x$ksppi a,
       x$ksppcv b,
       x$ksppsv c
WHERE  a.indx = b.indx
AND    a.indx = c.indx
AND    a.ksppinm LIKE '/_%' escape '/'
/

 select
   *
from
   v$parameter
where
   substr(name, 0,1) ='_';