管理多个Oracle应用环境,并且目前通过在每个环境中加载表单来检查配置文件选项,并手动检查每个变量,这需要大量时间。
是否有一段代码可以列出配置文件选项,以及在什么级别和适用对象?
发布于 2018-05-28 14:34:42
你会想要查询APPLSYS.FND_PROFILE_OPTIONS
和FND_PROFILE_OPTION_VALUES
。
有关可从中获取SQL的综合脚本,请查看:http://tipsnscripts.com/?p=16
发布于 2018-05-28 16:02:48
我希望这可以帮助在尝试追踪用户的更改时获得更细化的信息。
SELECT FP.LEVEL_ID "Level ID",
FPO.PROFILE_OPTION_NAME "PROFILE NAME",
FP.LEVEL_VALUE "LEVEL VALUE",
DECODE (FP.LEVEL_ID,
10001,
'SITE',
10002,
'APPLICATION',
10003,
'RESPONSIBILITY',
10004,
'USER')
"LEVEL",
DECODE (FP.LEVEL_ID,
10001,
'SITE',
10002,
APPLICATION_SHORT_NAME,
10003,
RESPONSIBILITY_NAME,
10004,
FL.USER_NAME)
LVALUE,
FPO.USER_PROFILE_OPTION_NAME "PROFILE DESCRIPTION",
FP.PROFILE_OPTION_VALUE "PROFILE VALUE",
FU.USER_NAME "USER NAME",
FU.LAST_UPDATE_DATE
FROM FND_PROFILE_OPTIONS_VL FPO,
FND_PROFILE_OPTION_VALUES FP,
FND_RESPONSIBILITY_TL,
FND_APPLICATION FA,
FND_USER FL,
FND_USER FU
WHERE FPO.APPLICATION_ID = FP.APPLICATION_ID
AND FPO.PROFILE_OPTION_ID = FP.PROFILE_OPTION_ID
AND FP.LEVEL_VALUE = FL.USER_ID(+)
AND FP.LEVEL_VALUE = RESPONSIBILITY_ID(+)
AND FP.LEVEL_VALUE = FA.APPLICATION_ID(+)
AND FU.USER_ID = FP.LAST_UPDATED_BY
AND FP.PROFILE_OPTION_VALUE IS NOT NULL
AND (UPPER (FP.Profile_Option_Value) LIKE UPPER ('%&1%')
OR UPPER (FP.Profile_Option_Value) LIKE UPPER ('%&2%'))
https://stackoverflow.com/questions/-100000116
复制相似问题