API of Profiles

Muhammad Rafi Aamiri on Saturday, July 4, 2009

Inside 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 this API'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 has been 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 profile option

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 retrieve the 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 option without caching it.

6.SAVE_USER :This is function 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. Returns TRUE if profile option is successfully saved, otherwise FALSE.

7.SAVE :This is function 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. Returns TRUE if profile option is successfully saved, otherwise FALSE.

Usage

  • fnd_profile.save('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');

8.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.

Usage:

  • fnd_profile.initialize(user_id);

9.PUTMULTIPLE :This is used by internal Applications Object Library to set multiple pairs of profile options and values.