How to find All E-Business Suite Profile Option Settings related to Concurrent Processing

How to find All E-Business Suite Profile Option Settings related to Concurrent Processing

Execute below script as apps user


select t.PROFILE_OPTION_ID, t.PROFILE_OPTION_NAME, z.language, z.USER_PROFILE_OPTION_NAME,
v.PROFILE_OPTION_VALUE, z.DESCRIPTION
from fnd_profile_options t, fnd_profile_option_values v, fnd_profile_options_tl z
where (v.PROFILE_OPTION_ID (+) = t.PROFILE_OPTION_ID)
and (v.level_id = 10001)
and (z.PROFILE_OPTION_NAME = t.PROFILE_OPTION_NAME)
and (t.PROFILE_OPTION_NAME in ('CONC_GSM_ENABLED','CONC_PP_RESPONSE_TIMEOUT','CONC_TM_TRANSPORT_TYPE','GUEST_USER_PWD',
'AFLOG_ENABLED','AFLOG_FILENAME','AFLOG_LEVEL','AFLOG_BUFFER_MODE','AFLOG_MODULE','FND_FWK_COMPATIBILITY_MODE',
'FND_VALIDATION_LEVEL','FND_MIGRATED_TO_JRAD','AMPOOL_ENABLED',
'CONC_PP_PROCESS_TIMEOUT','CONC_DEBUG','CONC_COPIES','CONC_FORCE_LOCAL_OUTPUT_MODE','CONC_HOLD','CONC_CD_ID','CONC_PMON_METHOD',
'CONC_PP_INIT_DELAY','CONC_PRINT_WARNING','CONC_REPORT_ACCESS_LEVEL','CONC_REQUEST_LIMIT','CONC_SINGLE_THREAD',
'CONC_TOKEN_TIMEOUT','CONC_VALIDATE_SUBMISSION','FND_CONC_ALLOW_DEBUG','CP_INSTANCE_CHECK'))
order by z.USER_PROFILE_OPTION_NAME;

ID	PROFILE OPTION NAME	LANGUAGE	PROFILE	VALUE	DESCRIPTION
8479	AFLOG_BUFFER_MODE	US	FND: Debug Log Mode	2	Asynchronous Logging Mode
4176	AFLOG_ENABLED	US	FND: Debug Log Enabled	N	Log Enabled. If this is No ('N') then logging & alerting will not occur at runtime.
3099	AFLOG_LEVEL	US	FND: Debug Log Level	6	Minimum level for Logging. If this profile isn't set, the default level is 6 (UNEXPECTED).
6616	AMPOOL_ENABLED	US	FND: Application Module Pool Enabled	Y	Application Module Pool Enabled. If this is No ('N') then application module pooling will be disabled.
111	CONC_COPIES	US	Concurrent:Report Copies	0	Number of copies to print for a concurrent process
4175	CONC_GSM_ENABLED	US	Concurrent:GSM Enabled	Y	Enable Generic Service Management