Logo Background

Check Java Caching Option Script

  • By on May 29, 2009 | No Comments

    How to check Java Caching option in Oracle Applications 11i E-Business Suite?

    Use the handy script below to check the Java Caching option in Site, Application, Responsibility, User and Server level.

    Script To Check Java Caching Option in Oracle Applications 11i

    SELECT p.profile_option_name SHORT_NAME,
      n.user_profile_option_name NAME,
             decode(v.level_id,
      10001, 'Site',
      10002, 'Application',
      10003, 'Responsibility',
      10004, 'User',
      10005, 'Server',
      10007, 'SERVRESP',
     'UnDef') LEVEL_SET,
     decode(to_char(v.level_id),
      '10001', '',
             '10002', app.application_short_name,
             '10003', rsp.responsibility_key,
             '10005', svr.node_name,
             '10006', org.name,
             '10004', usr.user_name,
             '10007', 'Serv/resp',
                    'UnDef') "CONTEXT",
     v.profile_option_value VALUE
      FROM fnd_profile_options p,
         fnd_profile_option_values v,
         fnd_profile_options_tl n,
         fnd_user usr,
         fnd_application app,
         fnd_responsibility rsp,
         fnd_nodes svr,
         hr_operating_units org
      WHERE p.profile_option_id = v.profile_option_id (+)
      AND p.profile_option_name = n.profile_option_name
      AND p.profile_option_name IN ('FND_CACHE_PORT_RANGE','JTF_DIST_CACHE_PORT',
    'FLEXFIELDS:USE_JAVA_CACHE')
      AND    usr.user_id (+) = v.level_value
      AND    rsp.application_id (+) = v.level_value_application_id
      AND    rsp.responsibility_id (+) = v.level_value
      AND    app.application_id (+) = v.level_value
      AND    svr.node_id (+) = v.level_value
      AND    org.organization_id (+) = v.level_value
      ORDER BY short_name, level_set;
    Previous
    Next
    » Oracle Applications 11i Backup Recovery
Leave a Comment