blocks|key|2396356|text|查看我的帖子：http://blog.csdn.net/pan_tian/article/details/7652968|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2396357|1.++++List+E-Business+Suite+Profile+Option+Values+For+All+Levels
2.++++How+to+Search+all+of+the+Profile+Options+for+a+Specific+Value
3.++++How+To+Find+All+Users+With+A+Particular+Profile+Option+Set+|code-block|syntax|javascript|2396358|entityMap|0|LINK|mutability|MUTABLE|url|http://blog.csdn.net/pan_tian/article/details/7652968^0|7|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

check my post:<a href="http://blog.csdn.net/pan_tian/article/details/7652968" rel="nofollow">http://blog.csdn.net/pan_tian/article/details/7652968</a>

<pre><code>1. List E-Business Suite Profile Option Values For All Levels
2. How to Search all of the Profile Options for a Specific Value
3. How To Find All Users With A Particular Profile Option Set 
</code></pre>

blocks|key|4030970|text|您是指实际Oracle产品本身的配置文件，还是从您的实现中的实际表中查询这些值？如果它是一个特定的实现，您能说明您正在处理哪些列吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4030971|请验证。|4030972|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Do you mean the profile of actual Oracle product itself, or are you querying these values from an actual table from your implementation? If it is a particular implementation, could you state what columns you are working with?

Please verify.

blocks|key|4122744|text|配置文件选项有几个要搜索的内容：-级别(站点、职责等)-它们的技术名称(ABCDEFGH)+-它们的用户名(设置为...)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4122745|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Profile Options have several things to search on:
- the level (site, responsibility, ...)
- their technical name (ABCDEFGH)
- their user name (setting for ...)

blocks|key|4122772|text|下面的SQL+for+Blitz+Report+FND+Profile+Option+Values应该可以做到这一点。您还可以在该报告的页面上找到用于不同查询场景的附加where-子句。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4122773|SQL还显示通过自定义函数xxen_util.display_profile_option_value()转换的可视配置文件选项值。|4122774|select
fav0.application_name,
fpo.user_profile_option_name,
decode(fpov.level_id,10001,'Site',10002,'Application',+10003,'Responsibility',+10004,'User',+10005,'Server',10006,'Operating+Unit',
10007,decode(to_char(fpov.level_value2),'-1','Responsibility',decode(to_char(fpov.level_value),'-1','Server','Server%2BResp'))
)+level_,
decode(fpov.level_id,10001,null,10002,fav.application_name,10003,frv.responsibility_name,10004,fu.user_name%7C%7Cnvl2(nvl(fu.description,fu.email_address),':+'%7C%7Cnvl(fu.description,fu.email_address),null),10005,fn.node_name,10006,haou.name,
10007,decode(to_char(fpov.level_value2),'-1',frv.responsibility_name,decode(to_char(fpov.level_value),'-1',fn.node_name,fn.node_name%7C%7C'+-+'%7C%7Cfrv.responsibility_name))
)+level_name,
xxen_util.display_profile_option_value(fpo.application_id,fpo.profile_option_id,fpov.profile_option_value)+profile_option_value,
fpov.last_update_date,
fu2.user_name%7C%7Cnvl2(nvl(fu2.description,fu2.email_address),':+'%7C%7Cnvl(fu2.description,fu2.email_address),null)+last_updated_by,
fpov.profile_option_value+system_profile_option_value,
fpo.profile_option_name+system_profile_option_name,
fpo.profile_option_id,
fpov.level_value,
fpov.level_value2
from
fnd_application_vl+fav0,
fnd_profile_options_vl+fpo,
fnd_profile_option_values+fpov,
fnd_responsibility_vl+frv,
fnd_user+fu,
fnd_application_vl+fav,
fnd_user+fu2,
hr_all_organization_units+haou,
fnd_nodes+fn
where
fav0.application_name=:application_name+and
1=1+and
fav0.application_id=fpo.application_id+and
fpo.profile_option_id=fpov.profile_option_id+and
fpo.application_id=fpov.application_id+and
decode(fpov.level_id,10002,fpov.level_value)=fav.application_id(%2B)+and
case+when+fpov.level_id+in+(10003,10007)+then+fpov.level_value+end=frv.responsibility_id(%2B)+and
case+when+fpov.level_id+in+(10003,10007)+then+fpov.level_value_application_id+end=frv.application_id(%2B)+and
decode(fpov.level_id,10004,fpov.level_value)=fu.user_id(%2B)+and
decode(fpov.level_id,10005,fpov.level_value,10007,fpov.level_value2)=fn.node_id(%2B)+and
decode(fpov.level_id,10006,fpov.level_value)=haou.organization_id(%2B)+and
fpov.last_updated_by=fu2.user_id
order+by
fpo.user_profile_option_name,
fpov.level_id,
decode(fpov.level_id,10001,null,10002,fav.application_name,+10003,frv.responsibility_name,+10004,fu.user_name%7C%7Cnvl2(nvl(fu.description,fu.email_address),':+'%7C%7Cnvl(fu.description,fu.email_address),null),+10005,fn.node_name,10006,haou.name)|code-block|syntax|javascript|4122775|entityMap|0|LINK|mutability|MUTABLE|url|https://www.enginatics.com/reports/fnd-profile-option-values/|1|https://www.enginatics.com/xxen_util/true^0|O|P|0|0|D|14|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

