Thursday, April 25, 2013

E-Business 12.1 Upgrading to Release 12.1.1 -- Forms Launch JRE Versions 1.4 - 1.7

E-Business SUite 12.1 -- Finishing Steps.
 
When you LAUNCH the E-Business Suite SIGN-ON screen and then connect to the E-Business Suite 12.1
. . . after NAVIGATING and SELECTING a menu-item that launches the Oracle-Professional Forms
. . . you may be asked/interrogated about your Desktop/Laptop JRE version (Too Old or Too New).
 
To Present these E-Business Suite JRE/Java Version PopUps
===============================================================
 
OPTIONAL: Update JDK-Plugin Options

AppsTier (Admin/ConcMgr/Forms/WebTier)
AppsTier: CONTEXT_FILE (ADAutoConfig) JRE-Versions:
[oracle] vi $CONTEXT_FILE
Change sun_clsid and jinit_clsid
<!-- JDK plugins -->
<sun_plugin_ver oa_var="s_sun_plugin_ver">1.6.0_07</sun_plugin_ver>
<sun_plugin_type oa_var="s_sun_plugin_type">jdk</sun_plugin_type>
<sun_clsid oa_var="s_sun_clsid">


8AD9C840-044E-11D1-B3E9-00805F499D93</sun_clsid>

<!-- Jinitiator -->
<jinit_ver_dot oa_var="s_jinit_ver_dot">1.6.0_07</jinit_ver_dot>
<jinit_ver_comma oa_var="s_jinit_ver_comma">1.6.0_07</jinit_ver_comma>
<jinit_clsid oa_var="s_jinit_clsid">


8AD9C840-044E-11D1-B3E9-00805F499D93</jinit_clsid>

NOTE: JRE-Version Choices: clsid variable Options
CAFEEFAC-0016-0000-0007-ABCDEFFEDCBA Forces JRE 1.6_07 (Default)
CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA Any JRE 1.6 Version
8AD9C840-044E-11D1-B3E9-00805F499D93 Allows Highest Clientside JRE-Plug-In Versio

 
[oracle] $ADMIN_SCRIPTS_HOME/adautocfg.sh

grep sun_plugin_ $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg
sun_plugin_mimetype=application/x-java-applet
sun_plugin_classid=clsid:CAFEEFAC-0016-0000-0007-ABCDEFFEDCBA
sun_plugin_url=http://srfoapd04.cloudtricity.local:8031/OA_HTML/oaj2se.exe
sun_plugin_version=1.6.0_07
sun_plugin_legacy_lifecycle=false

Support Note: 393931.1
===============
Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 [ID 393931.1]
Modified: April 19, 2013
If you have individual users running different versions of JRE streams (for example User A still runs JRE 1.5.0_22 while User B is running JRE 1.6.0_33) or you simply want to allow users to run the latest JRE version on their desktop client, please update the appsweb.cfg file to use the dynamic CLSID. When using this setting Oracle


Forms-based content will launch using the highest JRE Plug-in version from the highest JRE family stream found on the desktop. Only if no JRE Plug-in version is found on the desktop will the user will be prompted to download the JRE version from the Oracle E-Business Suite web server. Upgrading to a later JRE 1.6.x release must therefore be done from the desktop client.
3.1. Take a backup copy of the runtime appsweb.cfg file under $INST_TOP/ora/10.1.2/forms/server/appsweb.cfg before updating it
3.2. Find section "4a) Sun JDK Plugin Parameters" and replace the sun_plugin_classid value as follows:
sun_plugin_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93
3.3. Save the file. (users will pick up the new clsid when they next launch a new forms session.)
Note:
This change will get overwritten if autoconfig is run. To make the change more permanent please update the following parameter in the AutoConfig file.
<sun_clsid oa_var="s_sun_clsid">8AD9C840-044E-11D1-B3E9-00805F499D93</sun_clsid>


Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 [ID 393931.1]

Tuesday, April 23, 2013

E-Business Suite: whatresponsibility: Report on the eBusiness Suite Responsibilities for a User.

What E-Busineess Responsilities are Assigned to an E-Business Suite User:


