Setting System Profile Options

Oracle Applications establishes a value for user profile options when a user signs on or changes responsibility. Use this procedure to view or set a profile option value.

Steps

In the Navigator window, on the Functions tab, choose Profile > System.

The Find System Profile Values window appears. The Site and Profile with No Values boxes are selected by default.

Select the level at which you want to view or set the profile option value. You have the following options:

Level  Description

Site    ::  View or set profile option values for all users.

Application ::          View or set profile option values for users working under responsibilities owned by a specific application. Select an application from the list.

Responsibility ::    View or set profile option values for users working under a specific responsibility. Select a responsibility from the list.

User ::           View or set profile option values for a specific user. Select the username from the list.

If you want to display profile options both with and without values, select the Profiles with No Values box.

If you want to display profile options that include a specific character string, enter the string in the Profile field.

You may search for profile options using character strings and the wildcard symbol (%).For example, to find profile options prefixed by "IEU," the product code for Oracle Universal Work Queue, enter IEU%.

Click Find.

The System Profile Values window appears.

Set the values for the profile options at one or more levels.

When a profile option may be set at more than one level, the value entered at the Site level has the lowest priority.The value entered at the Site level is superseded by any value entered at the Application level value and the value entered at the Application level is superseded by any value entered at the Responsibility level.The value entered at the User level has the highest priority and overrides values entered at any other level.

Your changes take effect as soon as users sign on or change responsibility.

Checking the profile option name and profile id  from the backend for particular profile name

select profile_option_id,profile_option_name,user_profile_option_name  from fnd_profile_options_vl  where user_profile_option_name like '%OIC%%SQL%Loader%Control%File%Directory%';

To check the number of values set for for profile option

select count(*)  from fnd_profile_option_values where PROFILE_OPTION_ID= 5614;

So here only one profile option is set so the count is only 1.

To check the value assigned to the profile option use below command

Select profile_option_value from fnd_profile_option_values where PROFILE_OPTION_ID=5614;

To update the profile option at site,user,organization,resposibilty,server,application level user below 

Site =10001

Application=10002

Resposibilty=10003

User =10004

SQL>update fnd_profile_option_values set PROFILE_OPTION_VALUE='xyz'

where PROFILE_OPTION_ID=5614 and LEVEL_ID=10002;