Identify versions of components in EBS

Useful commands to find the versions of various components used in Oracle E-Business Suite

Log in to the Application server and source the environment fine and execute the below command.

Find Apache Version in R12

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

Find Perl Version in EBS

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Find Java Version/JDK Version

cd $ADMIN_SCRIPTS_HOME/

sh java.sh -version

Find JRE Version

cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version

Find Weblogic Version

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

Find Opatch Version

$ORACLE_HOME/OPatch/opatch lsinventory

Oracle EBS version from the backend then connect to the database as user apps,

Find Oracle EBS Version

SQL>select release_name from apps.fnd_product_groups;

Find AD & TXK version in R12

SQL>select ABBREVIATION, NAME, codelevel FROM apps.AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');

Find Workflow Version in R12

SQL>select text ,name from wf_resources where name like '%WF_VERSION%';

Oracle has provisioned bulit in scripts to collect versions of technology stack components. Reference – 601736.1

For Application Tier

perl $FND_TOP/patch/115/bin/TXKScript.pl 
-script=$FND_TOP/patch/115/bin/txkInventory.pl 
-txktop=$APPLTMP -contextfile=$CONTEXT_FILE 
-appspass=<apps password> 
-outfile=<File_Directory>/<output_file_name>

For Database Tier

$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl 
-txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=<apps password>
-outfile=<File_Directory>/<output_file_name>

How to assign multiple responsibility to multiple user in oracle apps from backend

Adding Mutiple Responsibilty to Mutiple User from Back End in Oracle Apps

With the following we can add multiple user name and multiple responsibilities through backend.

This script can be used to assign multiple responsibilities to multiple  user in Oracle Apps

Declare 
  cursor get_user 
   is 
     select USER_NAME 
from fnd_user 
where END_DATE is null 
and LAST_UPDATED_BY not in (1,0) 
and USER_ID not in (0,1110,1120,1606,1826,2126,2608,2869,3030)
--and user_id =3030--ERP_SUPPORT
ORDER BY 1; 
   cursor create_responsibilities 
   is 
     select resp.responsibility_key 
           ,resp.responsibility_name 
           ,app.application_short_name       
     from  fnd_responsibility_vl resp, 
           fnd_application       app 
     where resp.application_id = app.application_id  
     and   resp.responsibility_name in ( 'XX ERP Issue Register','System Administrator' ) ; 
 begin 
   for c_user in get_user loop 
   for get_resp in create_responsibilities  
   loop 
     fnd_user_pkg.addresp (
                username        => c_user.user_name 
               ,resp_app        => get_resp.application_short_name 
               ,resp_key        => get_resp.responsibility_key 
               ,security_group  => 'STANDARD' 
               ,description     => null 
               ,start_date      => sysdate 
               ,end_date        => null); 
     dbms_output.put_line('Responsibility '||get_resp.responsibility_name||' added !!!!!!');   
   end loop; 
end loop;
   commit; 
 exception 
   when others then 
   dbms_output.put_line ('Exception : '||SUBSTR(SQLERRM, 1, 500)); 
   rollback; 
 end;