Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Thursday, October 27, 2016

Enable Automatic Compilation of JSP pages in R12 Environment

Release 12.0 and 12.1 using OC4J:

In Release 12 the (automatic) compilation of a JSP is disabled and, at runtime,
only the pre-compiled JSP's are picked up.

In cases where development activities are done and JSP pages are changing often this default setting makes things more complicated. Each time a JSP is deployed a manual compilation using the ojspCompile.pl is needed and the OC4J running the oacore needs a restart to pick up the changes.
This will also affect other people working on the same environment.

This can be achieved by performing the following:
  • Login into E-Business suite and select System Administrator responsibility
  • Select function AutoConfig (under Oracle Applications Manager) (*)
  • For each web tier server perform the following: 
    •  Click on pencil icon under Edit Parameters
    •  Select tab System
    •  Expand section jtff_server
    •  Change value for the entry s_jsp_main_mode from justrun to recompile
    •  Confirm the change by clicking Save button
  • Run AutoConfig to propagate the changes to the configuration files
  • Verify that the $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml  has the following:
                 <init-param>
                 <param-name>main_mode</param-name>
                 <param-value>recompile</param-value>
                 </init-param>

  • Restart the web tier services
  • Request a JSP in the browser which is compiled. See that a new _<jspname>.class is created in _pages
  • Make a change in the JSP file
  • Request it again in the browser. See that _<jspname>.class is 'refreshed' in _pages and the change is seen in the browser



Release 12.2 using WLS:

  • In Release 12.2 it's currently not possible to enable automatic recompilation of JSP pages.



Checking Socket and Servlet Mode for Oracle EBS Application


Oracle Applications Release 12:

Note Oracle Application Release 12 is, by default, configured to run in servlet mode.
Use the following command:
$ grep connectMode FORMS_WEB_CONFIG_FILE
The current connection mode is reported:
connectMode=servlet
Alternatively, use the following command:
$ grep_frmConnectMode CONTEXT_FILE
The current connection mode is reported:
<forms_connect oa_var="s_frmConnectMode">servlet</forms_conr....


Oracle Applications Release 11:

Note Oracle Application Release 11 is, by default, configured to run in socket mode.
Use the following command:
$ grep connectMode FORMS60_WEB_CONFIG_FILE
The current connection mode is reported:
connectMode=socket
Alternatively, use the following command:
$ grep socket CONTEXT_FILE
The current connection mode is reported:
<forms_connect oa_var="s_frmConnectMode">socket</forms_conr....

Thursday, August 4, 2016

Query To Get FND User Details


Download(fnduserstat.sql)

REM +======================================================================+
REM                    
REM File Name: fnduserstat.sql
REM 
REM Description:
REM   Query To Get FND User Details
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fnduserstat.sql 
REM 
REM Input Required:
REM    USER_NAME : FND User Name
REM   
REM +======================================================================+

ACCEPT USER_NAME PROMPT "Enter FND User Name: ";

SET lines 180
COL USER_NAME for a15
COL LAST_UPDATED_BY for a15
COL user_status for a12
COL password_status for a20
SELECT user_id, user_name, start_date, end_date, CASE
   WHEN end_date IS NULL OR end_date > SYSDATE
     THEN 'ACTIVE'
   ELSE 'INACTIVE'
    END user_status, CASE
   WHEN encrypted_user_password = 'INVALID'
     THEN 'LOCKED'
   ELSE 'OPEN'
    END password_status, TO_CHAR (last_update_date, 'DD-MON-YYYY HH24:MI:SS') "LAST_UPDATE_DATE", 
    (SELECT fu.user_name
   FROM apps.fnd_user fu
  WHERE fu.user_id = (a.last_updated_by)) "LAST_UPDATED_BY"
  FROM apps.fnd_user a
 WHERE user_name = upper('&USER_NAME');

undef USER_NAME

Query To Check FND Languages Installed in Oracle EBS


Download(fndlangs.sql)

REM +======================================================================+
REM                    
REM File Name: fndlangs.sql
REM 
REM Description:
REM   Query To Check FND Languages Installed in Oracle EBS 
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fndlangs.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
set pages 50
col LANGUAGE_CODE for a15
col NLS_LANGUAGE for a20
col ISO_LANGUAGE for a15
col INSTALLED_FLAG for a15
SELECT LANGUAGE_CODE,NLS_LANGUAGE, ISO_LANGUAGE,INSTALLED_FLAG 
FROM APPS.FND_LANGUAGES 
WHERE INSTALLED_FLAG IN ('B','I');

Query To Get FND NODES Details


Download(fndnodes.sql)

REM +======================================================================+
REM                    
REM File Name: fndnodes.sql
REM 
REM Description:
REM   Query To Get FND NODES Details 
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fndnodes.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
set pages 50
col NODE_NAME for a15 WORD_WRAPPED
COL SUPPORT_DB for a12
COL SUPPORT_CP for a12
COL SUPPORT_ADMIN for a15
COL SUPPORT_FORMS for a15
COL SUPPORT_WEB for a12
COL HOST for a15 WORD_WRAPPED
Col STATUS for a10
col DOMAIN for a20 WORD_WRAPPED
select NODE_NAME,SUPPORT_DB,SUPPORT_CP,SUPPORT_ADMIN,SUPPORT_WEB,SUPPORT_FORMS,STATUS,HOST,DOMAIN 
from apps.fnd_nodes;

Query To Check Oracle EBS Version, OATM Status and other Basic Details



Download(ebsbasic.sql)

REM +======================================================================+
REM                    
REM File Name: ebsbasic.sql
REM 
REM Description:
REM   Query To Check Oracle EBS Version, OATM Status and other Basic Details
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @ebsbasic.sql 
REM   
REM +======================================================================+

clear columns
set lines 180
 set pages 50
 col RELEASE_NAME for a12
 col MULTI_ORG_FLAG for a15
 col APPLICATIONS_SYSTEM_NAME for a25
 col "IS_NEW_TS_MODE(OATM_ENABLED)" for a30
 select APPLICATIONS_SYSTEM_NAME,RELEASE_NAME,version "DB_VERSION",MULTI_ORG_FLAG,IS_NEW_TS_MODE "IS_NEW_TS_MODE(OATM_ENABLED)" 
 from apps.fnd_product_groups,v$instance;

Friday, July 29, 2016

Query To Get Oracle SID Details for a Given Concurrent Request ID


Download(sidfrmreqid.sql)

REM +======================================================================+
REM                    
REM File Name: sidfrmreqid.sql
REM 
REM Description:
REM   Query To Get Oracle SID Details for a Given Concurrent Request ID
REM   
REM Notes:
REM   Usage: sqlplus "/ as sysdba" @sidfrmreqid.sql 
REM 
REM Input Required:
REM    REQID : Concurrent Request ID
REM   
REM +======================================================================+

SELECT s.inst_id,a.request_id,s.sid,s.serial#,c.spid
  FROM apps.fnd_concurrent_requests a, gv$process c, gv$session s
    WHERE a.request_id in ('&REQID')
   AND s.paddr = c.addr
         AND a.oracle_process_id = c.spid
         AND a.phase_code = UPPER ('R');