Profile Options in Oracle Apps / EBS

Posted on by

What is Profile Options in Oracle  Apps/EBS:

In Oracle EBS System Administrators control various profile options in Oracle Application that determine how the application look, feel, and operate.

You can set user profiles at different levels by using one of the three hierarchies.

1) Security
2) Organization
3) Server

Security Levels Profile

Most profile options use the Security hierarchy, In which setting a user profile effects application users across one of the four different levels.

  • Site Level :  Setting apply to all users at an installation site.
  • Application Level : All users of specific application and will override the site level.
  • Responsibility Level : All users currently signed in under the responsibility and will override the options set at the site and application levels.
  • User Level : Applies to user level and will override all other options

Organization Levels Profile

The second hierarchy type is Organization, where organization refers to an Operating Unit. For example, clerks in different organizations may need to have different values for a given profile option, depending on their organization, but clerks in the same organization would use the same value.

profiles using the Organization type use the hierarchy Site – Organization – user, where a user level option overrides the organization-level option, which, in turn, overrides the site-level option.

Profile Hierarchy Levels : Server

The Server hierarchy type is used when the  the system needs to determine the server on which the user’s session is running.  For example, the profile  “Applications Web Agent” can be defined using the Server hierarchy type. The setting of this profile option can differ for an internal server and an external one.

Personal Profile Values

Depending on the responsibility, many users can change their personal options:

Q: How to set profile Options?

Q: How to change look and feel / background color of Forms in oracle EBS / R12.

  • Responsibility = System Administrator
  • Profile > Personal
  • Find the Profile value  “Color” in the screen as follows:
  • Press F11
  • Profile Name = %Color %
  • Press Ctrl + F11
  • Select “Java Color Scheme” from the list of Values.
  • User Value = Khaki (Select from LOV)
  • Save
  • Close Form
  • Log Out from the user.
  • Re login and open any form. you will see that color scheme has been changed as you selected khaki.

 

Recommended Book



 

Other Profile Values Examples

Q : Open Key Flex Field Window / Form Automatically in Oracle APPS.

Q: Which profile option will be used for Opening Key Flex Field Window Automatically in Oracle Apps.

Q: How to Open Item Key Flex Filed Window Automatically in Item Master Form in Oracle Apps.

  • Responsibility = System Administrator / Application Developer
  • Profile > Personal
  • Press F11
  • Profile Name = Flexfields:Open Key Window
  • Press Ctrl + F11
  • User Value = Yes
  • Save
  • Navigate to Item Master and you will notice that Item Number Flexfield window open Automatically.
  • Now if you Navigate to any Key Flexfield you will notice that Key flex filed window will open automatically.

Q: Open Descriptive Flex Field Window / Form Automatically.

Q: Which profile option will be used for Opening Descriptive Flex Field Window Automatically.

  • Responsibility = System Administrator / Application Developer
  • Profile > Personal
  • Press F11
  • Profile Name = Flexfields: Open Descr Window
  • Press Ctrl + F11
  • User Value = Yes
  • Save
  • Now if you Navigate to any Descriptive Flexfield you will notice that Descriptive flex filed window will open automatically.