23 January, 2016

Signon Password

set lines 200
set pages 200
col USER_PROFILE_OPTION_NAME for a35
col PROFILE_OPTION_VALUE for a25

select t.USER_PROFILE_OPTION_NAME ,v.PROFILE_OPTION_VALUE
from applsys.FND_PROFILE_OPTIONS o ,applsys.FND_PROFILE_OPTIONS_TL t
,applsys.FND_PROFILE_OPTION_VALUES v
where o.PROFILE_OPTION_NAME = t.PROFILE_OPTION_NAME
and o.APPLICATION_ID=v.APPLICATION_ID(+)
and o.PROFILE_OPTION_ID=v.PROFILE_OPTION_ID(+)
and t.LANGUAGE='US' and t.USER_PROFILE_OPTION_NAME like 'Signon%'
order by 1 desc;

No comments:

Post a Comment

OEM Agent Installation

./agentDeploy.sh AGENT_BASE_DIR=/u001/oracle/product/agent13c OMS_HOST=oem-dev.xxx.com EM_UPLOAD_PORT=1159 AGENT_REGISTRATION_PASSWORD=*****...