FND_PROFILE API is used very frequently in oracle apps development. The major purpose of this API is to:
- Retrieve user profile values for the current run-time environment
- Set user profile values for the current run-time environment
FND_PROFILE API has different procedures and functions which are most frequently used. Following are the brief explanation of them:
1. FND_PROFILE.PUT: This can be used to put a value to the specified user profile option.
Example:
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.FND_PROFILE.DEFINED : This is function which returns TRUE if a value has been assigned to the specified profile option else it returns FALSE.
Example:
SELECT fnd_profile.defined(’ACCOUNT_GENERATOR:DEBUG_MODE’) ACC_GEN_DEBUG_SESSION_MODE FROM DUAL;
3.FND_PROFILE.GET : This is used to retrieve the current value of the specified user profile option
Example :
FND_Profile.Get(‘PROFILENAME’, Profile_name);
FND_Profile.Get(’CONC_LOGIN_ID’, Conc_login_id);
FND_Profile.Get(’LOGIN_ID’, loginid);
4.FND_PROFILE.VALUE : This is a function which returns a character string. It can be used to retrieve the current value of the specified user profile option.
Example:
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.FND_PROFILE.VALUE_WNPS: This function also returns a character string. This is Used to retrieve the current value of the specified user profile option without caching it.
6.FND_PROFILE.SAVE_USER :This function is used to save a value for a profile option permanently to the database, for the current user level. It is necessary to explicitly issue a commit when using this function. It returns TRUE if profile option is successfully saved, otherwise FALSE.
7.FND_PROFILE.SAVE :This is function is used to save a value for a profile option permanently to the database, for a specified level. It is necessary to explicitly issue a commit when using this function. This also returns TRUE if profile option is successfully saved, otherwise it returns FALSE.
Example:
- fnd_profile.SAVE ('ORG_ID', 204, 'SITE');
8.FND_PROFILE.INITIALIZE :This is used by internal Applications Object Library to initialize the internal profile information at the level context.
The cache is first cleared of all database options.
Example:
- fnd_profile.initialize(user_id);
9.FND_PROFILE.PUTMULTIPLE :This is used by internal Applications Object Library to set multiple pairs of profile options and values.
Most Useful Oracle Apps Articles:
- Types Of Tables In Oracle Applications
- Oracle Applications Technical Questions And Answers
- Oracle Apps AOL and Sysadmin Interview Questions And Answers
- Oracle Apps AR Module Interview Questions And Answers
- Oracle Financials Interview Questions And Answers
- Oracle Purchasing Interview Questions And Answers
- Oracle R12 Tables and Views Changes
- Purpose of MO_GLOBAL.SET_POLICY_CONTEXT
COMMENTS