Below SQL for Blitz Report <a href="https://www.enginatics.com/reports/fnd-profile-option-values/" rel="nofollow noreferrer">FND Profile Option Values</a> should do the trick. You'll find additional where-clauses for different query scenarios e.g. by profile option value on that report's page as well.

The SQL also shows the visible profile option values translated through custom function <a href="https://www.enginatics.com/xxen_util/true" rel="nofollow noreferrer">xxen_util.display_profile_option_value()</a>.

<pre><code>select
fav0.application_name,
fpo.user_profile_option_name,
decode(fpov.level_id,10001,'Site',10002,'Application', 10003,'Responsibility', 10004,'User', 10005,'Server',10006,'Operating Unit',
10007,decode(to_char(fpov.level_value2),'-1','Responsibility',decode(to_char(fpov.level_value),'-1','Server','Server+Resp'))
) level_,
decode(fpov.level_id,10001,null,10002,fav.application_name,10003,frv.responsibility_name,10004,fu.user_name||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null),10005,fn.node_name,10006,haou.name,
10007,decode(to_char(fpov.level_value2),'-1',frv.responsibility_name,decode(to_char(fpov.level_value),'-1',fn.node_name,fn.node_name||' - '||frv.responsibility_name))
) level_name,
xxen_util.display_profile_option_value(fpo.application_id,fpo.profile_option_id,fpov.profile_option_value) profile_option_value,
fpov.last_update_date,
fu2.user_name||nvl2(nvl(fu2.description,fu2.email_address),': '||nvl(fu2.description,fu2.email_address),null) last_updated_by,
fpov.profile_option_value system_profile_option_value,
fpo.profile_option_name system_profile_option_name,
fpo.profile_option_id,
fpov.level_value,
fpov.level_value2
from
fnd_application_vl fav0,
fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
fnd_responsibility_vl frv,
fnd_user fu,
fnd_application_vl fav,
fnd_user fu2,
hr_all_organization_units haou,
fnd_nodes fn
where
fav0.application_name=:application_name and
1=1 and
fav0.application_id=fpo.application_id and
fpo.profile_option_id=fpov.profile_option_id and
fpo.application_id=fpov.application_id and
decode(fpov.level_id,10002,fpov.level_value)=fav.application_id(+) and
case when fpov.level_id in (10003,10007) then fpov.level_value end=frv.responsibility_id(+) and
case when fpov.level_id in (10003,10007) then fpov.level_value_application_id end=frv.application_id(+) and
decode(fpov.level_id,10004,fpov.level_value)=fu.user_id(+) and
decode(fpov.level_id,10005,fpov.level_value,10007,fpov.level_value2)=fn.node_id(+) and
decode(fpov.level_id,10006,fpov.level_value)=haou.organization_id(+) and
fpov.last_updated_by=fu2.user_id
order by
fpo.user_profile_option_name,
fpov.level_id,
decode(fpov.level_id,10001,null,10002,fav.application_name, 10003,frv.responsibility_name, 10004,fu.user_name||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null), 10005,fn.node_name,10006,haou.name)
</code></pre>

