SELECTsubstr(pro1.user_profile_option_name,1,35) Profile, decode(pov.level_id, 10001,'Site', 10002,'Application', 10003,'Resp', 10004,'User') Option_Level, decode(pov.level_id, 10001,'Site', 10002,appl.application_short_name, 10003,resp.responsibility_name, 10004,u.user_name) Level_Value, nvl(pov.profile_option_value,'Is Null') Profile_option_Value FROM fnd_profile_option_values pov, fnd_responsibility_tl resp, fnd_application appl, fnd_user u, fnd_profile_options pro, fnd_profile_options_tl pro1 WHERE pro1.user_profile_option_name like ('%Ledger%') and pro.profile_option_name = pro1.profile_option_name and pro.profile_option_id = pov.profile_option_id and resp.responsibility_name like '%General%Ledger%' /* comment this line if you need to check profiles for all responsibilities */ and pov.level_value = resp.responsibility_id (+) and pov.level_value = appl.application_id (+) and pov.level_value = u.user_id (+) order by 1,2;
Archive for the ‘Oracle Queries’ Category
Oracle Queries for checking Profile Option Values
April 19th, 2020, posted in Oracle QueriesDifference Between Bitmap and Character Mode Report
April 12th, 2020, posted in Oracle QueriesHere is an example to help explain how Oracle Reports are designed and printed in both the bitmap and character-mode environments.
Assume you wish to print “Cc” where “C” is a different font and a larger point size than “c” and is in boldface type (where “c” is not). In Oracle Reports Designer, bitmap mode, you can make “C” bold and in a different font and point size than “c”.
This is because you are generating postscript output. Postscript is a universal printer language and any postscript printer is able to interpret your different design instructions. In Oracle Reports Designer, character mode, the APPLICATIONS STANDARDS REQUIRE the report to be designed in ONE FONT/ ONE CHARACTER SIZE. Character mode reports generate ASCII output.
In ASCII you cannot dynamically change the font and character size. The standard is in effect so a report prints as identically as possible from both conventional and postscript printers.
