User Preferences of your E-Business Suite homepage



Last updated on September 11th, 2016 at 12:00 pm

In this post we will be talking about  User Preferences of your E-Business Suite homepage

We know that User Preferences link at the right top of your E-Business Suite homepage.

apps_preferences

On this page the users can change some of the behaviour, number and date formats of their Oracle E-Business Suite sessions.

apps_preferences2
Users can make the changes to there prefreneces according to the need to override the default values.
E-Business Suite maintains these changes as Profile Options on the specific user level.

Below is explanation of each
Default Application Language
Profile Option Name: ICX_LANGUAGE
User Profile Option Name: ICX: Language

Accessibility Features
Profile Option Name: ICX_ACCESSIBILITY_FEATURES
User Profile Option Name: Self Service Accessibility Features

Territory
Profile Option Name: ICX_TERRITORY
User Profile Option Name: ICX: Territory

Date Format
Profile Option Name: ICX_DATE_FORMAT_MASK
User Profile Option Name: ICX: Date format mask

Timezone
Profile Option Name: CLIENT_TIMEZONE_ID
User Profile Option Name: Client Timezone

Number Format
Profile Option Name: ICX_NUMERIC_CHARACTERS
User Profile Option Name: ICX: Numeric characters
Currency
Profile Option Name: ICX_PREFERRED_CURRENCY and JTF_PROFILE_DEFAULT_CURRENCY
User Profile Option Name: ICX: Preferred Currency and JTF_PROFILE_DEFAULT_CURRENCY
Client Character Encoding
Profile Option Name: FND_NATIVE_CLIENT_ENCODING
User Profile Option Name: FND: NATIVE CLIENT ENCODING
Start Page
Profile Option Name: APPLICATIONS_START_PAGE
User Profile Option Name: Applications Start page

We can find all these setup done by the user by using the below profile query

set linesize 140
set pagesize 132
column SHORT_NAME format A30
column NAME format A40
column LEVEL_VAL format 999999999
column VALUE format A60 wrap
set lines 200;
col SHORT_NAME format a25;
col NAME format a40;
col VALUE format a30;
col LEVEL_SET format a10;
col USER format a10;
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’,
10006,’Organization’,
‘UnDef’) LEVEL_SET,
fu.user_name “USER”,
v.level_value LEVEL_VAL,
v.profile_option_value VALUE ,
to_char(v.LAST_UPDATE_DATE,’DD-MON-YYYY:hh24:mi:ss’) “Update Time”
from apps.fnd_profile_options p,
apps.fnd_profile_option_values v,
apps.fnd_profile_options_tl n,
apps.fnd_user fu
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
AND fu.user_id(+) = v.level_value
and v.level_id= 10004
and upper(fu.USER_NAME) like upper(‘%&username%’);

Important Note
APPLICATIONS_START_PAGE profile can create lot of issues .if your responsibility is removed, you wont be able to login


Leave a Reply