blocks|key|2396425|text|++SELECT+fpo.profile_option_name+SHORT_NAME,
+++++++++fpot.user_profile_option_name+NAME,
+++++++++DECODE+(fpov.level_id,
+++++++++++++++++10001,+'Site',
+++++++++++++++++10002,+'Application',
+++++++++++++++++10003,+'Responsibility',
+++++++++++++++++10004,+'User',
+++++++++++++++++10005,+'Server',
+++++++++++++++++'UnDef')
++++++++++++LEVEL_SET,
+++++++++DECODE+(TO_CHAR+(fpov.level_id),
+++++++++++++++++'10001',+'',
+++++++++++++++++'10002',+fap.application_short_name,
+++++++++++++++++'10003',+frsp.responsibility_key,
+++++++++++++++++'10005',+fnod.node_name,
+++++++++++++++++'10006',+hou.name,
+++++++++++++++++'10004',+fu.user_name,
+++++++++++++++++'UnDef')
++++++++++++"CONTEXT",
+++++++++fpov.profile_option_value+VALUE
++++FROM+fnd_profile_options+fpo,
+++++++++fnd_profile_option_values+fpov,
+++++++++fnd_profile_options_tl+fpot,
+++++++++fnd_user+fu,
+++++++++fnd_application+fap,
+++++++++fnd_responsibility+frsp,
+++++++++fnd_nodes+fnod,
+++++++++hr_operating_units+hou
+++WHERE+++++fpo.profile_option_id+=+fpov.profile_option_id(%2B)
+++++++++AND+fpo.profile_option_name+=+fpot.profile_option_name
+++++++++AND+fu.user_id(%2B)+=+fpov.level_value
+++++++++AND+frsp.application_id(%2B)+=+fpov.level_value_application_id
+++++++++AND+frsp.responsibility_id(%2B)+=+fpov.level_value
+++++++++AND+fap.application_id(%2B)+=+fpov.level_value
+++++++++AND+fnod.node_id(%2B)+=+fpov.level_value
+++++++++AND+hou.organization_id(%2B)+=+fpov.level_value
+++++++++AND+fpot.user_profile_option_name+IN+('&User_Profile_Option_Name')
ORDER+BY+short_name;

++++++SELECT+fpo.profile_option_name+SHORT_NAME,
+++++++++fpot.user_profile_option_name+NAME,
+++++++++DECODE+(fpov.level_id,
+++++++++++++++++10001,+'Site',
+++++++++++++++++10002,+'Application',
+++++++++++++++++10003,+'Responsibility',
+++++++++++++++++10004,+'User',
+++++++++++++++++10005,+'Server',
+++++++++++++++++'UnDef')
++++++++++++LEVEL_SET,
+++++++++DECODE+(TO_CHAR+(fpov.level_id),
+++++++++++++++++'10001',+'',
+++++++++++++++++'10002',+fap.application_short_name,
+++++++++++++++++'10003',+frsp.responsibility_key,
+++++++++++++++++'10005',+fnod.node_name,
+++++++++++++++++'10006',+hou.name,
+++++++++++++++++'10004',+fu.user_name,
+++++++++++++++++'UnDef')
++++++++++++"CONTEXT",
+++++++++fpov.profile_option_value+VALUE
++++FROM+fnd_profile_options+fpo,
+++++++++fnd_profile_option_values+fpov,
+++++++++fnd_profile_options_tl+fpot,
+++++++++fnd_user+fu,
+++++++++fnd_application+fap,
+++++++++fnd_responsibility+frsp,
+++++++++fnd_nodes+fnod,
+++++++++hr_operating_units+hou
+++WHERE+++++fpo.profile_option_id+=+fpov.profile_option_id(%2B)
+++++++++AND+fpo.profile_option_name+=+fpot.profile_option_name
+++++++++AND+fu.user_id(%2B)+=+fpov.level_value
+++++++++AND+frsp.application_id(%2B)+=+fpov.level_value_application_id
+++++++++AND+frsp.responsibility_id(%2B)+=+fpov.level_value
+++++++++AND+fap.application_id(%2B)+=+fpov.level_value
+++++++++AND+fnod.node_id(%2B)+=+fpov.level_value
+++++++++AND+hou.organization_id(%2B)+=+fpov.level_value
+++++++++AND+fpot.user_profile_option_name+IN+('&User_Profile_Option_Name')
ORDER+BY+short_name;

