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.