Oracle Apps - SQLDEVELOPER is not returning data from Oracle Standard Policy Based Tables even after setting Policy Context

Sometimes SQLDEVELOPER is not returning data from Oracle Standard Policy Based Tables even after setting the policy context

i.e. 

MO_GLOBAL.SET_POLICY_CONTEXT('S', 83);

select * from org_organization_definitions; is returning 0 results

Proposed Solutions: 

Add this line in sqldeveloper.conf file and try one more time

 

AddVMOption -Doracle.net.disableOob=true

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;  

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!!!!!!!

Remove Junk or unwanted columns from data in Oracle/SQL/ PL/SQL using REGEXP_REPLACE

update hz_locations 

set address1=REGEXP_REPLACE(address1, '[^0-9A-Za-z/. ()-_]', ' ') 

where length(address1) <> lengthb(address1);