R12AppsQueriesSQL

Thursday, 11 November 2021

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
Posted by Mukesh Singh at 21:01 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Pages

  • Home

Blog Archive

  • ►  2024 (5)
    • ►  September (1)
    • ►  August (4)
  • ►  2023 (2)
    • ►  March (2)
  • ►  2022 (11)
    • ►  June (1)
    • ►  March (5)
    • ►  February (2)
    • ►  January (3)
  • ▼  2021 (4)
    • ▼  November (1)
      • Oracle Apps - SQLDEVELOPER is not returning data f...
    • ►  July (2)
    • ►  February (1)
  • ►  2020 (9)
    • ►  September (2)
    • ►  August (4)
    • ►  April (1)
    • ►  January (2)
  • ►  2019 (5)
    • ►  October (1)
    • ►  June (3)
    • ►  March (1)
  • ►  2018 (7)
    • ►  September (6)
    • ►  March (1)
  • ►  2014 (2)
    • ►  September (2)
  • ►  2013 (3)
    • ►  May (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  November (3)

About Me

Mukesh Singh
View my complete profile
Simple theme. Theme images by sebastian-julian. Powered by Blogger.