enter+code+here|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2396426|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> SELECT fpo.profile_option_name SHORT_NAME,
 fpot.user_profile_option_name NAME,
 DECODE (fpov.level_id,
 10001, 'Site',
 10002, 'Application',
 10003, 'Responsibility',
 10004, 'User',
 10005, 'Server',
 'UnDef')
 LEVEL_SET,
 DECODE (TO_CHAR (fpov.level_id),
 '10001', '',
 '10002', fap.application_short_name,
 '10003', frsp.responsibility_key,
 '10005', fnod.node_name,
 '10006', hou.name,
 '10004', fu.user_name,
 'UnDef')
 "CONTEXT",
 fpov.profile_option_value VALUE
 FROM fnd_profile_options fpo,
 fnd_profile_option_values fpov,
 fnd_profile_options_tl fpot,
 fnd_user fu,
 fnd_application fap,
 fnd_responsibility frsp,
 fnd_nodes fnod,
 hr_operating_units hou
 WHERE fpo.profile_option_id = fpov.profile_option_id(+)
 AND fpo.profile_option_name = fpot.profile_option_name
 AND fu.user_id(+) = fpov.level_value
 AND frsp.application_id(+) = fpov.level_value_application_id
 AND frsp.responsibility_id(+) = fpov.level_value
 AND fap.application_id(+) = fpov.level_value
 AND fnod.node_id(+) = fpov.level_value
 AND hou.organization_id(+) = fpov.level_value
 AND fpot.user_profile_option_name IN ('&amp;User_Profile_Option_Name')
ORDER BY short_name;

 SELECT fpo.profile_option_name SHORT_NAME,
 fpot.user_profile_option_name NAME,
 DECODE (fpov.level_id,
 10001, 'Site',
 10002, 'Application',
 10003, 'Responsibility',
 10004, 'User',
 10005, 'Server',
 'UnDef')
 LEVEL_SET,
 DECODE (TO_CHAR (fpov.level_id),
 '10001', '',
 '10002', fap.application_short_name,
 '10003', frsp.responsibility_key,
 '10005', fnod.node_name,
 '10006', hou.name,
 '10004', fu.user_name,
 'UnDef')
 "CONTEXT",
 fpov.profile_option_value VALUE
 FROM fnd_profile_options fpo,
 fnd_profile_option_values fpov,
 fnd_profile_options_tl fpot,
 fnd_user fu,
 fnd_application fap,
 fnd_responsibility frsp,
 fnd_nodes fnod,
 hr_operating_units hou
 WHERE fpo.profile_option_id = fpov.profile_option_id(+)
 AND fpo.profile_option_name = fpot.profile_option_name
 AND fu.user_id(+) = fpov.level_value
 AND frsp.application_id(+) = fpov.level_value_application_id
 AND frsp.responsibility_id(+) = fpov.level_value
 AND fap.application_id(+) = fpov.level_value
 AND fnod.node_id(+) = fpov.level_value
 AND hou.organization_id(+) = fpov.level_value
 AND fpot.user_profile_option_name IN ('&amp;User_Profile_Option_Name')
ORDER BY short_name;

enter code here
</code></pre>

I was working with Oracle R12 application.Can anybody suggest some queries to identify the <code>Profile names and Profile values</code> related to a particular product/item selected??

I tried using 

<pre><code>SELECT *
FROM fnd_profile_options_vl po,
fnd_profile_option_values pov,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
WHERE 1 = 1
AND pov.application_id = po.application_id
AND pov.profile_option_id = po.profile_option_id
AND usr.user_id(+) = pov.level_value
AND rsp.application_id(+) = pov.level_value_application_id
AND rsp.responsibility_id(+) = pov.level_value
AND app.application_id(+) = pov.level_value
AND svr.node_id(+) = pov.level_value
AND org.organization_id(+) = pov.level_value
</code></pre>

It will return all profile values. But how can I identify the profile value of an item/product I selected.

Oracle EBS: Get profile values

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在使用甲骨文R12 application.Can，有人建议使用一些查询来识别与特定产品/项目相关的Profile names and Profile values吗？我试着用SELECT *FROM fnd_profile_options_vl po,fnd_profile_option_values pov,fnd_user usr,fnd_application app,fnd_resp

问Oracle EBS:获取配置文件值
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle EBS:获取配置文件值EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle EBS:获取配置文件值
EN