List Profile Option Values
-
SELECT
-
fpo.profile_option_id,
-
fpo.profile_option_name,
-
fpot.user_profile_option_name,
-
fpot.description,
-
fpov.level_id,
-
fpov.level_value,
-
CASE WHEN fpov.level_id=10004 THEN
-
usr.user_name
-
ELSE
-
'NOT USER LEVEL'
-
END AS user_name,
-
fpov.profile_option_value
-
FROM apps.fnd_profile_options fpo
-
left join (
-
SELECT *
-
FROM apps.fnd_profile_options_tl
-
) fpot ON fpot.profile_option_name=fpo.profile_option_name
-
left join (
-
SELECT *
-
FROM fnd_profile_option_values
-
) fpov ON fpov.profile_option_id=fpo.profile_option_id
-
left join (
-
SELECT *
-
FROM fnd_user
-
) usr ON usr.user_id=fpov.level_value
-
;
Create Custom Profile Option
Log in as Application Devloper responsibility, Goto Profile and add to the form.
Naming convention somthgin like:
XXGC:API_VALIDATE_ONLY
To get the right value:
select fnd_profile.value('XXGC:GREENWICHLOGOIMAGELOCATION') from dual
Setting a system level profile option
-
conn apps/${APPS_PWD};
-
-
SET SERVEROUTPUT ON
-
-
declare
-
l_res boolean;
-
l_val varchar2(1024) := '${ICXDO_TOP}/resource/xdodelivery.cfg';
-
BEGIN
-
dbms_output.put_line('Start profile.sql');
-
-
l_res := FND_PROFILE.SAVE(
-
X_NAME=>'IBY_XDO_DELIVERY_CFG_FILE', /* Profile name you are setting */
-
X_VALUE=>l_val, /* Profile value you are setting */
-
X_LEVEL_NAME=>'SITE', /* Level that you're setting at: 'SITE','APPL','RESP','USER', etc. */
-
X_LEVEL_VALUE=>NULL,
-
/* Level value that you are setting at, e.g. user id for 'USER' level.
-
X_LEVEL_VALUE is not used at site level. */
-
X_LEVEL_VALUE_APP_ID=>NULL,
-
/* Used for 'RESP' and 'SERVRESP' level; Resp Application_Id. */
-
X_LEVEL_VALUE2=>NULL
-
/* 2nd Level value that you are setting at. This is for the 'SERVRESP'
-
hierarchy. */
-
);
-
-
if (not l_res) then
-
dbms_output.put_line('ERROR - FND_PROFILE.SAVE returned false');
-
end if;
-
-
-
dbms_output.put_line('End profile.sql');
-
EXCEPTION
-
WHEN OTHERS THEN
-
dbms_output.put_line('Exception occured - '|| SQLERRM ||' - '|| SQLCODE);
-
END;
-
/
-
-
SET SERVEROUTPUT OFF
-
-
EXIT;
Other Articles
See also Known Profile Options
RJM Article Type
Quick Reference