Definition and use of EBS Profile

Definition of EBS profiles

In EBS, we may define a profile to store specific user information so thatProgramRunning. It is equivalent to a global variable.

1. Profile Definition

Path: Application Developer/Profile

Hierarchy type is used to determine the scope of the profile. Select security.

Profile takes precedence over the underlying layer, that is, the user layer takes precedence over organization ....

Profile information is often extracted based on responsibility.

SQLValidation is used to define the value set of Profile Value. Of course it is not defined, and manual input is fine. However, to ensure security, it is better to define a method as follows:

SQL = "select fv_region.flex_value \" log mode \",

Fv_region.flex_value

Into: visible_option_value,

: Profile_option_value

From fnd_flex_value_sets fvs_region,

Fnd_flex_values fv_region

Where fvs_region.flex_value_set_name = 'fac _ reorg_asset_region'

And fvs_region.flex_value_set_id = fv_region.flex_value_set_id

And fv_region.enabled_flag = 'y '"

Column = "\" log mode \ "(10 )"

2. Profile Maintenance

Path: System Administrator/profile/System

You can assign values to the corresponding profile at the site/application/responsibility/organization/user layer as needed.