对EBS中配置文件的初步认识

配置文件(PROFILE)在EBS系统配置占有很重要的位置，功能顾问要对很多重要的配置文件做到非常熟悉才行。否则出现一个问题，可能在郁闷许久后，发觉只是某个不起眼的配置文件在捣乱。配置文件相当于带有权限层次控制的参数，它的作用区域由它的权限设置信息来进行相应限制。

先从后台了解了一下配置文件。

--查询系统中配置文件的配置情况

SELECT OP.PROFILE_OPTION_ID,
TL.PROFILE_OPTION_NAME,
TL.USER_PROFILE_OPTION_NAME,
LV.LEVEL_ID,
LV.文件安全性,
VA.LEVEL_VALUE,
CASE
WHEN VA.LEVEL_ID = 10001 THEN '地点'
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) > 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*',
'CONVERSION',
'INITIAL SETUP',
'FEEDER SYSTEM',
'CONCURRENT MANAGER',
'STANDALONE BATCH PROCESS')
AND USER_ID = VA.LEVEL_VALUE
AND NVL(END_DATE, SYSDATE + 1) > SYSDATE
AND NVL(START_DATE, SYSDATE - 1) <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, '地点' 文件安全性
FROM DUAL
UNION
SELECT 10002 LEVEL_ID, '应用产品' 文件安全性
FROM DUAL
UNION
SELECT 10003 LEVEL_ID, '责任' 文件安全性
FROM DUAL
UNION
SELECT 10004 LEVEL_ID, '用户' 文件安全性
FROM DUAL
UNION
SELECT 10005 LEVEL_ID, '服务器' 文件安全性
FROM DUAL
UNION
SELECT 10006 LEVEL_ID, '组织' 文件安全性
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 '%'

------------------------------------------------------------------------------------------------------------------------

--查询系统中配置文件的创建情况

SELECT profile_option_name            配置文件名,
       user_profile_option_name       用户配置文件名,
       description                    说明,
       hierarchy_type                 层次结构类型,
       site_enabled_flag              地点可见,
       site_update_allowed_flag       地点可更新,
       app_enabled_flag               应用产品可见,
       app_update_allowed_flag        应用产品可更新,
       resp_enabled_flag              责任可见,
       resp_update_allowed_flag       责任可更新,
       server_enabled_flag            服务器可见,
       server_update_allowed_flag     服务器可更新,
       serverresp_enabled_flag        服务器职责可见,
       serverresp_update_allowed_flag 服务器职责可更新,
       org_enabled_flag               组织可见,
       org_update_allowed_flag        组织可更新,
       user_enabled_flag              用户可见,
       user_update_allowed_flag       用户可更新,
       start_date_active              有效起始日期,
       end_date_active                有效截止日期,
       user_visible_flag              用户访问可查看,
       user_changeable_flag           用户访问可更新,
       read_allowed_flag              可读,
       write_allowed_flag             可写,
       sql_validation                 sql验证,
       profile_option_id              配置文件配置情况id
  FROM fnd_profile_options_vl
--WHERE (PROFILE_OPTION_NAME LIKE '%')

-------------------------------------------------------------------------------------------------------------------------
--菜单“编辑”－“首选项”－“配置文件”可使用的配置
如果将配置文件设置中
用户访问－可查看打勾则在该菜单中可以看到该配置文件
用户访问－可更新打勾则在该菜单中可以修改该配置文件

-----------------------------------------------------------------------------------

本文转自 http://blog.csdn.net/meteorlWJ/article/details/4551303