#!/usr/bin/ksh
#whatresponsibility ()
#-------------------------------------------------------------------------#
#    Module Name:  whatresponsibility  (c) Copyright May 2012             #
#                                                                         #
#    Purpose:      Report on the eBusiness Responsibilities for a User.   #
#                                                                         #
#    Maintenance                                                          #
#    Date          Author        Description                              #
#    -----------   ------------  ---------------------------------------- #
#    10-May-2012   M.Barone      Module design/creation                   #
#-------------------------------------------------------------------------#
{
        DIRNAM=$(dirname $0)
        ORASID=$(echo $CONTEXT_NAME | cut -f1 -d'_')
        HNAME=$(uname -n)

        #-----------------------------------------------------------------#
        #  TEST:  Number ($#) of arguments passed to this function?       #
        #-----------------------------------------------------------------#
        if      [ $# = 0 ]
        then
            clear
            echo
            echo  " #----------------------------------------------------#"
            echo  " # whatresponsibility:        Responsibility/End_Date #"
            echo  " #----------------------------------------------------#"
            echo

            #-------------------------------------------------------------#
            #  Trap:  Set CNTL-C CNTL-D CNTL-\ Before Password Protection #
            #-------------------------------------------------------------#
            trap        "stty echo; return"     2
            trap        "stty echo; return"     3
            stty -echo

            read PASSWD?" Please Enter the Oracle APPS Passwd:  "

            stty echo
            echo
            #-------------------------------------------------------------#
            #  Trap:  Reset CNTL-C CNTL-D CNTL-\After Password Protection #
            #-------------------------------------------------------------#
            trap        2
            trap        3

            read USRNAM?"     Enter the E-Business UserName (Ex. BARONE): "

            clear
        else
            PASSWD=$1
            USRNAM=$2
            clear
        fi


#-------------------------------------------------------------------------#
#  Initialize                                                             #
#-------------------------------------------------------------------------#
        SPOOLNM=/tmp/whatresponsibility_$$.txt

#-------------------------------------------------------------------------#
#  SQL*Plus ("Here-Document")                                             #
#-------------------------------------------------------------------------#
sqlplus  -s  /nolog  <<-END_FILE

        CONNECT  APPS/$PASSWD

        set     pagesize        9000
        set     feedback        off
        set     flush           on
        set     heading         on
        set     pause           off
        set     space           1
        set     termout         on
        set     verify          on
        set     linesize        80
        set     pagesize        999

        SPOOL ${SPOOLNM}

        clear   BREAKS
        clear   BUFFER
        clear   COLUMNS
        clear   COMPUTES
        clear   SCREEN
        clear   SQL
        clear   TIMING

        prompt #----------------------------------------------------------#
        prompt #- E-Business Suite (whatresponsibility)                  -#
        prompt #----------------------------------------------------------#

        COLUMN  datevalue       NOPRINT NEW_VALUE       DATEVAR
        COLUMN  timevalue       NOPRINT NEW_VALUE       TIMEVAR

        COLUMN uname    FORMAT A11     HEADING 'User Name'
        COLUMN aname    FORMAT A19     HEADING 'Application Name'
        COLUMN rname    FORMAT A20     HEADING 'Responsibilty Name'
        COLUMN resid    FORMAT 99999   HEADING 'Resp|ID'
        COLUMN reddt    FORMAT A9      HEADING 'FND_Resp|End_Date'
        COLUMN weddt    FORMAT A9      HEADING 'WorkFlow|UserRole|End_Date'

        TTITLE  CENTER  '${ORASID} (${HNAME}) Responsibility/Dates' -
                LEFT    DATEVAR                           skip 1    -
                CENTER  'Sorted by Responsibility Name'             -
                LEFT    TIMEVAR                           skip 2

        SELECT  TO_CHAR(sysdate, 'DD-MON-YY')           datevalue,
                TO_CHAR(sysdate, 'HH24:MI:SS')          timevalue,
                FUS.user_name                           uname,   
                FAP.application_name                    aname,
                FRE.responsibility_name                 rname,
                FRE.responsibility_id                   resid,
                FRE.end_date                            reddt,
                WFU.end_date                            weddt
        FROM    apps.fnd_user                   FUS,
                apps.fnd_responsibility_vl      FRE,
                apps.fnd_application_tl         FAP,
                apps.wf_local_roles             WFL,
                apps.wf_user_role_assignments   WFU
        WHERE   FUS.user_name           = WFU.user_name
        AND     WFU.role_name           = WFL.name
        AND     WFL.display_name        = FRE.responsibility_name
        AND     FAP.application_id      = FRE.application_id
        AND     WFU.user_name           LIKE  '%${USRNAM}%'
        AND     FAP.language            = 'US'
        ORDER BY FUS.user_name, FRE.responsibility_name;

EXIT;
END_FILE

print
print  "Please see  /tmp/whatresponsibility_$$.txt"
print
}

Wednesday, April 17, 2013

E-Business Suite: What-Oracle-Accounts are LOCKED.


#!/usr/bin/ksh
#whataccount ()
#-------------------------------------------------------------------------#
#    Module Name:  whataccount  (c) OATC-M.Barone 2012                    #
#                                                                         #
#    Purpose:      Report on the DBA_USERS (Database) Accounts            #
#                                                                         #
#    Maintenance                                                          #
#    Date          Author        Description                              #
#    -----------   ------------  ---------------------------------------  #
#    10-Oct-2012   M.Barone      Module design/creation
                   #
#-------------------------------------------------------------------------#
{
        DIRNAM=$(dirname $0)
        ORASID=$(echo $CONTEXT_NAME | cut -f1 -d'_')
        HNAME=$(uname -n)

        #-----------------------------------------------------------------#
        #  TEST:  Number ($#) of arguments passed to this function?       #
        #-----------------------------------------------------------------#
        if      [ $# = 0 ]
        then
            clear
            echo
            echo  " #---------------------------------------------------#"
            echo  " # whataccount:             Oracle Database Accounts #"
            echo  " #---------------------------------------------------#"
            echo                                                               

            #-------------------------------------------------------------#
            #  Trap: Set CNTL-C CNTL-D CNTL-\ Before Password Protection  #
            #-------------------------------------------------------------#
            trap        "stty echo; return"  2                             
            trap        "stty echo; return"  3
            stty -echo

            read PASSWD?" Please Enter the Oracle APPS Passwd:  "

            stty echo
            echo
            #-------------------------------------------------------------#
            #  Trap: Reset CNTL-C CNTL-D CNTL-\ After Password Protection #
            #-------------------------------------------------------------#
            trap        2
            trap        3

            clear
        else
            PASSWD=$1
            clear
        fi

#-------------------------------------------------------------------------#
#  Initialize                                                             #
#-------------------------------------------------------------------------#
        SPOOLNM=/tmp/whataccount_$$.txt

#-------------------------------------------------------------------------#
#  SQL*Plus ("Here-Document")                                             #
#-------------------------------------------------------------------------#
sqlplus  -s  /nolog  <<-END_FILE

        CONNECT  APPS/$PASSWD

        SPOOL ${SPOOLNM}

        clear   BREAKS
        clear   BUFFER
        clear   COLUMNS
        clear   COMPUTES
        clear   SCREEN
        clear   SQL
        clear   TIMING

        set     feedback        off
        set     flush           on
        set     heading         on
        set     pause           off
        set     space           1
        set     termout         on
        set     verify          on
        set     linesize        80
        set     pagesize        999

        prompt #----------------------------------------------------------#
        prompt #- What (whataccount)                                     -#
        prompt #----------------------------------------------------------#

        COLUMN  datevalue       NOPRINT NEW_VALUE       DATEVAR
        COLUMN  timevalue       NOPRINT NEW_VALUE       TIMEVAR

        COLUMN  uname  format A14      HEADING 'User|Name'     
        COLUMN  astat  format A7       HEADING 'Account|Status'
        COLUMN  ldate  format A11      HEADING 'Lock|Date'     
        COLUMN  edate  format A11      HEADING 'Expiry|Date'   
        COLUMN  dspce  format A6       HEADING 'Default|Tablespace' 
        COLUMN  tspce  format A6       HEADING 'Temporary|Tablespace'
        COLUMN  cdate  format A11      HEADING 'Creation|Date'       
        COLUMN  pfile  format A7       HEADING 'Profile'            

        TTITLE  CENTER  'Apps Locked-SchemaAccounts '  -
                LEFT    DATEVAR                                   skip 1  -
                CENTER  'E-Business Database Locked Accounts'             -
                LEFT    TIMEVAR                                   skip 2

        alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
        SELECT  TO_CHAR(sysdate, 'DD-MON-YY')   datevalue,
                TO_CHAR(sysdate, 'HH24:MI:SS')  timevalue,
                username                 uname,
                account_status                  astat,
              lock_date                  ldate,
                expiry_date              edate,
                default_tablespace       dspce,
                temporary_tablespace            tspce,
              created                           cdate,
              profile                           pfile 
        FROM  dba_users
       WHERE  account_status <> 'OPEN'
       ORDER BY username;

END_FILE

print
print  "Please see  /tmp/whataccount_$$.txt"
print
}

E-Business Suite: Who is Connected (Internet-Connections and Forms-Connections)


#!/usr/bin/ksh
#whosup ()
#------------------------------------------------------------------------------#
#    Module Name:  whosup                                                      #
#                                                                              #
#    Purpose:      Report on the NCA Users/Report Server Oracle Apps 11i:      #
#                     User, Responsibility and FormName.                       #
#                                                                              #
#    Possible Error:  gv$sesstat (Table of View Does Not Exist)                #
#                     Resolution: sysdba: GRANT SELECT on GV_$SESSTAT to APPS; #
#    Maintenance                                                               #
#    Date          Author        Description                                   #
#    -----------   ------------  --------------------------------------------  #
#    10-Oct-2009   M.Barone      Modle design/creation.
#------------------------------------------------------------------------------#
{
       DIRNAM=$(dirname $0)
       ORASID=$(echo $CONTEXT_NAME | cut -f1 -d'_')
       HNAME=$(uname -n)
        #----------------------------------------------------------------------#
        #  TEST:  Number ($#) of arguments passed to this function?            #
        #----------------------------------------------------------------------#
       if      [ $# = 0 ]
       then
           clear
           echo
           echo  " #--------------------------------------------------------#"
           echo  " # whosup:                        Oracle Apps Forms Users #"
           echo  " #--------------------------------------------------------#"
           echo                                                               
           #------------------------------------------------------------------#
           #  Trap:  Set CNTL-C CNTL-D CNTL-\ Before Password Protection      #
           #------------------------------------------------------------------#
           trap        "stty echo; return"     2                             
           trap        "stty echo; return"     3
           stty -echo
           read PASSWD?" Please Enter the Oracle APPS Passwd:  "
           stty echo
           echo
           #------------------------------------------------------------------#
           #  Trap:  Reset CNTL-C CNTL-D CNTL-\ After Password Protection     #
           #------------------------------------------------------------------#
           trap        2
           trap        3
           read DATTIM?"        Optional ReportDate DD-MON-YY: "
           if [[ $DATTIM == '' ]]
           then
              DATTIM=$(date '+%d-%b-%y')
           fi
           clear
       else
           PASSWD=$1
           clear
       fi
#------------------------------------------------------------------------------#
#  Initialize                                                                  #
#------------------------------------------------------------------------------#
       SPOOLNM=/tmp/whosup_$$.txt
#------------------------------------------------------------------------------#
#  SQL*Plus ("Here-Document")                                                  #
#------------------------------------------------------------------------------#
sqlplus  -s  /nolog  <<-END_FILE
       CONNECT  APPS/$PASSWD
       clear  BREAKS
       clear  BUFFER
       clear  COLUMNS
       clear  COMPUTES
       clear  SCREEN
       clear  SQL
       clear  TIMING
       set     pagesize     9000
       set    feedback      off
       set    flush         on
       set    heading       on
       set    pause         off
       set    space         1
       set    termout       on
       set    verify        on
       set    linesize      80
       set    pagesize      999
       SPOOL ${SPOOLNM}
        clear   BREAKS
        clear   BUFFER
        clear   COLUMNS
        clear   COMPUTES
        clear   SCREEN
        clear   SQL
        clear   TIMING
        set     feedback        off
        set     flush           on
        set     heading         on
        set     pause           off
        set     space           1
        set     termout         on
        set     verify          on
        set     linesize        80
        set     pagesize        999
       prompt #---------------------------------------------------------------#
       prompt #- ICX Connections (whosup)                                    -#
       prompt #---------------------------------------------------------------#
        COLUMN  datevalue       NOPRINT NEW_VALUE       DATEVAR
        COLUMN  timevalue       NOPRINT NEW_VALUE       TIMEVAR
        COLUMN usernam  FORMAT A10      HEADING 'UserName'          WORD_WRAPPED
        COLUMN userdsc  FORMAT A18      HEADING 'User Description'  WORD_WRAPPED
        COLUMN respnam  FORMAT A30      HEADING 'Responsibility'    WORD_WRAPPED
        COLUMN fstconn  FORMAT A9       HEADING 'ICX|Connect'       WORD_WRAPPED
        COLUMN lstconn  FORMAT A9       HEADING 'Last|ICX|Activity' WORD_WRAPPED
        TTITLE  CENTER  '${ORASID} (${HNAME}) Apps ICX Connections' -
                LEFT    DATEVAR                                     skip 1    -
              CENTER  'Sorted by UserName'                               - 
                LEFT    TIMEVAR                                     skip 1
        SELECT  DISTINCT(fndu.user_name)                            usernam,
                fndu.description                                    userdsc,
                SUBSTR(fndr.responsibility_name,1,55)               respnam,
                TO_CHAR(icxs.FIRST_CONNECT, 'DD-MON-YY HH24:MI:SS') fstconn,
                TO_CHAR(icxs.LAST_CONNECT, 'DD-MON-YY HH24:MI:SS')  lstconn,
                TO_CHAR(sysdate, 'DD-MON-YY')           datevalue,
                TO_CHAR(sysdate, 'HH24:MI:SS')          timevalue
          FROM  fnd_user                fndu,
                fnd_responsibility_vl   fndr,
                icx_sessions            icxs
         WHERE  fndu.user_id            = icxs.user_id
           AND  fndr.responsibility_id  = icxs.responsibility_id
           AND  icxs.disabled_flag      ='N'
           AND  icxs.responsibility_id  IS NOT NULL
           AND  icxs.last_connect       LIKE UPPER('$DATTIM')
       ORDER BY fndu.user_name;
       CLEAR SCREEN
       prompt
       prompt
       prompt #---------------------------------------------------------------#
       prompt #- Forms Connections (whosup)                                  -#
       prompt #---------------------------------------------------------------#
        COLUMN  datevalue       NOPRINT NEW_VALUE       DATEVAR
        COLUMN  timevalue       NOPRINT NEW_VALUE       TIMEVAR
       COLUMN usernam       format A8     HEADING       'UserName'    WORD_WRAPPED
       COLUMN formnam       format A15    HEADING       'FormName'    WORD_WRAPPED
       COLUMN shrtnam       format A5     HEADING       'Apps|Short|Name'
       COLUMN respnam       format A15    HEADING       'Responsibility' WORD_WRAPPED
       COLUMN formtim       format A9     HEADING       'FormStart|Time' WORD_WRAPPED
       COLUMN appproc       format A6     HEADING       'Apps|Server|ProcID'
       COLUMN appserv       format A7     HEADING       'Apps|Server|Name'
       COLUMN faudsid       format 9999999       HEADING       'Form|Server|AUDSID'
        TTITLE  CENTER  '${ORASID} (${HNAME}) Apps FormServer'    -
              LEFT    DATEVAR                                     skip 1  -
              CENTER  'Sorted by UserName'                               - 
                LEFT    TIMEVAR                                   skip 2
       SELECT TO_CHAR(sysdate, 'DD-MON-YY')   datevalue,
              TO_CHAR(sysdate, 'HH24:MI:SS')  timevalue,
              frm.user_name                     usernam,
              frm.user_form_name                formnam,
              avl.application_short_name        shrtnam,
              frm.responsibility_name           respnam,
              TO_CHAR(frm.time, 'DD-MON-YY HH:MI:SS')  formtim,
              ses.process                       appproc,
              ses.machine                       appserv,
              frm.audsid                        faudsid
         FROM gv\$sesstat          st1,  
              gv\$session          ses,
              fnd_form_sessions_v  frm,
              fnd_application_vl   avl
       WHERE   st1.sid                   = ses.sid
         AND   st1.inst_id        = ses.inst_id
         AND   ses.audsid         = frm.audsid
         AND   avl.application_id = frm.form_appl_id
         AND   st1.statistic#            = 9
         AND  TO_CHAR(frm.time, 'DD-MON-YY')    LIKE UPPER('$DATTIM')
       ORDER BY frm.user_name,
               frm.user_form_name;
EXIT;
END_FILE
print
print  "Please see  /tmp/whosup_$$.txt"
print
}