Verify Context File Values in the database

 Verify Context File Values in the database

$ sqlplus apps/apps

col ppool format A5

col edition format A8

col oacore format A40

col forms format A20

col oafm format A20

col c4ws format A23

col oaea format A17

col host format A15

col jcache format A7

col name format A20

col version format A20

set pages 20 lines 170

SELECT NAME, VERSION, PATH FROM fnd_oam_context_files WHERE (status is null OR status != 'H') AND (name NOT IN ('METADATA','TEMPLATE')) AND CTX_TYPE = 'A';

 

SELECT

   NODE_NAME host,

   extractValue(XMLType(TEXT),'//PORT_POOL')                   ppool,

   extractValue(XMLType(TEXT),'//file_edition_type')              edition,

   extractValue(XMLType(TEXT),'//oacore_server_ports')         oacore,

   extractValue(XMLType(TEXT),'//forms_server_ports')          forms,

   extractValue(XMLType(TEXT),'//oafm_server_ports')           oafm,

   extractValue(XMLType(TEXT),'//forms-c4ws_server_ports')     c4ws, 

   extractValue(XMLType(TEXT),'//oaea_server_ports')           oaea,

   extractValue(XMLType(TEXT),'//jcache_port')                 jcache -- s_java_object_cache_port

from fnd_oam_context_files

where name not in ('TEMPLATE','METADATA')

  and (status is null or status !='H')

  and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') in ('run','patch')

  and CTX_TYPE = 'A'

order by 1;