Find the Concurrent Request By User Level

select
user_concurrent_program_name,
responsibility_name,
request_date,
argument_text,
request_id,
phase_code,
status_code,
logfile_name,
outfile_name,
output_file_type
FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_responsibility_tl fr,
fnd_user fu
WHERE
fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id
and fcr.responsibility_id = fr.responsibility_id
and fcr.requested_by = fu.user_id
and user_name = upper(:user_name)
ORDER BY REQUEST_DATE DESC;

Find the User Name from Concurrent Request ID

select a.request_id,b.user_name from fnd_concurrent_requests a,fnd_user b where a.requested_by=b.user_id and a.request_id='&requestid';

How to Kill Long Running Concurrent Request

SELECT a.request_id, d.sid, d.serial#, a.requested_start_date
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
--v$sql e
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND d.paddr = c.addr
--AND d.sql_address = e.address
AND a.request_id = 13165515
AND a.phase_code = 'R'

ALTER SYSTEM KILL SESSION '732,1643';

Still concurrent Request running, update the table using below query

UPDATE fnd_concurrent_requests SET phase_code = ‘C’, status_code = ‘X’ WHERE request_ID = 13165515;

Find Request ID from SID

SELECT   vp.spid,
         vs.sid,
         fcr.request_id
  FROM   v$process vp,
         v$session vs,
         fnd_Concurrent_requests fcr
 WHERE   vs.paddr              = vp.addr
   AND   fcr.oracle_process_id = vp.spid
   AND   vs.sid                = :l_sid

Find Concurrent Manager Lock Session

SELECT v$access.sid, v$session.serial#
FROM v$session,v$access
WHERE v$access.sid = v$session.sid and v$access.object = ‘FND_CP_FNDSM’
GROUP BY v$access.sid, v$session.serial#;


alter system kill session ‘2000,1000’;

Find Affected Modules By Patch

select distinct aprb.application_short_name as "Affected Modules"
from ad_applied_patches aap,
ad_patch_drivers apd,
ad_patch_runs apr,
ad_patch_run_bugs aprb
where aap.applied_patch_id = apd.applied_patch_id
and apd.patch_driver_id = apr.patch_driver_id
and apr.patch_run_id = aprb.patch_run_id
and aprb.applied_flag = 'Y'
and aap.patch_name = '&PatchName';

Identify the PIDs of NodeManager, AdminServer, and all Managed servers in EBS R12.2

ps -ef | grep "NodeManager"
ps -ef | grep "weblogic.Name=AdminServer"
ps -ef | grep "weblogic.Name=forms-c4ws_server"
ps -ef | grep "weblogic.Name=forms_server"
ps -ef | grep "weblogic.Name=oafm_server"
ps -ef | grep "weblogic.Name=oacore_server"

ERROR - CLONE-20365 Error in executing WebLogic script

While doing the rapid clone in R12.2.4 application we have faced the below issue

RcloneApplyAppsTier.log:

START: Creating new WLS domain. 
Running /u01/app/oracle/TST/fs1/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u01/app/oracle/TST/fs1/EBSapps/comn/util/jdk64 -al /u01/app/oracle/TST/fs1/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u01/app/oracle/TSTX/fs1/FMW_Home/user_projects/domains/EBS_domain_TST -tmw /u01/app/oracle/TST/fs1/FMW_Home -mpl /u01/app/oracle/TST/fs1/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u01/app/oracle/TST/fs1/inst/apps/TST_oracle/admin/log/clone/run/wlsT2PApply -silent true -debug true -domainAdminPassword /u01/app/oracle/TST/fs1/EBSapps/comn/clone/FMW/tempinfo.txt 
Script Executed in 141503 milliseconds, returning status 255 
ERROR: Script failed, exit code 255 

In Clone_timestamp.log file:

Error: writeTemplate() failed. Do dumpStack() to see details.
Problem invoking WLST - Traceback (innermost last):
  File "/tmp/CLONINGCLIENT-1223456789/tmp123456789.py", line 239, in ?
  File "/tmp/WLSTOfflineIni123456789.py", line 74, in writeTemplate
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:51)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:1538)
at com.oracle.cie.domain.script.jython.WLScriptContext.writeTemplate(WLScriptContext.java:831)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)


com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: java.io.IOException: No space left on device

Solution:

Increased the /tmp mount point size as much as and rerun the adcfgclone.pl 

RC-50014: Fatal: Execution of AutoConfig was failed in R12.2

While doing R12.2 cloning we have faced this issue.

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/TEST/apps/tech_st/10.1.3/perl/bin/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /u01/oracle/TEST/inst/apps/TEST_kumar/admin/scripts/adexecsql.pl sqlfile=/u01/oracle/TEST/inst/apps/TEST_kumar/admin/install
afwebprf.sql            INSTE8_PRF         1
amscmprf.sql            INSTE8_PRF         1
amswebprf.sql           INSTE8_PRF         1
bisadmprf.sql           INSTE8_PRF         1
bisdblrp.sql            INSTE8_PRF         1
clnadmprf.sql           INSTE8_PRF         1
cncmprf.sql             INSTE8_PRF         1
cseadmprf.sql           INSTE8_PRF         1
csfadmprf.sql           INSTE8_PRF         1
csiadmprf.sql           INSTE8_PRF         1
eamadmprf.sql           INSTE8_PRF         1
fteadmprf.sql           INSTE8_PRF         1
icxwebprf.sql           INSTE8_PRF         1
oksfrmprf.sql           INSTE8_PRF         1
wshadmprf.sql           INSTE8_PRF         1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/TEST/apps/tech_st/10.1.3/perl/bin/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /u01/oracle/TEST/inst/apps/TEST_kumar/admin/install
adadmat.pl              INSTE8_APPLY       1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /u01/oracle/TEST/apps/tech_st/10.1.3/perl/bin/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/5.8.3 -I /u01/oracle/TEST/apps/tech_st/10.1.3/perl/lib/site_perl/5.8.3 -I /u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/perl -I /u01/oracle/TEST/apps/tech_st/10.1.3/Apache/Apache/mod_perl/lib/site_perl/5.8.3/i686-linux-thread-multi /u01/oracle/TEST/inst/apps/TEST_kumar/admin/install
adadmat.pl              INSTE8_APPLY       1

AutoConfig is exiting with status 16

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /u01/oracle/TEST/inst/apps/TEST_kumar/admin/log/ApplyAppsTier_10071110.log for details.
ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop
Warning : AutoConfig has completed with  errors .
Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line  after fixing the problem

Cause:

NLS_LANG parameter was already set on server.

To check $env|grep NLS

Solution:

unset NLS_LANG and then run adcfgclone.pl

Java was blocked because it is out of date and needs to be updated IE Warnings with Oracle EBS

While opening the ebs form we may get this below mentioned issue.

Java was blocked because it is out of date and needs to be updated

Solution:

Add the ebs url in trusted sites and retry the issue.

Navigation : IE Settings > Internet Options > Security > Trusted Sites > Sites > Add