FND_PROFILE API In Oracle Apps

 FND_PROFILE API In Oracle Apps

---------------------------------------------------------------------------------------------------

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:

1.           Types Of Tables In Oracle Applications

2.           Oracle Applications Technical Questions And Answers

3.           Oracle Apps AOL and Sysadmin Interview Questions And Answers

4.           Oracle Apps AR Module Interview Questions And Answers

5.           Oracle Financials Interview Questions And Answers

6.           Oracle Purchasing Interview Questions And Answers

7.           Oracle R12 Tables and Views Changes

8.           Purpose of MO_GLOBAL.SET_POLICY_CONTEXT

---------------------------------------------------------------------------------------------------