add_action('wp_footer', function () { echo ''; }, 99);
{"id":790,"date":"2014-12-04T15:38:18","date_gmt":"2014-12-04T12:38:18","guid":{"rendered":"https:\/\/enginhafizoglu.com\/?p=790"},"modified":"2026-09-13T02:03:12","modified_gmt":"2026-09-12T23:03:12","slug":"oracle-ebs-profile-values-for-any-level","status":"publish","type":"post","link":"https:\/\/enginhafizoglu.com\/?p=790","title":{"rendered":"Oracle EBS Profile Values for any level"},"content":{"rendered":"
If you get curios which level has a profile value, that’s the answer.<\/strong><\/p>\n\n\n<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>SELECT<\/span> SUBSTR (E.PROFILE_OPTION_NAME, <\/span>1<\/span>, <\/span>25<\/span>) PROFILE_NAME,<\/span><\/span>\nSUBSTR (POT.USER_PROFILE_OPTION_NAME, <\/span>1<\/span>, <\/span>60<\/span>) USER_PROFILE_NAME,<\/span><\/span>\nDECODE (A.LEVEL_ID,<\/span><\/span>\n10001<\/span>, <\/span>'<\/span>Site<\/span>'<\/span>,<\/span><\/span>\n10002<\/span>, <\/span>'<\/span>Application<\/span>'<\/span>,<\/span><\/span>\n10003<\/span>, <\/span>'<\/span>Responsibility<\/span>'<\/span>,<\/span><\/span>\n10004<\/span>, <\/span>'<\/span>User<\/span>'<\/span>,<\/span><\/span>\n10006<\/span>, <\/span>'<\/span>Organization<\/span>'<\/span>,<\/span><\/span>\n10005<\/span>, <\/span>'<\/span>Server<\/span>'<\/span>,<\/span><\/span>\n10007<\/span>, <\/span>'<\/span>Server+Resp<\/span>'<\/span>,<\/span><\/span>\nA.LEVEL_ID)<\/span><\/span>\nWHICH_LEVEL,<\/span><\/span>\nDECODE (A.LEVEL_ID,<\/span><\/span>\n10001<\/span>, <\/span>'<\/span>Site<\/span>'<\/span>,<\/span><\/span>\n10002<\/span>, C.APPLICATION_SHORT_NAME,<\/span><\/span>\n10003<\/span>, B.RESPONSIBILITY_NAME,<\/span><\/span>\n10004<\/span>, D.USER_NAME,<\/span><\/span>\n10005<\/span>, N.NODE_NAME,<\/span><\/span>\n10006<\/span>, HAOU.NAME,<\/span><\/span>\n10007<\/span>, M.NODE_NAME <\/span>||<\/span> <\/span>'<\/span> + <\/span>'<\/span> <\/span>||<\/span> B.RESPONSIBILITY_NAME,<\/span><\/span>\nA.LEVEL_ID)<\/span><\/span>\nLEVEL_VALUE,<\/span><\/span>\nNVL (A.PROFILE_OPTION_VALUE, <\/span>'<\/span>Is Null<\/span>'<\/span>) PROFILE_VALUE,<\/span><\/span>\nTO_CHAR (A.LAST_UPDATE_DATE, <\/span>'<\/span>DD-MON-YYYY HH24:MI<\/span>'<\/span>) LAST_UPDATE_DATE,<\/span><\/span>\nDD.USER_NAME LAST_UPDATE_USER<\/span><\/span>\nFROM<\/span> APPLSYS.FND_PROFILE_OPTION_VALUES A,<\/span><\/span>\nAPPLSYS.FND_RESPONSIBILITY_TL B,<\/span><\/span>\nAPPLSYS.FND_APPLICATION C,<\/span><\/span>\nAPPLSYS.FND_USER D,<\/span><\/span>\nAPPLSYS.FND_PROFILE_OPTIONS E,<\/span><\/span>\nAPPLSYS.FND_NODES N,<\/span><\/span>\nAPPLSYS.FND_NODES M,<\/span><\/span>\nAPPLSYS.FND_RESPONSIBILITY_TL X,<\/span><\/span>\nAPPLSYS.FND_USER DD,<\/span><\/span>\nAPPLSYS.FND_PROFILE_OPTIONS_TL POT,<\/span><\/span>\nAPPS.HR_ALL_ORGANIZATION_UNITS_VL HAOU<\/span><\/span>\nWHERE<\/span> <\/span>1<\/span> <\/span>=<\/span> <\/span>1<\/span><\/span>\nAND<\/span> E.PROFILE_OPTION_NAME <\/span>=<\/span> <\/span>'<\/span>&XXXXXX<\/span>'<\/span><\/span>\nAND<\/span> E.PROFILE_OPTION_NAME <\/span>=<\/span> POT.PROFILE_OPTION_NAME(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> E.PROFILE_OPTION_ID <\/span>=<\/span> A.PROFILE_OPTION_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE <\/span>=<\/span> B.RESPONSIBILITY_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE <\/span>=<\/span> C.APPLICATION_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE <\/span>=<\/span> D.USER_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE <\/span>=<\/span> N.NODE_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE <\/span>=<\/span> HAOU.ORGANIZATION_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE_APPLICATION_ID <\/span>=<\/span> X.RESPONSIBILITY_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LEVEL_VALUE2 <\/span>=<\/span> M.NODE_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> A.LAST_UPDATED_BY <\/span>=<\/span> DD.USER_ID(<\/span>+<\/span>)<\/span><\/span>\nAND<\/span> POT.LANGUAGE <\/span>=<\/span> <\/span>'<\/span>US<\/span>'<\/span><\/span>\n