Oracle EBS 11i/R12 Useful Information

Workfolw

==========

select fsc.COMPONENT_NAME,fsc.STARTUP_MODE, fsc.COMPONENT_ STATUS

from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc

where fsc.concurrent_queue_id = fcq.concurrent_ queue_id( +)

and fcq.USER_CONCURRENT_QUEUE_NAME like '%Mail%';

Check Maintanance Mode

========================

select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

Enable/Disable Maintanance Mode

==============================

sqlplus -s apps/@$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

sqlplus -s apps/@$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

Find invalid Object Count

======================

Select count(*) from dba_objects where object_Name= 'INVALID' ;

Compile invalid object

===================

Alter package APPS.MSC_CL_PRE_PROCESS compile body;

Compile all invalid objects

=======================

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Find Applications Release

=======================

select release_name from fnd_product_ groups;

Find Number of Languages installed in Oracle Applications

====================================================

select nls_language, language_code,installed_flag

from apps.fnd_languages where installed_flag in ('I','B');

Database Name and Version

========================

select instance_name, version from v$instance;

Find Number of Nodes in instance

=============================

select node_name,support_cp from fnd_nodes;

Perl Version

==========

perl -version

Java Version

===========

$AFJVAPRG -version

Apache Server Version

====================

$IAS_ORACLE_ HOME/Apache/Apache/bin/httpd -version

Form Server Version

===================

f60gen |grep -i version

Reports Server Version

=====================

rwcon60 |grep -version

Find workflow version

===================

exec $FND_TOP/sql/wfver.sql

Find apps password

=================

grep password $APACHE_TOP/modplsql/cfg/wdbsvr.app

Find URL of the isntance

=====================

env |grep -i forms

select profile_option_ value from apps.fnd_profile_option_values

where profile_option_value like '%http%';