Diagnostic Script for Concurrent Requests

source:REQCHECK.sql - Diagnostic Script for Concurrent Requests (Doc ID 164978.1)

This Script is made available for Diagnosing Common Problems Related to Concurrent Requests.

REM #########################################################################REM ## Purpose: Diagnostic Script for Concurrent RequestsREM ## Author: Brian KerrREM ## Email: [e-mail] ## Filename: reqcheck.sqlREM ## Cert: 10.7, 11, 11.5, 12REM ## Note:REM ## Usage: sqlplus apps/ @reqcheck.sqlREM ## Output: reqcheck.lstREM ## Notes:REM ## a. The selects below run against system level only.REM ## b. Include Responsibility & User level queries - Open.REM ## c. '0 Rows Selected' represents that the Profile Option is Not Set.REM ##REM ## $Id: reqcheck.sql, v 1.2 2001/11/18 17:20:00 bkerr Exp $REM #########################################################################spool reqcheck.lstprompt There should never be more than 3-4K recordsselect count(*) from fnd_concurrent_requests;prompt Please Run Purge Concurrent Requests /and or Manager Data if => 3Kprompt There should never be more than 3-4K recordsselect count(*) from fnd_concurrent_processes;prompt Please Run Purge Concurrent Requests /and or Manager Data if => 3Kprompt If records found, Update fnd_concurrent_requests set phase_code='C'prompt and status_code='E' where phase_code='T'select count(*) from fnd_concurrent_requestswhere phase_code='T';prompt If records found, Update fnd_concurrent_requests set phase_code='C'prompt where phase_code = 'P' to Purge Pending Requestsselect count(*) from fnd_concurrent_requestswhere phase_code='P';prompt Limits the Number of Requests Run Simultaneously by each Userselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Active Request Limit';prompt Setting this option to YES will enable the 'Submit a New Request' buttonselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Enable Request Submission in View Mode';prompt Enables you to automatically place requests on hold after submissionselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Hold Requests';prompt Determines access privs to report output/log filesselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Report Access Level';prompt The value for number of Report Copies Currently Setselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Report Copies';prompt Determines the Priority of a Request upon Submissionselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Request Priority';prompt Identifies the domain within which all the incompatibilitiesprompt between programs has to be resolvedselect c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Conflicts Domain';prompt Setting this option to YES will save the output from a concurrentprompt request to a file.select c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Save Output';prompt Setting this option to YES will force concurrent requests to run sequentiallyprompt in the order in which they were submitted.select c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Sequential Requests';prompt Set this option to YES to show request set stages in the concurrentprompt request screens.select c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Show Requests Set Stages';prompt Set this option to NO if you have multiple requests to submit and do not wish toprompt see the Request Summary form after each submission.select c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent: Show Requests Summary After Each Request Submission';prompt Specifies the number of minutes that a client will wait for a given Transactionprompt Manager to become available before trying a different Transaction Manager.select c.profile_option_valuefrom fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values cwhere a. profile_option_name = b.profile_option_nameand a.profile_option_id = c.profile_option_idand c.level_id = 10001and b.user_profile_option_name = 'Concurrent:Wait for Available TM';spool off