Reports 2017-11-18T12:27:27+00:00

FND Concurrent Program Incompatibilities

Description
Categories: Application, Enginatics
Concurrent Program Incompatibilities

select
fav.application_name,
fcpv.user_concurrent_program_name program,
fcpv.concurrent_program_name short_name,
fav2.application_name incompatible_application_name,
fcpv2.user_concurrent_program_name incompatible_program,
fcpv2.concurrent_program_name incompatible_short_name,
decode(fcps.to_run_type,'P', 'Program', 'S', 'Set') scope,
decode(fcps.incompatibility_type,'G','Global','D','Domain') type
from
fnd_concurrent_program_serial fcps,
fnd_concurrent_programs_vl fcpv,
fnd_concurrent_programs_vl fcpv2,
fnd_application_vl fav,
fnd_application_vl fav2
where
fcpv.concurrent_program_name='GLPPOS' and
1=1 and
fcps.running_application_id=fcpv.application_id and
fcps.running_concurrent_program_id=fcpv.concurrent_program_id and
fcps.to_run_application_id=fcpv2.application_id and
fcps.to_run_concurrent_program_id=fcpv2.concurrent_program_id and
fcps.running_application_id=fav.application_id and
fcps.to_run_application_id=fav2.application_id
order by
fav.application_name,
fcpv.user_concurrent_program_name,
fcpv.concurrent_program_name,
fav2.application_name,
fcpv2.user_concurrent_program_name

Parameter Name SQL text Validation
Concurrent Program Name
upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name)
LOV
Concurrent Program Short Name
upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name)
LOV
Application Name
fav.application_name=:application_name
LOV