Monday, 19 July 2021

Oracle EBS - Query to get responsibility for each OU

Query mostly required when we have to run program from backend for each responsibility


SELECT fpo.profile_option_name

     , frt.responsibility_name resp_name

     , frt.application_id resp_appl_id

     , frt.responsibility_id resp_id

     , fp.profile_option_value org_id

     , fu.user_id

  FROM FND_PROFILE_OPTION_VALUES fp

     , fnd_responsibility_tl frt

     , fnd_profile_options fpo

     , fnd_user fu

 WHERE fp.level_id = 10003 

   AND fp.level_value = frt.responsibility_id

   AND fp.profile_option_id = fpo.profile_option_id

   AND fpo.profile_option_name = 'ORG_ID'

   AND fu.user_name = 'SYSADMIN'

   AND frt.responsibility_name like '%Superuser%'

ORDER BY  fp.profile_option_value,frt.responsibility_name;  

Saturday, 17 July 2021

Setup Internet Explorer Mode in Microsoft Edge

Download policy files using following link


 Download Microsoft Edge for Business - Microsoft

Choose => Channel => Build => Platform and download "GET POLICY FILES" 


Uncompress "MicrosoftEdgePolicyTemplates.cab" file => "MicrosoftEdgePolicyTemplates.zip" =>

Go to "Windows" folder


Copy both folders "adm" and "admx" and paste to "c:\windows"


go to "Desktop\Edge\MicrosoftEdgePolicyTemplates\windows\admx" and paste following to "C:\Windows\PolicyDefinitions"
  en-US <folder>
- msedge.admx
- msedgeupdate.admx
- msedgewebview2.admx


----
Now find 


Enable following
  • Allows you to set whether Enterprise Mode Site List Manager 
  • Configure Internet Explorer integration
  • Configure the Enterprise Mode Site List
  • Allow Internet Explorer Mode Testing


Now we can see 2 options in "More Settings"
  • Open sites in Internet Explorer mode
  • Open sites in Edge mode







Hurry!!!!!!!