Oracle eBusiness Suite Useful commands/scripts valid until version 11.5.x
Purpose
|
Command
|
AD Utilities
|
$APPL_TOP/ad/11.5.0/bin/adconfig.sh contextfile=<contextfile> appspass=$appspass run=INSTE8
adchkcfg.sh contextfile=filenmae.xml appspass=passwd
adrelink.sh force=y "fndr60runb"
|
Password Reset
| |
FND Queries
|
select node_name, SUPPORT_CP, SUPPORT_FORMS, SUPPORT_WEB, SUPPORT_ADMIN from fnd_nodes;
|
Workflow
|
select a.user_data.event_name, state, count(*)
from wf_deferred a
group by a.user_data.event_name, state;
select status, end_date from wf_notifications where mail_status='MAIL';
|
Forms Compilation
|
FORMS60_PATH=$AU_TOP/forms/US:${FORMS60_PATH}; export FORMS60_PATH
f60gen module=$AU_TOP/forms/US/ARXCUDCI.fmb userid=APPS/$appspass output_file=ARXCUDCI.fmx
|
Patch Applied or Not/Product Installed or not
|
select substr(APPLICATION_SHORT_NAME,1,10) Product,substr(BUG_NUMBER,1,10)
Patch#,decode(SUCCESS_FLAG,'Y','Successful',SUCCESS_FLAG) Status,substr(ARU_RELEASE_NAME,1,10)
Version,last_update_date applied_date from ad_bugs where
BUG_NUMBER= to_char('&bug_no');
select decode(nvl(a.APPLICATION_short_name,'Not Found'),
'SQLAP','AP','SQLGL','GL','OFA','FA',
'Not Found','id '||to_char(fpi.application_id),
a.APPLICATION_short_name) apps,
decode(fpi.status,'I','Installed','S','Shared',
'N','Inactive',fpi.status) status,
fpi.product_version,
nvl(fpi.patch_level,'-- Not Available --') Patchset,
to_char(fpi.last_update_date,'dd-Mon-RRRR') "Update Date"
from fnd_oracle_userid o, fnd_application a, fnd_product_installations fpi
where fpi.application_id = a.application_id(+)
and fpi.oracle_id = o.oracle_id(+)
order by 1,2
|
Useful Queries
|
select PATCH_DRIVER_ID, APP_SHORT_NAME , patch_level from AD_PATCH_DRIVER_MINIPKS order by 2
select * from fnd_concurrent_requests where request_id = &req_id
SELECT LANGUAGE_CODE, NLS_LANGUAGE, NLS_TERRITORY, NLS_CODESET,
DESCRIPTION, INSTALLED_FLAG
FROM FND_LANGUAGES_VL WHERE NLS_LANGUAGE='AMERICAN'
|
Profiles
|
select PROFILE_OPTION_NAME,user_profile_option_name USER_VISIBLE_FLAG, USER_CHANGEABLE_FLAG, USER_ENABLED_FLAG,
USER_UPDATE_ALLOWED_FLAG,profile_option_name
from fnd_profile_options_vl
where user_profile_option_name in ('FND: Debug Log Enabled',
'FND: Debug Log Level','FND: Debug Log Module','OM: Debug Level');
SELECT
a.profile_option_id, a.PROFILE_OPTION_NAME,a.user_profile_option_name, b.profile_option_value
FROM FND_PROFILE_OPTIONS_VL a, fnd_profile_option_Values b
where a.profile_option_id = b.profile_option_id and
a.user_profile_option_name like 'WF%';
select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;
select substr(fpot.user_profile_option_name,1,30) "Profile Option",
substr(fpov.profile_option_value,1,60) "Value",
--fpov.profile_option_id,
DECODE(fpov.level_id,10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User') "Level",
substr(fpov.level_value,1,10) "Ref_Value"
from applsys.fnd_profile_option_values fpov,
applsys.fnd_profile_options fpo,
applsys.fnd_profile_options_tl fpot
where fpo.profile_option_name = fpot.profile_option_name
and fpov.application_id = fpo.application_id
and fpov.profile_option_id = fpo.profile_option_id
and upper(fpov.profile_option_value) like upper('%&value%') ;
|
Formatted output
|
set linesize 1000
column profile_option_value heading "PROFILE|OPTION VALUE" format a50
column profile_option_name format a50 heading "PROFILE|OPTION NAME"
column profile_option_id heading "PROFILE|OPTION ID"
select distinct profile_option_value,level_id,profile_option_id
from fnd_profile_option_values
where profile_option_value like '%&profile_value%' and level_id=10007
order by profile_option_id
/
PROFILE PROFILE
OPTION VALUE LEVEL_ID OPTION ID
-------------------------------------------------- ---------- ----------
http://sitename.domainname.com/pls/envname 10007 2353
|
Ias,forms,Reports, CM up or down
|
ps -wef | grep sidname | grep http
ps -wef | grep sidname | grep f60
ps -wef | grep sidname | grep REP60
ps -wef | grep -i fnd
|