以下脚本可以用来在EBS中查找特定profile option的设置,sql中,查找的profile option为并发%OPP%

sqlSELECT FPOT.USER_PROFILE_OPTION_NAME,
       DECODE(FPOV.LEVEL_ID,
              10001,
              'Site',
              10002,
              'Application',
              10003,
              'Responsibility',
              10004,
              'User',
              10005,
              'Server',
              10006,
              'Org',
              10007,
              DECODE(TO_CHAR(FPOV.LEVEL_VALUE2),
                     '-1',
                     'Responsibility',
                     DECODE(TO_CHAR(FPOV.LEVEL_VALUE),
                            '-1',
                            'Server',
                            'Server+Resp')),
              'UnDef'),
       DECODE(TO_CHAR(FPOV.LEVEL_ID),
              '10001',
              '',
              '10002',
              APP.APPLICATION_SHORT_NAME,
              '10003',
              RSP.RESPONSIBILITY_KEY,
              '10004',
              USR.USER_NAME,
              '10005',
              SVR.NODE_NAME,
              '10006',
              ORG.NAME,
              '10007',
              DECODE(TO_CHAR(FPOV.LEVEL_VALUE2),
                     '-1',
                     RSP.RESPONSIBILITY_KEY,
                     DECODE(TO_CHAR(FPOV.LEVEL_VALUE),
                            '-1',
                            (SELECT NODE_NAME
                               FROM FND_NODES
                              WHERE NODE_ID = FPOV.LEVEL_VALUE2),
                            (SELECT NODE_NAME
                               FROM FND_NODES
                              WHERE NODE_ID = FPOV.LEVEL_VALUE2) || '-' ||
                            RSP.RESPONSIBILITY_KEY)),
              'UnDef') "CONTEXT",
       FPOV.PROFILE_OPTION_VALUE,
       FPOT.DESCRIPTION
  FROM FND_PROFILE_OPTIONS_TL    FPOT,
       FND_PROFILE_OPTIONS       FPO,
       FND_PROFILE_OPTION_VALUES FPOV,
       FND_USER                  USR,
       FND_APPLICATION           APP,
       FND_RESPONSIBILITY        RSP,
       FND_NODES                 SVR,
       HR_OPERATING_UNITS        ORG
 WHERE 1 = 1
   AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
   AND FPO.PROFILE_OPTION_NAME = FPOT.PROFILE_OPTION_NAME
   AND FPOT.LANGUAGE = 'ZHS'
   AND FPOT.USER_PROFILE_OPTION_NAME LIKE '并发%OPP%'
   AND USR.USER_ID(+) = FPOV.LEVEL_VALUE
   AND RSP.APPLICATION_ID(+) = FPOV.LEVEL_VALUE_APPLICATION_ID
   AND RSP.RESPONSIBILITY_ID(+) = FPOV.LEVEL_VALUE
   AND APP.APPLICATION_ID(+) = FPOV.LEVEL_VALUE
   AND SVR.NODE_ID(+) = FPOV.LEVEL_VALUE
   AND ORG.ORGANIZATION_ID(+) = FPOV.LEVEL_VALUE
;

花菜土豆粉
67 声望27 粉丝

Life with Oracle