Fans Or Not

配置文件“自助个人主页模式”里面可以选择自己喜欢的首页模式，但是它现在已经不被支持了。

Oracle技术架构体系中，将逐渐取消对MOD_PLSQL的支持，这是一种被淘汰的技术。所有基于MOD_PLSQL的UI都将被移除Oracle应用，在新的发布中，你将不再看到有MOD_PLSQL的应用。“个人主页”模式正是基于这种技术。

你可以用下面的SQL找出所有还在使用“个人主页”模式的用户。

SELECT pro.profile_option_name,
       pro.user_profile_option_name,
       lev.level_type TYPE,
       lev.level_name,
       prv.profile_option_value
  FROM fnd_profile_options_vl pro,
       fnd_profile_option_values prv,
       (SELECT 10001 level_id,
               'Site' level_type,
               0 level_value,
               'Site' level_code,
               'Site' level_name
          FROM dual
        UNION ALL
        SELECT 10002 level_id,
               'App' level_type,
               app.application_id level_value,
               app.application_short_name level_code,
               app.application_name level_name
          FROM apps.fnd_application_vl app
        UNION ALL
        SELECT 10003 level_id,
               'Resp' level_type,
               resp.responsibility_id level_value,
               resp.responsibility_key level_code,
               resp.responsibility_name level_name
          FROM apps.fnd_responsibility_vl resp
        UNION ALL
        SELECT 10004 level_id,
               'User' level_type,
               usr.user_id level_value,
               usr.user_name level_code,
               usr.user_name level_name
          FROM applsys.fnd_user usr) lev
 WHERE pro.profile_option_id = prv.profile_option_id(+)
   AND prv.level_id = lev.level_id(+)
   AND prv.level_value = lev.level_value(+)
   AND pro.user_profile_option_name = '自助个人主页模式'
   --AND lev.level_name = 'User'
 ORDER BY pro.profile_option_name,
          lev.level_type,
          lev.level_name;

Metalink: 368628.1