Request xxxxxx can no longer be canceled

 Problem:

when we try to cancel a concurrent request using the frontend “Cancel Request” button from the Administer > Concurrent > Manager form.
We are getting the following message:

“Request xxxxxx can no longer be canceled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with the error”

Solution.

connect to APPS,

1. Backup of FND_CONCURRENT_REQUESTS.

create table fnd_concurrent_requests_backup_12_Apr_22 as select * from fnd_concurrent_requests;

2. UPDATE.

UPDATE fnd_concurrent_requests

SET phase_code = ‘C’, status_code = ‘D’

WHERE Request_id=&request_id

3. Commit.

DB level collecting an traces.

Collect SID and Serial and enable the trace.

SQL> EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>3258, serial#=>10207, sql_trace=>TRUE)

PL/SQL procedure successfully completed.

SQL> SELECT p.tracefile FROM   v$session s  JOIN v$process p ON s.paddr = p.addr WHERE  s.sid = 3258;

TRACEFILE

--------------------------------------------------------------------------------

/u02/app/oracle/diag/rdbms/ebsts1/EBSTS11/trace/EBSTS11_ora_233861.trc

------------------------------------------------------------------------------------------------------------

1. Create Tigger for particular user.

2. enable the trace and collect the trace 

3. Disable the traces.

CREATE OR REPLACE TRIGGER ON_MY_SCHEMA_LOGIN

AFTER LOGON ON DATABASE

WHEN ( USER = 'XXBPC_INTF' )

BEGIN  execute immediate 'ALTER SESSION SET TRACEFILE_IDENTIFIER = "XXBPC_INTF_TRACE"';

execute immediate 'alter session set events ''10046 trace name context forever, level 12''';

EXCEPTION

WHEN OTHERS THEN

NULL;

END;

 

alter trigger ON_MY_SCHEMA_LOGIN enable;

 

 alter trigger ON_MY_SCHEMA_LOGIN disable;

Find Session Id Running Specific Query

 SET LINES 300

SET PAGES 999

COL SID FOR 99999

COL SER# FOR 9999999

COL OS_ID FOR A5

COL STATUS FOR A8

COL SQL_FULLTEXT FOR A60

SELECT

   SES.SID,

   SES.SERIAL# SER#,

   SES.PROCESS OS_ID,

   SES.STATUS,

   SQL.SQL_FULLTEXT

FROM 

   V$SESSION SES,

   V$SQL SQL,

   V$PROCESS PRC

WHERE

   SES.SQL_ID=SQL.SQL_ID AND

   SES.SQL_HASH_VALUE=SQL.HASH_VALUE AND 

   SES.PADDR=PRC.ADDR AND

   UPPER(SQL.SQL_FULLTEXT) LIKE UPPER('%CREATE%TABLE%');

Disabled Trigger

 Disabled Trigger

 

SQL> select instance_name from v$instance;

 

INSTANCE_NAME

----------------

Raneshprod

 

SQL> sho user

USER is "APPS"

 

SQL> select object_name,object_type,status from dba_objects where object_name=‘ranesh_GL’;

 

OBJECT_NAME

--------------------------------------------------------------------------------

OBJECT_TYPE             STATUS

----------------------- -------

RA_CUST_TRX_LINE_GL_DIST_BRI

TRIGGER                 VALID

 

 

SQL> SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME =‘ranesh_GL’;

 

STATUS

--------

ENABLED

 

SQL> alter trigger RA_CUST_TRX_LINE_GL_DIST_BRI disable;

 

Trigger altered.

 

SQL> SELECT STATUS FROM USER_TRIGGERS WHERE TRIGGER_NAME =‘ranesh_GL’;

 

 

STATUS

--------

DISABLED

 

HOW TO GET SQL_ID FOR A PARTICULAR REQUEST

 col oracle_process_id format a5 head OSPID

col inst_name format a10

col sql_text format a30

col outfile_tmp format a30

col logfile_tmp format a30

select /*+ ordered */

fcr.request_id,

fcp.user_concurrent_program_name

,      round(24*60*( sysdate - actual_start_date )) elapsed

,      fcr.oracle_process_id

,      sess.sid

,      sess.serial#

,      inst.inst_name

,      sa.SQL_ID

from   apps.fnd_concurrent_requests fcr

,      apps.fnd_concurrent_programs_tl fcp

,      apps.fnd_concurrent_processes cp

,      apps.fnd_user fu

,      gv$process pro

,      gv$session sess

,      gv$sqlarea sa

,      sys.v_$active_instances inst

where  fcp.concurrent_program_id = fcr.concurrent_program_id

and    fcp.application_id = fcr.program_application_id

and    fcr.controlling_manager = cp.concurrent_process_id

and    fcr.requested_by = fu.user_id (+)

and    fcr.oracle_process_id = pro.spid (+)

and    pro.addr = sess.paddr (+)

and    sess.sql_address = sa.address (+)

and    sess.sql_hash_value = sa.hash_value (+)

and    sess.inst_id = inst.inst_number (+)

and    request_id='&req_id';

How to Generate fmx from fmb in R12

 1) Login to application server.

2) Go to the directory $AU_TOP/forms/US

3) Place “.fmb” file in binary mode or search for existing --> ls -ltrh *.fmb

4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EBS R12.2 Log file locations

EBS R12.2 Log file locations

$INST_TOP/logs/appl/admin/log-------Start/Stop Logfiles

$IAS_ORACLE_HOME/ instances//diagnostics/logs-------Log files for OPMN and OHS processes

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log --------Weblogic Nodemanager

$IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log------Apache Logs

$IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/----OPMN Logs

$IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager

$EBS_DOMAIN_HOME/servers/oa/logs/

$EBS_DOMAIN_HOME/servers/forms/logs/

$EBS_DOMAIN_HOME/servers/AdminServer/logs/*

$EBS_DOMAIN_HOME/sysman/log/*         -------------------Weblogic Logs