Thursday, May 26, 2011

PROFILE OPTIONS IN ORACLE APPS R12 - OVERVIEW (FND PROFILE)

 Definition:

Profiles are the changeable options which affect the way Oracle Application runs. Moreover, Moreover, The profile option acts like a Global Variable in Oracle. It is needed to provide the flexibility to Oracle Applications.

Types:

The profiles are of two types those are given below.
1. System Profile and
2. User Profile.

About DIFFERENT LEVELS a Profile value can be set:

The Profile values will be set in different levels those are given below.
1. Site
2. Application
3. Responsibility
4. User
5. Server
6. Organization

Site: This field displays the current value, if set, for all users at the installation site.
Application: This field displays the current value, if set, for all users working under responsibilities owned by the application identified in the Find Profile Values block.
Responsibility: This field displays the current value, if set, for all users working under the responsibility identified in the Find Profile Values block.
User: This field displays the current value, if set, for the application user identified in the Find Profile Values block.
Profile: Enter the name of the profile option whose values you wish to display.

Navigation to set Profile Values

 SYSTEM PROFILE: 

Responsibility SYSTEM ADMINISTRATOR -->


You may search for profile options using character strings and the wildcard symbol (%). For example, to find all the profile options prefixed by "Concurrent:” you could enter "Conc%" and press the Find button.


  
PERSONAL PROFILE:

Responsibility SYSTEM ADMINISTRATOR -->

To view personal profiles enter into the query mode and enter the profile name which we have already then we get profile value details.



To check the validation done against the Profile value while setting:

Responsibility APPLICATION DEVELOPER -->




Use of the API FND_PROFILE

It is used to perform various actions related to profile values through PL/SQL. Some of the important ones are listed below

1. FND_PROFILE.GET(‘Name of the Profile’, variable name);
Example
SELECT fnd_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 of the profile’);
3. FND_PROFILE.PUT(‘Name of the profile’, value of the profile);

Example
SET SERVEROUTPUT 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/SQL procedure successfully completed

The 1st and 2nd are same but, the only difference is FND_PROFILE.GET is the procedure and FND_PROFILE.VALUE is the function so, it return a value.  

Apart from the above procedures we have another important one named FND_PROFILE .SAVE used to set the profile values from backend. A detail regarding this API is available in another article. 

12 Responses to “PROFILE OPTIONS IN ORACLE APPS R12 - OVERVIEW (FND PROFILE)”

Anonymous said...
June 5, 2011 at 1:15 AM

Nice Consolidation of details.. It is very much useful for me. Thank you very much!!

Regards,
Patrick


Anonymous said...
October 17, 2011 at 9:38 PM

Much useful topic,thanq.

Regards,
Divya


Ramakrishna said...
October 20, 2011 at 5:52 PM

It is very useful information,

Thanks,
Ramakrishna


Anonymous said...
April 24, 2012 at 1:28 AM

very useful
thanks
madhu


Anonymous said...
May 29, 2012 at 9:24 AM

very useful


Anonymous said...
July 2, 2012 at 12:08 AM

thank u so much for giving this brief explanation............


Anonymous said...
November 28, 2012 at 4:03 AM

nyc 1..


Anand said...
December 12, 2012 at 11:43 PM

Thank you so much for such an useful information.

Can anyone please give me the difference between System profiles and user profiles and what is the signifiance of both.

It could be better to understand if you given.

Thanks
Anand


Anonymous said...
February 15, 2013 at 9:12 AM

Nice work , very helpful.






Nura


jabeen said...
February 19, 2013 at 10:55 PM

thank you so much gave me such a good information


Anonymous said...
April 30, 2013 at 4:50 AM

hey hi,
Nice Post regarding profile options
I am facing some issue with related to profile options
When i tried to modified system profile option is site level,
i got error message
FRM-40200 :Field is protected against update

please let me know if any solution


Unknown said...
December 20, 2013 at 9:17 AM

thank you


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.