How to Cancel a Concurrent Request Stuck in the Queue

Cause:

Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form.

 Got the following message:

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

Solution :

 

SQL> UPDATE fnd_concurrent_requests

     SET phase_code = 'C', status_code = 'X'

     WHERE request_id = '<request id>';

     commit;

How to Cancel a Concurrent Request Stuck in the Queue? [ID 749748.1]

ANALYZEREQ.SQL Detailed Analysis of One Concurrent Request (Release 11 and up) [ID 134035.1]

Configuration in a DMZ / External Node

To Configure  External Node :

Profile : System

Select  Server

Site level  Profile (Node Trust Level ) àfind  -- >Site Should be  Normal  --- Server ---(external)

1.  Login to Oracle E-Business Suite as sysadmin user using the internal URL

2.  Select System Administrator Responsibility

3.  Select Profile / System

4.  From the ‘Find system profile option Values’ window, select the server that you want to make external

5.  Query for %NODE%TRUST%. You will see a profile option named ‘Node Trust Level‘. The value for this profile option at site level will be Normal. Leave this setting as is

6.  Set the value of this profile option to External at the server level (not site level). The site-level value should remain Normal.

Note:

Please check  Note Id : 384248.1

E-BS R12 Configuration in a DMZ [ID 380490.1]
Tips and Queries for Troubleshooting Advanced Topologies [ID 364439.1]