Concurrent Manager Scripts

Non Destructive Script to Clean Concurrent Manager Tables
CMCLEAN.sql(<– Click here for details & download)
This script re-sets the flags for requests to completed to allow the Managers to come up

How To Re-create Concurrent Manager Views
How To Re-create Concurrent Manager Views(<– Click here for details & download)
This script details how to Re-create the Concurrent Manager Views

Concurrent Manager Check Script
CCM.sql(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Concurrent Manager Check Script
FNDCCMDiagnostic115.sh(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Internal Manager Log Script
ICMLOG.sql(<– Click here for details & download)
This script will provide the location for Retrieving the Internal Manager Log file
Concurrent Request Log Script
CMLOGS.txt(<– Click here for details & download)
Script for Retrieving Log Files Associated to a Concurrent Request

Concurrent Request Check Script
REQCHECK.sql(<– Click here for details & download)
Script for diagnosing problematic Concurrent Requests

Analyze Pending Requests Script
ANALYZEPENDING.sql(<– Click here for details & download)
Script for diagnosing Pending Concurrent Requests

Analyze Request Script
ANALYZEREQ.sql(<– Click here for details & download)
Script for Providing a Detailed Analysis of One Concurrent Request

Who Can Run which Requests
WHOCANRUN.sql(<– Click here for details & download)
Script that lists Responsibilities that can Run a Given Concurrent Program

Concurrent Request Diagnostic Script
FNDCCMDiagnostic115.sh(<– Click here for details & download)
This script will diagnose Concurrent Managers and Concurrent Requests

Concurrent Request Diagnostic Script
bde_request.sql(<– Click here for details & download)
Process and Session info for one Concurrent Request
Printing Script
FNDPrinterValidation115.sh(<– Click here for details & download)
This script checks a customer’s Printer configuration/setup within Oracle Applications.
Report Review Agent Script
FNDValidateFNDFS115.sh(<– Click here for details & download)
This script checks basic setup of the concurrent processing tier report review agent.

Output Post Processor Service Not Coming Up

Symptoms

After cloning when GSM profile is set to N, all managers are coming up except the Output Post Processor Manager as expected, however, when GSM is set to Y, none of the managers come up.

The error seen in the Internal Manager log file is:
Could not contact Service Manager FNDSM_<SID_HOSTNAME>. The TNS alias could not be located, the listener process on <SID> could not be contacted, or the listener failed to spawn the Service Manager process.

Reason

Service Manager for the node is not running. The service manager definition is missing under Concurrent ->Manager ->Define form.
If the Service Manager is not present/defined for a particular node, then this causes all the services provided by Service Manager like OPP,WF etc.. not to work.

Solution

To implement the solution, please execute the following steps:
1. Shutdown all the services.

2. Log in as applmgr
cd to $FND_TOP/patch/115/sql
Run the script: afdcm037.sql

3. Relink FNDSM and FNDLIBR executables as mentioned below:
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

4. Run cmclean.sql

5. Start up the managers/services and retest.