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 Requests
REM ## Author: Brian Kerr
REM ## Email: [email protected]
REM ## Filename: reqcheck.sql
REM ## Cert: 10.7, 11, 11.5, 12
REM ## Note:
REM ## Usage: sqlplus apps/ @reqcheck.sql
REM ## Output: reqcheck.lst
REM ## 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.lst
prompt There should never be more than 3-4K records
select count(*) from fnd_concurrent_requests;
prompt Please Run Purge Concurrent Requests /and or Manager Data if => 3K

prompt There should never be more than 3-4K records
select count(*) from fnd_concurrent_processes;
prompt Please Run Purge Concurrent Requests /and or Manager Data if => 3K

prompt 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_requests
where phase_code='T';

prompt If records found, Update fnd_concurrent_requests set phase_code='C'
prompt where phase_code = 'P' to Purge Pending Requests
select count(*) from fnd_concurrent_requests
where phase_code='P';

prompt Limits the Number of Requests Run Simultaneously by each User
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Active Request Limit';

prompt Setting this option to YES will enable the 'Submit a New Request' button
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Enable Request Submission in View Mode';

prompt Enables you to automatically place requests on hold after submission
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Hold Requests';

prompt Determines access privs to report output/log files
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Report Access Level';

prompt The value for number of Report Copies Currently Set
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Report Copies';

prompt Determines the Priority of a Request upon Submission
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Request Priority';

prompt Identifies the domain within which all the incompatibilities
prompt between programs has to be resolved
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Conflicts Domain';

prompt Setting this option to YES will save the output from a concurrent
prompt request to a file.
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Save Output';

prompt Setting this option to YES will force concurrent requests to run sequentially
prompt in the order in which they were submitted.
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Sequential Requests';

prompt Set this option to YES to show request set stages in the concurrent
prompt request screens.
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and 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 to
prompt see the Request Summary form after each submission.
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and 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 Transaction
prompt Manager to become available before trying a different Transaction Manager.
select c.profile_option_value
from fnd_profile_options a, fnd_profile_options_tl b, fnd_profile_option_values c
where a. profile_option_name = b.profile_option_name
and a.profile_option_id = c.profile_option_id
and c.level_id = 10001
and b.user_profile_option_name = 'Concurrent:Wait for Available TM';

spool off