Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Oracle API Availability – Profile

Posted on July 25th, 2007 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

In oracle user Profile functionality is provided in the 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 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.

Related Posts

Posted in API Integration | 5 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
5 Responses
  1. AOL : Valueset - Advanced Validation Options Says:

    […] A list of available Profile options can be found in one of the last post. […]

  2. Elena Says:

    Hi,
    I’m loooking for the USER_PROFILE_OPTION_NAME
    of USERNAME and RESP_NAME.
    How can I find them in the OAP? or usign select?

    thanks
    Lena

  3. Sanjit Anand Says:

    I did not get you completly.

    do u mean ,

    Select PROFILE_OPTION_NAME From FND_PROFILE_OPTIONS_TLWhere USER_PROFILE_OPTION_NAME Like ‘%Lena%’;

    If you are looking for sql, try this

    select p.profile_option_name SHORT_NAME,
    n.user_profile_option_name NAME,
    decode(v.level_id,
    10001, 'Site',
    10002, 'Application',
    10003, 'Responsibility',
    10004, 'User',
    10005, 'Server',
    'UnDef') LEVEL_SET,
    decode(to_char(v.level_id),
    '10001', '',
    '10002', app.application_short_name,
    '10003', rsp.responsibility_key,
    '10005', svr.node_name,
    '10006', org.name,
    '10004', usr.user_name,
    'UnDef') "CONTEXT",
    v.profile_option_value VALUE
    from fnd_profile_options p,
    fnd_profile_option_values v,
    fnd_profile_options_tl n,
    fnd_user usr,
    fnd_application app,
    fnd_responsibility rsp,
    fnd_nodes svr,
    hr_operating_units org
    where p.profile_option_id = v.profile_option_id (+)
    and p.profile_option_name = n.profile_option_name
    and usr.user_id (+) = v.level_value
    and rsp.application_id (+) = v.level_value_application_id
    and rsp.responsibility_id (+) = v.level_value
    and app.application_id (+) = v.level_value
    and svr.node_id (+) = v.level_value
    and org.organization_id (+) = v.level_value
    and n.user_profile_option_name IN ('&User_Profile_Option_Name')
    order by short_name
    
    
  4. Sanjit Anand Says:

    try this which is itemzied for each level..modify if you required

    
    select lpad(fpo.profile_option_name,55) pon 
    	, lpad(fpot.user_profile_option_name,55) upon 
    	, fpot.description d 
    	, lpad(fpo.start_date_active,15) sda 
    	, lpad(fpo.end_date_active,15) eda 
    	, lpad(fpo.creation_date,15) cd 	
    	, lpad(fu.user_name,20) cb 
    	, 'Site' lo 
    	, 'SITE' lov 
    	, fpov.profile_option_value pov 
    from FND_PROFILE_OPTIONS_TL fpot 
    	, FND_PROFILE_OPTIONS fpo 
    	, FND_PROFILE_OPTION_VALUES fpov 
    	, FND_USER fu 
    where fpot.user_profile_option_name like '&&profile_like' 
    	and fpot.profile_option_name = fpo.profile_option_name 
    	and fpo.application_id = fpov.application_id 
    	and fpo.profile_option_id = fpov.profile_option_id 
    	and fpo.created_by = fu.user_id 
    	and fpot.language = Userenv('Lang') 
    	and fpov.level_id = 10001 /* Site Level */ 
    union all 
    select lpad(fpo.profile_option_name,55) pon 
    	, lpad(fpot.user_profile_option_name,55) upon 
    	, fpot.description d 
    	, lpad(fpo.start_date_active,15) sda 
    	, lpad(fpo.end_date_active,15) eda 
    	, lpad(fpo.creation_date,15) cd 
    	, lpad(fu.user_name,20) cb 
    	, 'Apps' lo 
    	, fa.application_name lov 
    	, fpov.profile_option_value pov 
    from FND_PROFILE_OPTIONS_TL fpot 
    	, FND_PROFILE_OPTIONS fpo 
    	, FND_PROFILE_OPTION_VALUES fpov 
    	, FND_USER fu 
    	, FND_APPLICATION_TL fa 
    where fpot.user_profile_option_name like '&&profile_like' 
    	and fpot.profile_option_name = fpo.profile_option_name 
    	and fpo.profile_option_id = fpov.profile_option_id 
    	and fpo.created_by = fu.user_id 
    	and fpot.language = Userenv('Lang') 
    	and fpov.level_id = 10002 /* Application Level */ 
    	and fpov.level_value = fa.application_id 
    union all 
    select lpad(fpo.profile_option_name,55) pon 
    	, lpad(fpot.user_profile_option_name,55) upon 
    	, fpot.description d 
    	, lpad(fpo.start_date_active,15) sda 
    	, lpad(fpo.end_date_active,15) eda 
    	, lpad(fpo.creation_date,15) cd 
    	, lpad(fu.user_name,20) cb 
    	, 'Resp' lo 
    	, frt.responsibility_name lov 
    	, fpov.profile_option_value pov 
    from FND_PROFILE_OPTIONS_TL fpot 
    	, FND_PROFILE_OPTIONS fpo 
    	, FND_PROFILE_OPTION_VALUES fpov 
    	, FND_USER fu 
    	, FND_RESPONSIBILITY_TL frt 
    where fpot.user_profile_option_name like '&&profile_like' 
    	and fpot.profile_option_name = fpo.profile_option_name 
    	and fpo.profile_option_id = fpov.profile_option_id 
    	and fpo.created_by = fu.user_id 
    	and frt.language = Userenv('Lang') 
    	and fpot.language = Userenv('Lang') 
    	and fpov.level_id = 10003 /*Responsibility Level */ 
    	and fpov.level_value = frt.responsibility_id 
    	and fpov.level_value_application_id = frt.application_id 
    union all 
    select lpad(fpo.profile_option_name,55) pon 
    	, lpad(fpot.user_profile_option_name,55) upon 
    	, fpot.description d 
    	, lpad(fpo.start_date_active,15) sda 
    	, lpad(fpo.end_date_active,15) eda 
    	, lpad(fpo.creation_date,15) cd 
    	, lpad(fu.user_name,20) cb 
    	, 'User' lo 
    	, fu2.user_name lov 
    	, fpov.profile_option_value pov 
    from FND_PROFILE_OPTIONS_TL fpot 
    	, FND_PROFILE_OPTIONS fpo 
    	, FND_PROFILE_OPTION_VALUES fpov 
    	, FND_USER fu 
    	, FND_USER fu2 
    where fpot.user_profile_option_name like '&&profile_like' 
    	and fpot.profile_option_name = fpo.profile_option_name 
    	and fpo.profile_option_id = fpov.profile_option_id 
    	and fpo.created_by = fu.user_id 
    	and fpov.level_id = 10004 /* User Level */ 
    	and fpov.level_value = fu2.user_id 
    	and fpot.language = Userenv('Lang') 
    order by upon, lo, lov
    
    
    
    
       
      
  5. Yoon Says:

    I am looking for the value of
    “FND_PROFILE.VALUE(‘LOGIN_ID’)”.
    Usually we enter this value in “Last Login By” column, but I don’t know the meaning of this value. What is the meaning of this values and where I can modify this value?

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.