Friday 14 December 2018

Oracle Apps: E-Business Suite Applications Technology Stack Component Versions

This post helps to find the vesrions of some of the Technology components in R12.2.
Inorder to get the Technology Stack Components Version on E-Business Suite, please refer to the below Metalink Note.

E-Business Suite Applications Technology Stack Utility / Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc) (Doc ID 601736.1)

The script from the above Note will give you an html report with all the Technology stack components versions.

Note:- The below scripts  have been verified only on a 12.2.7 instance

Scripts to run on middle-tier (ex:- use putty)

#1. Forms Version
   $ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version
   
#2. Reports Version
   $ORACLE_HOME/bin/rwrun | grep Release
   
#3. PL/SQL Version
   $ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

#4. Weblogic Version
   cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION
   
#5. Jinitiator Version
   grep jinit_ver_comma $CONTEXT_FILE

#6. Application Server Version
   cat $ORACLE_HOME/config/ias.properties | grep Version


Scripts to run on database

#1. EBS Version
   select release_name from apps.fnd_product_groups;
   
#2. Database Version
   select * from v$version;
   
#3. Workflow Version
   select text version from wf_resources where name = 'WF_VERSION';


Feel free to point out if anything is missing/wrong in this blog.

Friday 7 December 2018

Oracle Apps: List of Responsibilities attached with a Concurrent Program / Request Set

Some helpful queries to find the list of responsibilities to which a concurrent program  or a request set is attached. This helps to easily find out which responsibility can be used to submit a Concurrent Program / request Set.


#1. Query to find the list of responsibilities to which a Concurrent Program is attached.
 SELECT d.responsibility_name          responsibility  
       ,c.request_group_name           request_group  
       ,a.user_concurrent_program_name concurrent_program  
 FROM  apps.fnd_concurrent_programs_vl a  
      ,apps.fnd_request_group_units    b  
      ,apps.fnd_request_groups         c  
      ,apps.fnd_responsibility_vl      d  
 WHERE b.request_unit_id  = a.concurrent_program_id  
 AND   c.request_group_id = b.request_group_id  
 AND   d.request_group_id = b.request_group_id  
 AND   (a.user_concurrent_program_name LIKE 'User Concurrent Program Name'   
        OR  
        a.concurrent_program_name LIKE 'CONCURRENT_PROGRAM_NAME')  
 ORDER BY 1,2,3;

#2. Query to find the list of responsibilities to which a Request Set is attached.
 SELECT d.responsibility_name   responsibility  
       ,c.request_group_name    request_group  
       ,a.user_request_set_name request_set  
 FROM  apps.fnd_request_sets_vl     a  
      ,apps.fnd_request_group_units b  
      ,apps.fnd_request_groups      c  
      ,apps.fnd_responsibility_vl   d  
 WHERE b.request_unit_id  = a.request_set_id  
 AND   c.request_group_id = b.request_group_id  
 AND   d.request_group_id = b.request_group_id  
 AND   a.user_request_set_name LIKE 'Request Set Name'  
 ORDER BY 1,2,3;  


Feel free to point out if anything is missing/wrong in this blog.