Monday, March 29, 2010

Oracle Applications (EBS) Useful Commands

Hi All, I am compiling some useful commands for Oracle Application 11i and R12. I will try to update the list as I found new commands. Please share the scripts to me so that I may also include those to have online shared library of these useful commands reference.

How to find oracle apps release version

select APPLICATIONS_SYSTEM_NAME,RELEASE_NAME from apps.fnd_product_groups;

How to find Workflow Version embedded in Apps 11i ?

select TEXT from apps.WF_RESOURCES where NAME='WF_VERSION';

How to find version of JDK Installed on Apps ?

There might be multiple JDK installed on Operating System.
Like JDK 1.3.1, 1.4.2 or 1.5 but in order to find which Version of JDK your Apps is using Context File.
Open your Context File $SID_$HOSTNAME.xml under $APPL_TOP/admin and look for variable
JDK_TOP oa_var="s_jdktop" what so ever value assigned against that parameter go to that directory & cd bin & execute command
./java -version so lets assume entry above is /usr/jdk then cd /usr/jdk/bin & ./java -version

Finding Host Details

select     substr(node_name, 1, 20) node_name,
    server_address, substr(host, 1, 15) host,
    substr(domain, 1, 20) domain,
    substr(support_cp, 1, 3) cp,
    substr(support_web, 1, 3)
    web,
    substr(SUPPORT_DB, 1, 3) db,
    substr(VIRTUAL_IP, 1, 30) virtual_ip
from apps.fnd_nodes;

Checking Profile options: (should be enabled)

select DECODE(b.profile_option_value, 'Y', 'Enabled', 'Disabled') DETAILS
from apps.fnd_profile_options a, apps.fnd_profile_option_values b
where a.APPLICATION_ID = b.APPLICATION_ID
and a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID
and a.PROFILE_OPTION_NAME = 'CONC_GSM_ENABLED';

Checking listener status

lsnrctl status APPS_ABPRD
where ABPRD is my db sid name

Checking Concurrent Processes

select CONCURRENT_QUEUE_NAME,max_processes,running_processes from
apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME like 'FNDSM%';

How to check if a patch is applied or not ?

--Patch information is stored in AD_BUGS & AD_APPLIED_PATCHES table.
select bug_number from apps.AD_BUGS where bug_number ='&patch_no';

How to confirm form versions

First of all find the location of form and then enter the following command
strings -a $AP_TOP/forms/US/APXINWKB.fmx |grep '$Header'

More commands will be added soon…………………………………….

Here is the list of few important tables.

Concurrent Manager

FND_CONCURRENT_QUEUES
FND_CONCURRENT_PROGRAMS
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_QUEUE_SIZE

FND

FND_APPL_TOPS
FND_LOGINS
FND_USER
FND_DM_NODES
FND_TNS_ALIASES
FND_NODES
FND_RESPONSIBILITY
FND_DATABASES
FND_UNSUCCESSFUL_LOGINS
FND_LANGUAGES
FND_APPLICATION
FND_PROFILE_OPTION_VALUES

AD / Patches

AD_APPLIED_PATCHES
AD_PATCH_DRIVERS
AD_BUGS
AD_INSTALL_PROCESSES
AD_SESSIONS
AD_APPL_TOPS 

 

More commands will be added soon…………………………………….