Skip to main content

Query for profile options - Oracle Apps R12

 Query for Profile Options


Profile’s Enabled at Site Level


SELECT fpot.user_profile_option_name, fpov.profile_option_value

  FROM fnd_profile_option_values fpov,

       fnd_profile_options fpo,

       fnd_profile_options_tl fpot

 WHERE     fpo.profile_option_id = fpov.profile_option_id

       AND fpo.profile_option_name = fpot.profile_option_name

       AND fpot.language = 'US'

       AND fpov.level_id = 10001                              -- Site Level ID


Profile’s Enabled at Application Level


SELECT fat.application_name,

       fpot.user_profile_option_name,

       fpov.profile_option_value

  FROM fnd_profile_option_values fpov,

       fnd_profile_options fpo,

       fnd_profile_options_tl fpot,

       fnd_application_tl fat

 WHERE     fpo.profile_option_id = fpov.profile_option_id

       AND fpo.profile_option_name = fpot.profile_option_name

       AND fpot.language = 'US'

       AND fpov.level_value = fat.application_id

       AND fat.language = 'US'

       AND fpov.level_id = 10002                       -- Application Level ID

       AND UPPER (fat.application_name) LIKE '%HUMAN%RES%'


Profile’s Enabled at Responsibility Level


SELECT frt.responsibility_name,

       fpot.user_profile_option_name,

       fpov.profile_option_value

  FROM fnd_profile_option_values fpov,

       fnd_profile_options fpo,

       fnd_profile_options_tl fpot,

       fnd_responsibility_tl frt

 WHERE     fpo.profile_option_id = fpov.profile_option_id

       AND fpo.profile_option_name = fpot.profile_option_name

       AND fpot.language = 'US'

       AND fpov.level_value = frt.responsibility_id(+)

       AND frt.language = 'US'

       AND fpov.level_id = 10003                     -- Resposibility Level ID

       AND UPPER (frt.responsibility_name) LIKE

              '%XXX IRECRUITMENT RECRUITER%'


Profile’s Enabled at User Level


SELECT fu.user_name, fpot.user_profile_option_name,fpov.profile_option_value

  FROM fnd_profile_option_values fpov,

       fnd_profile_options fpo,

       fnd_profile_options_tl fpot,

       fnd_user fu

 WHERE     fpo.profile_option_id = fpov.profile_option_id

       AND fpo.profile_option_name = fpot.profile_option_name

       AND fpot.language = 'US'

       AND fpov.level_value = fu.user_id

       AND fu.user_name = 'BIJOYJ'

Labels:

Comments

Post a Comment

Popular posts from this blog

Query to find concurrent programs associated to Responsibility - Oracle Apps R12

 Query to Find Programs associated to Responsibility SELECT frt.responsibility_name, frg.request_group_name,     frgu.request_unit_type,frgu.request_unit_id,     fcpt.user_concurrent_program_name     FROM fnd_Responsibility fr, fnd_responsibility_tl frt,     fnd_request_groups frg, fnd_request_group_units frgu,     fnd_concurrent_programs_tl fcpt     WHERE frt.responsibility_id = fr.responsibility_id     AND frg.request_group_id = fr.request_group_id     AND frgu.request_group_id = frg.request_group_id     AND fcpt.concurrent_program_id = frgu.request_unit_id     AND frt.LANGUAGE = USERENV('LANG')     AND fcpt.LANGUAGE = USERENV('LANG')     AND fcpt.user_concurrent_program_name = :conc_prg_name     ORDER BY 1,2,3,4
Post a Comment
Read more

Query to find Open PO Periods - Oracle Apps R12

 Query to Find Open PO Periods for Month End Closure SELECT sob.name "Set of Books" ,   fnd.product_code "Product Code" ,   ps.PERIOD_NAME "Period Name" ,   ps.START_DATE "Period Start Date" ,   ps.END_DATE "Period End Date" ,   DECODE(ps.closing_status, 'O','O - Open' ,                             'N','N - Never Opened' ,                             'F','F - Future Enterable' ,                             'C','C - Closed' ,'Unknown') "Period Status" FROM gl_period_statuses ps ,   Apps.GL_SETS_OF_BOOKS sob ,   FND_APPLICATION_VL fnd WHERE ps.application_id      IN (201) -- 101 GL & 201 PO  AND sob.SET_OF_BOOKS_ID       = ps.SET_OF_BOOKS_ID AND fnd.application_id        = ps.appl...
Post a Comment
Read more

Getting Started with Oracle Applications

  This document will explains about Oracle Apps login, Choosing Responsibility, Choosing Function / Opening Form, Switch Responsibility, Query Form and Keyboard Shortcuts. This chapter would tell a user about the basics of login to the Oracle Applications instance. It would also demonstrate the basics of working with Oracle Applications. To understand the complete functionality of a particular responsibility please refers to the respective User Guide. Oracle Applications Login Before you connect to Oracle Applications you must know the URL of the Oracle Applications server you want to connect to. Clicking on the URL would lead you to the Oracle Applications Login Page as shown in figure 1 below. Oracle Applications Login Page Choosing Responsibility To connect to the Oracle Applications, you must have an Oracle Apps login ID created by the System Administrator of the Oracle Applications instance.  Enter the appropriate Login ID and password and click login. If the login is suc...
Post a Comment
Read more