• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » User Preferences of your E-Business Suite homepage

User Preferences of your E-Business Suite homepage

December 18, 2015 by techgoeasy Leave a Comment

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

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: User Preferences of your E-Business Suite homepage

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us