用户配置文件相当于系统参数，可以在不同层级（Site层、应用模块层、责任层、用户层）设置不同的值；作用范围小的覆盖范围大的层，系统已经预设了很多user profile; 开发人员也可以定义
在EBS 中我们可能定义profile，用于存储特定的用户信息，以便在程序运行中进行调用。相当于全局变量.
1. Profile的定义
Path:application developer/profile
其中的hierarchy type 用来确定profile的作用范围。一般选security.
Profile的作用范围是底层优先的，也就是user 层的最优先，其次是organization….
比较常用的是根据responsibility 来提取profile的信息.
SQL Validation 是用来定义profile value 的value set的，当然不定义，然后手工输入也没问题，但为了安全，还是定义一个比较好，定义方法如下:
SQL="SELECT fv_region.flex_value \"Log Mode\",
fv_region.flex_value
into :visible_option_value,
:profile_option_value
FROM fnd_flex_value_sets fvs_region,
fnd_flex_values fv_region
WHERE fvs_region.flex_value_set_name = 'FAC_REORG_ASSET_REGION'
AND fvs_region.flex_value_set_id = fv_region.flex_value_set_id
AND fv_region.enabled_flag = 'Y' "
COLUMN="\"Log Mode\"(10)"
2. Profile 的维护
Path: System administrator/profile/system
可根据需要，在site/application/responsibility/organization/user层对相应的profile进行赋值。
3.使用profile
几个相关函数的使用说明实例
1. FND_PROFILE.GET(‘Name of the Profile’,variable name);
[sql] view plaincopyprint?
1. SELECT fnd_profile.value('PROFILEOPTION')
2. ,fnd_profile.value('MFG_ORGANIZATION_ID')
3. ,fnd_profile.value('ORG_ID')
4. ,fnd_profile.value('LOGIN_ID')
5. ,fnd_profile.value('USER_ID')
6. ,fnd_profile.value('USERNAME')
7. ,fnd_profile.value('CONCURRENT_REQUEST_ID')
8. ,fnd_profile.value('GL_SET_OF_BKS_ID')
9. ,fnd_profile.value('SO_ORGANIZATION_ID')
10. ,fnd_profile.value('APPL_SHRT_NAME')
11. ,fnd_profile.value('RESP_NAME')
12. ,fnd_profile.value('RESP_ID')
13. FROM DUAL;
SELECTfnd_profile.value('PROFILEOPTION')
,fnd_profile.value('MFG_ORGANIZATION_ID')
,fnd_profile.value('ORG_ID')
,fnd_profile.value('LOGIN_ID')
,fnd_profile.value('USER_ID')
,fnd_profile.value('USERNAME')
,fnd_profile.value('CONCURRENT_REQUEST_ID')
,fnd_profile.value('GL_SET_OF_BKS_ID')
,fnd_profile.value('SO_ORGANIZATION_ID')
,fnd_profile.value('APPL_SHRT_NAME')
,fnd_profile.value('RESP_NAME')
,fnd_profile.value('RESP_ID')
FROM DUAL;
2. variable name := FND_PROFILE.VALUE(‘Name ofthe profile’);
3. FND_PROFILE.PUT(‘Name of the profile’, valueof the profile);
[sql] view plaincopyprint?
1. SET SERVEROUTPUT ON;
2. DECLARE
3. v_conc_login_id NUMBER;
4. BEGIN
5. FND_PROFILE.put ('CONC_LOGIN_ID',1425);
6. fnd_profile.get ('CONC_LOGIN_ID', v_conc_login_id);
7. DBMS_OUTPUT.put_line (v_conc_login_id);
8. END;
9. Output:
10.1425
11.PL/SQL procedure successfully completed
SETSERVEROUTPUT ON;
DECLARE
v_conc_login_id NUMBER;
BEGIN
FND_PROFILE.put ('CONC_LOGIN_ID',1425);
fnd_profile.get ('CONC_LOGIN_ID',v_conc_login_id);
DBMS_OUTPUT.put_line (v_conc_login_id);
END;
Output:
1425
PL/SQLprocedure successfully completed
FND_PROFILE.GET is the procedure and FND_PROFILE.VALUE is the function so,it return a value.
4.FND_PROFILE.SAVE used to set the profile values frombackend.
The table fnd_profile_options_tl, profileoptions names are kept. Now find the corresponding the Profileoption namefor which you need to update from backend. For thisexample I took my favorite“ORG_ID”
SELECT profile_option_name
FROM fnd_profile_options_tl
WHERE user_profile_option_nameLIKE'MO%'
It returns more than one row but i can make out that "ORG_ID" is thePROFILE_OPTION_NAME for MO: Operating Unit. Now I need to know the Org_ID ofthe Org whose value is to be set in MO: Operating Unit. SO I use thesimpleselect as below
SELECT organization_id,NAME
FROMhr_all_organization_units;
From the organization name I find the one which will be the default OperatingUnit, and I note the ID. In my case the ID for my default Operating Unit is286. Now with the code below I set the profile option value usingfnd_profile.save.
DECLARE
stat BOOLEAN;
BEGIN
DBMS_OUTPUT.DISABLE;
DBMS_OUTPUT.ENABLE(100000);
stat := fnd_profile.SAVE('ORG_ID',286,'SITE');
IF stat
THEN
DBMS_OUTPUT.put_line('Stat = TRUE - profileupdated');
ELSE
DBMS_OUTPUT.put_line('Stat = FALSE - profileNOT updated');
END IF;
COMMIT;
END;
5.fnd_profile.defined
IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
l_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
....
In oracle user Profile functionality is provided inthe FND_PROFILE package and the FNDSQF library.
What is inside this API:
· Retrieve user profile values for the current run-time environment
· Set user profile values for the current run-time environment
There are various Objects that can be used with thisAPI's. These are discussed below:
1. Put :This can be used to put a value to the specified user profile option.
Usage:
· FND_Profile.Put('PROFILE_NAME','New_Value')
· FND_Profile.Put('USERNAME', Usr_Name)
· FND_Profile.Put('RESP_ID', Resp_ID)
· FND_Profile.Put('RESP_APPL_ID', Resp_App_ID)
· FND_Profile.Put('USER_ID', User_ID)
2.DEFINED : this is function returns TRUE if a value hasbeen assigned to the specified profile option.
Usage:
· SELECT fnd_profile.defined('ACCOUNT_GENERATOR:DEBUG_MODE')ACC_GEN_DEBUG_SESSION_MODE FROM DUAL;
3.GET :This is used to retrieve the current value of the specified user profileoption
Usage :
Different type of options can be retrieved like
· FND_Profile.Get('PROFILENAME', Profile_name);
· FND_Profile.Get('CONC_LOGIN_ID', Conc_login_id);
· FND_Profile.Get('LOGIN_ID', loginid);
4.VALUE : This is function which returns a character string. Used to retrievethe current value of the specified user profile option.
Usage:
· fnd_profile.value('PROFILEOPTION')
· fnd_profile.value('MFG_ORGANIZATION_ID')
· fnd_profile.value('login_ID')
· fnd_profile.value('USER_ID')
· fnd_profile.value('USERNAME')
· fnd_profile.value('CONCURRENT_REQUEST_ID')
· fnd_profile.value('GL_SET_OF_BKS_ID')
· fnd_profile.value('ORG_ID')
· fnd_profile.value('SO_ORGANIZATION_ID')
· fnd_profile.value('APPL_SHRT_NAME')
· fnd_profile.value('RESP_NAME')
· fnd_profile.value('RESP_ID')
5.VALUE_WNPS: This is a function, returns a character string.This is Used to retrieve the current value of the specified user profile optionwithout caching it.
6.SAVE_USER :This is function used to save a value for a profileoption permanently to the database, for the current user level. It is necessaryto explicitly issue a commit when using this function. Returns TRUE if profile optionis successfully saved, otherwise FALSE.
7.SAVE :This is function used to save a value for a profile option permanently tothe database, for a specified level. It is necessary to explicitly issue acommit when using this function. Returns TRUE if profile option is successfullysaved, otherwise FALSE.
Usage
· fnd_profile.save('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
8.INITIALIZE :This is used by internal Applications ObjectLibrary to initialize the internal profile information at the level context.
The cache is first cleared of all database options.
Usage:
· fnd_profile.initialize(user_id);
9.PUTMULTIPLE :This is used by internal Applications Object Libraryto set multiple pairs of profile options and values.
