Oracle EBS: Get profile values

being_uncertain picture being_uncertain · Aug 21, 2012 · Viewed 10.4k times · Source

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

I tried using

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

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

Answer

Pan.Tian picture Pan.Tian · Dec 12, 2012

check my post:http://blog.csdn.net/pan_tian/article/details/7652968

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