set lines 200 pages 50000
col PROFILE_OPTION_NAME for a25
col PROFILE_OPTION_VALUE for a30
col USER_PROFILE_OPTION_NAME for a35
select o.user_profile_option_name,
ov.level_id,
ov.profile_option_id,
level_value,
profile_option_value
from fnd_profile_options_vl o, fnd_profile_option_values ov
where (
o.user_profile_option_name like '%INV%RPC%' or
o.user_profile_option_name like '%Concurrent%TM%')
and o.profile_option_id = ov.profile_option_id;
USER_PROFILE_OPTION_NAME LEVEL_ID PROFILE_OPTION_ID LEVEL_VALUE PROFILE_OPTION_VALUE
----------------------------------- ---------- ----------------- ----------- ------------------------------
INV: RPC Timeout 10001 4281 0 1000
Concurrent:TM Transport Type 10001 9855 0 QUEUE
Concurrent:Wait for Available TM 10001 1836 0 1
update applsys.fnd_profile_option_values a
set a.profile_option_value=1
where a.profile_option_id= 1836
and a.level_id=10001 ;
commit;