Concurrent Processing / APPS Reporting Scripts

Concurrent Manager Scripts

Non Destructive Script to Clean Concurrent Manager Tables

CMCLEAN.sql
This script re-sets the flags for requests to completed to allow the Managers to come up
(For all Releases of Apps.)


How To Re-create Concurrent Manager Views

This script details how to Re-create the Concurrent Manager Views
(For all Releases of Apps.)


Concurrent Manager Check Script
CCM.sql
This script will diagnose Concurrent Managers and Concurrent Requests
(For all Releases of Apps.)


Concurrent Manager Check Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Apps. 11.5.3 or higher)


Internal Manager Log Script
ICMLOG.sql
This script will provide the location for Retrieving the Internal Manager Log file
(For For all Releases of Apps.)


Concurrent Requests Scripts
Concurrent Request Log Script
CMLOGS.txt
Script for Retrieving Log Files Associated to a Concurrent Request
(For For all Releases of Apps.)


Concurrent Request Check Script
REQCHECK.sql
Script for diagnosing problematic Concurrent Requests
(For all Releases of Apps.)


Analyze Pending Requests Script
ANALYZEPENDING.sql
Script for diagnosing Pending Concurrent Requests
(For all Releases of Apps.)


Analyze Request Script
ANALYZEREQ.sql
Script for Providing a Detailed Analysis of One Concurrent Request
(For Applications Release 11 and up.)


Who Can Run which Requests
WHOCANRUN.sql
Script that lists Responsibilities that can Run a Given Concurrent Program
(For all Releases of Apps.)


Concurrent Request Diagnostic Script
FNDCCMDiagnostic115.sh
This script will diagnose Concurrent Managers and Concurrent Requests
(For Applications Release 11.5.3 and up.)


Concurrent Request Diagnostic Script
bde_request.sql
Process and Session info for one Concurrent Request
(For Applications Release 11.5 and up.)


Printing Script
FNDPrinterValidation115.sh
This script checks a customer's Printer configuration/setup within Oracle Applications.
(For Applications Release 11.5.3 and up.)


Report Review Agent Script
FNDValidateFNDFS115.sh
This script checks basic setup of the concurrent processing tier report review agent.
(For Applications Release 11.5.3 and up.)


You can download the scripts from metalink.

Concurrent Processing (CP) / APPS Reporting Scripts Doc ID: Note:213021.1