Preliminary Study on configuration files in EBS

The configuration file (profile) plays an important role in EBS system configuration. The function consultant must be familiar with many important configuration files. Otherwise, a problem may occur. after a long time of being depressed, it may be found that some inconspicuous configuration file is in disorder. The configuration file is equivalent to a parameter with permission Level Control. Its role area is restricted by its permission settings.

First, I learned about the configuration file from the background.

-- Query the configuration of configuration files in the system
Select op. profile_option_id,
TL. profile_option_name,
TL. user_profile_option_name,
LV. level_id,
LV. file security,
Va. level_value,
Case
When va. level_id = 10001 then 'location'
When va. level_id = 10002 then (select fav. application_name
From fnd_application_vl fav
Where fav. application_id = va. level_value)
When va. level_id = 10003 then (select/* $ header $ */
T. responsibility_name
From fnd_responsibility_tl t,
Fnd_responsibility B
Where T. responsibility_id = va. level_value
And T. responsibility_id = B. responsibility_id
And B. application_id = T. application_id
And nvl (B. end_date, sysdate + 1) & gt; sysdate
And nvl (B. start_date, sysdate-1) <sysdate
And T. Language = 'zhs ')
When va. level_id = 10004 then (select user_name
From fnd_user
Where user_name not in
('* Anonymos *',
'Version ',
'Initial ',
'Feeder system ',
'Current Manager ',
'Standalone batch Process ')
And user_id = va. level_value
And nvl (end_date, sysdate + 1)> sysdate
And nvl (start_date, sysdate-1) & lt; sysdate)
When va. level_id = 10005 then (select node_name from fnd_nodes where node_id = va. level_value)
When va. level_id = 10006 then (Select name
From hr_operating_units
Where organization_id = va. level_value)
Else
''
End as profile_level_value,
Va. profile_option_value
From fnd_profile_options_tl TL,
Fnd_profile_options op,
Fnd_profile_option_values va,
(Select 10001 level_id, 'location' file security
From dual
Union
Select 10002 level_id, 'application product' file security
From dual
Union
Select 10003 level_id, 'response' file security
From dual
Union
Select 10004 level_id, 'users' file security
From dual
Union
Select 10005 level_id, 'server' file security
From dual
Union
Select 10006 level_id, 'org 'file security
From dual) LV
Where tl. Language = 'zhs'
And tl. profile_option_name = op. profile_option_name
And va. profile_option_id = op. profile_option_id
And va. level_id = lv. level_id
-- And TL. profile_option_name like '%'
-- And TL. user_profile_option_name like '%'
Bytes ------------------------------------------------------------------------------------------------------------------------
-- Query System Configuration File Creation
Select profile_option_name configuration file name,
User_profile_option_name user configuration file name,
Description,
Hierarchy_type,
Site_enabled_flag location is visible,
Site_update_allowed_flag location can be updated,
App_enabled_flag application product visible,
App_update_allowed_flag application products can be updated,
Resp_enabled_flag responsibility is visible,
Resp_update_allowed_flag responsibility can be updated,
Server_enabled_flag server visible,
Server_update_allowed_flag server updatable,
Serverresp_enabled_flag server responsibilities are visible,
Serverresp_update_allowed_flag server responsibilities can be updated,
Org_enabled_flag tissue visibility,
Org_update_allowed_flag organizations can be updated,
User_enabled_flag visible to users,
User_update_allowed_flag users can update,
Start_date_active effective start date,
End_date_active effective end date,
User_visible_flag user access can be viewed,
User_changeable_flag user access is updatable,
Read_allowed_flag readable,
Write_allowed_flag writable,
SQL _validation SQL verification,
Profile_option_id configuration file configuration ID
From fnd_profile_options_vl
-- Where (profile_option_name like '% ')
Bytes -------------------------------------------------------------------------------------------------------------------------
-- "Edit"-"Preferences"-"configuration file" configurations available in the menu
If you set the configuration file
User Access-you can view and check the configuration file in the menu.
User Access-you can modify the configuration file in the menu after the update check is completed.

Bytes -----------------------------------------------------------------------------------

 

This article from: http://hi.erp100.com/space.php? Uid = 131 & Do = Blog & id = 6761339