ECC Admin - Concurrent Programs Copy link

select
y.concurrent_program,
fcpv.concurrent_program_name short_name,
xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method,
fev.execution_file_name,
(
select distinct
listagg(fcr.request_id,'; ') within group (order by fcr.request_id) over (partition by fcr.program_application_id,fcr.concurrent_program_id) request_id
from
fnd_concurrent_requests fcr
where
fcr.argument_text like '%INCREMENTAL_LOAD%' and
(fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and
fcpv.application_id=fcr.program_application_id and
fcpv.concurrent_program_id=fcr.concurrent_program_id
) incremental_load_request_id,
(
select distinct
max(frv.responsibility_name) keep (dense_rank last order by fcr.responsibility_id) over () responsibility
from
fnd_concurrent_requests fcr,
fnd_responsibility_vl frv
where
fcr.argument_text like '%INCREMENTAL_LOAD%' and
(fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and
fcpv.application_id=fcr.program_application_id and
fcpv.concurrent_program_id=fcr.concurrent_program_id and
fcr.responsibility_application_id=frv.application_id and
fcr.responsibility_id=frv.responsibility_id
) incremental_responsibility,
(
select distinct
listagg(fcr.request_id,'; ') within group (order by fcr.request_id) over (partition by fcr.program_application_id,fcr.concurrent_program_id) request_id
from
fnd_concurrent_requests fcr
where
fcr.argument_text like '%FULL_LOAD%' and
(fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and
fcpv.application_id=fcr.program_application_id and
fcpv.concurrent_program_id=fcr.concurrent_program_id
) full_load_request_id,
(
select distinct
max(frv.responsibility_name) keep (dense_rank last order by fcr.responsibility_id) over () responsibility
from
fnd_concurrent_requests fcr,
fnd_responsibility_vl frv
where
fcr.argument_text like '%FULL_LOAD%' and
(fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and
fcpv.application_id=fcr.program_application_id and
fcpv.concurrent_program_id=fcr.concurrent_program_id and
fcr.responsibility_application_id=frv.application_id and
fcr.responsibility_id=frv.responsibility_id
) full_load_responsibility
from
(
select
case when x.text like '%Dashboard:%' then substr(x.text,instr(x.text,':')+2) else x.text end concurrent_program
from
(
select 'QP: Enterprise Command Center Data Load' text from dual union all
select 'Oracle Asset Tracking Command Center Data Load' text from dual union all
select 'Assets Command Center Data Load' text from dual union all
select 'Bills of Material ECC Data Load' text from dual union all
select 'Cash Management Command Center Data Load' text from dual union all
select 'Channel Revenue Management Command Center Data Load' text from dual union all
select 'PO CLM ECC Data Load' text from dual union all
select 'Cost Management Command Center Data Load' text from dual union all
select 'Depot Command Center Data Load' text from dual union all
select 'WIP ECC Data Load' text from dual union all
select 'WIP Completions ECC Data Load' text from dual union all
select 'Genealogy ECC Data Load' text from dual union all
select 'Enterprise Asset Management Command Center Data Load' text from dual union all
select 'Field Service Command Center Data Load' text from dual union all
select 'Electronic Kanban ECC Data Load' text from dual union all
select 'General Ledger Command Center Data Load' text from dual union all
select 'PER ECC Data Load' text from dual union all
select 'Payroll ECC Data Load' text from dual union all
select 'OIC ECC Data Load' text from dual union all
select 'Activity Dashboard: Activity Details Data Load' text from dual union all
select 'Aging Inventory Dashboard: Inventory On Hand Data Load' text from dual union all
select 'Inventory Cycle Counting Dashboard: Inventory Cycle Counting Data Load' text from dual union all
select 'Inventory Physical Inventory Data Load' text from dual union all
select 'Inventory Space Utilization Data Load' text from dual union all
select 'Inventory Track and Trace Data Load' text from dual union all
select 'Inventory Transaction Management Data Load' text from dual union all
select 'Items Dashboard: Items Dashboard Data Load' text from dual union all
select 'Move Orders Dashboard: Inventory Move Orders Data Load' text from dual union all
select 'Receiving Dashboard: Inbound Details Data Load' text from dual union all
select 'Reservations Dashboard: Inventory Reservations Data Load' text from dual union all
select 'Shipping Dashboard: Delivery Details Data Load' text from dual union all
select 'Supply/Demand Dashboard: Inventory Supply/Demand Data Load' text from dual union all
select 'iProcurement ECC Data Load' text from dual union all
select 'iStore Command Center Data Load' text from dual union all
select 'Landed Cost Data Load' text from dual union all
select 'Lease Asset Management ECC Loader' text from dual union all
select 'Lease ECC AR Cash Data Loader' text from dual union all
select 'Lease ECC Contract Revision Data Load' text from dual union all
select 'Lease ECC Data Loader' text from dual union all
select 'Lease ECC Meter Management Loader' text from dual union all
select 'Lease Period Balances Data Load' text from dual union all
select 'Property Manager ECC Data Loader' text from dual union all
select 'OM Command Center Data Load' text from dual union all
select 'OM Command Center Credit Check Data Load' text from dual union all
select 'OM Command Center Returns Data Load' text from dual union all
select 'Outsourced Manufacturing Command Center Data Load' text from dual union all
select 'Payables Command Center Data Load' text from dual union all
select 'Employee Expenses Command Center Data Load' text from dual union all
select 'Process Manufacturing Command Center Data Load' text from dual union all
select 'Process Quality Command Center Data Load' text from dual union all
select 'PO PCC ECC Data Load' text from dual union all
select 'PO ECC Supplier Analysis Data Load' text from dual union all
select 'PO ECC Strategic Sourcing Data Load' text from dual union all
select 'Project Procurement - Item Analysis ECC Data Load' text from dual union all
select 'Project Manufacturing Command Center Data Load' text from dual union all
select 'Project Procurement - Procurement Plan ECC Data Load' text from dual union all
select 'Projects Costing and Billing ECC Data Load' text from dual union all
select 'Projects Costing Budgetary Control ECC Data Load' text from dual union all
select 'Projects G-Invoicing ECC Data Load' text from dual union all
select 'Projects Investment Turn ECC Data Load' text from dual union all
select 'Quality Command Center Data Load' text from dual union all
select 'Receivables Command Center Data Load' text from dual union all
select 'Service Command Center Data Load' text from dual union all
select 'Service Contracts Command Center Data Load' text from dual
) x
) y,
fnd_concurrent_programs_vl fcpv,
fnd_executables_vl fev
where
y.concurrent_program=fcpv.user_concurrent_program_name(+) and
fcpv.executable_application_id=fev.application_id(+) and
fcpv.executable_id=fev.executable_id(+)
order by
y.concurrent_program

select y.concurrent_program, fcpv.concurrent_program_name short_name, xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method, fev.execution_file_name, ( select distinct listagg(fcr.request_id,'; ') within group (order by fcr.request_id) over (partition by fcr.program_application_id,fcr.concurrent_program_id) request_id from fnd_concurrent_requests fcr where fcr.argument_text like '%INCREMENTAL_LOAD%' and (fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and fcpv.application_id=fcr.program_application_id and fcpv.concurrent_program_id=fcr.concurrent_program_id ) incremental_load_request_id, ( select distinct max(frv.responsibility_name) keep (dense_rank last order by fcr.responsibility_id) over () responsibility from fnd_concurrent_requests fcr, fnd_responsibility_vl frv where fcr.argument_text like '%INCREMENTAL_LOAD%' and (fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and fcpv.application_id=fcr.program_application_id and fcpv.concurrent_program_id=fcr.concurrent_program_id and fcr.responsibility_application_id=frv.application_id and fcr.responsibility_id=frv.responsibility_id ) incremental_responsibility, ( select distinct listagg(fcr.request_id,'; ') within group (order by fcr.request_id) over (partition by fcr.program_application_id,fcr.concurrent_program_id) request_id from fnd_concurrent_requests fcr where fcr.argument_text like '%FULL_LOAD%' and (fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and fcpv.application_id=fcr.program_application_id and fcpv.concurrent_program_id=fcr.concurrent_program_id ) full_load_request_id, ( select distinct max(frv.responsibility_name) keep (dense_rank last order by fcr.responsibility_id) over () responsibility from fnd_concurrent_requests fcr, fnd_responsibility_vl frv where fcr.argument_text like '%FULL_LOAD%' and (fcr.phase_code='P' and fcr.hold_flag='N' or fcr.phase_code='R') and fcpv.application_id=fcr.program_application_id and fcpv.concurrent_program_id=fcr.concurrent_program_id and fcr.responsibility_application_id=frv.application_id and fcr.responsibility_id=frv.responsibility_id ) full_load_responsibility from ( select case when x.text like '%Dashboard:%' then substr(x.text,instr(x.text,':')+2) else x.text end concurrent_program from ( select 'QP: Enterprise Command Center Data Load' text from dual union all select 'Oracle Asset Tracking Command Center Data Load' text from dual union all select 'Assets Command Center Data Load' text from dual union all select 'Bills of Material ECC Data Load' text from dual union all select 'Cash Management Command Center Data Load' text from dual union all select 'Channel Revenue Management Command Center Data Load' text from dual union all select 'PO CLM ECC Data Load' text from dual union all select 'Cost Management Command Center Data Load' text from dual union all select 'Depot Command Center Data Load' text from dual union all select 'WIP ECC Data Load' text from dual union all select 'WIP Completions ECC Data Load' text from dual union all select 'Genealogy ECC Data Load' text from dual union all select 'Enterprise Asset Management Command Center Data Load' text from dual union all select 'Field Service Command Center Data Load' text from dual union all select 'Electronic Kanban ECC Data Load' text from dual union all select 'General Ledger Command Center Data Load' text from dual union all select 'PER ECC Data Load' text from dual union all select 'Payroll ECC Data Load' text from dual union all select 'OIC ECC Data Load' text from dual union all select 'Activity Dashboard: Activity Details Data Load' text from dual union all select 'Aging Inventory Dashboard: Inventory On Hand Data Load' text from dual union all select 'Inventory Cycle Counting Dashboard: Inventory Cycle Counting Data Load' text from dual union all select 'Inventory Physical Inventory Data Load' text from dual union all select 'Inventory Space Utilization Data Load' text from dual union all select 'Inventory Track and Trace Data Load' text from dual union all select 'Inventory Transaction Management Data Load' text from dual union all select 'Items Dashboard: Items Dashboard Data Load' text from dual union all select 'Move Orders Dashboard: Inventory Move Orders Data Load' text from dual union all select 'Receiving Dashboard: Inbound Details Data Load' text from dual union all select 'Reservations Dashboard: Inventory Reservations Data Load' text from dual union all select 'Shipping Dashboard: Delivery Details Data Load' text from dual union all select 'Supply/Demand Dashboard: Inventory Supply/Demand Data Load' text from dual union all select 'iProcurement ECC Data Load' text from dual union all select 'iStore Command Center Data Load' text from dual union all select 'Landed Cost Data Load' text from dual union all select 'Lease Asset Management ECC Loader' text from dual union all select 'Lease ECC AR Cash Data Loader' text from dual union all select 'Lease ECC Contract Revision Data Load' text from dual union all select 'Lease ECC Data Loader' text from dual union all select 'Lease ECC Meter Management Loader' text from dual union all select 'Lease Period Balances Data Load' text from dual union all select 'Property Manager ECC Data Loader' text from dual union all select 'OM Command Center Data Load' text from dual union all select 'OM Command Center Credit Check Data Load' text from dual union all select 'OM Command Center Returns Data Load' text from dual union all select 'Outsourced Manufacturing Command Center Data Load' text from dual union all select 'Payables Command Center Data Load' text from dual union all select 'Employee Expenses Command Center Data Load' text from dual union all select 'Process Manufacturing Command Center Data Load' text from dual union all select 'Process Quality Command Center Data Load' text from dual union all select 'PO PCC ECC Data Load' text from dual union all select 'PO ECC Supplier Analysis Data Load' text from dual union all select 'PO ECC Strategic Sourcing Data Load' text from dual union all select 'Project Procurement - Item Analysis ECC Data Load' text from dual union all select 'Project Manufacturing Command Center Data Load' text from dual union all select 'Project Procurement - Procurement Plan ECC Data Load' text from dual union all select 'Projects Costing and Billing ECC Data Load' text from dual union all select 'Projects Costing Budgetary Control ECC Data Load' text from dual union all select 'Projects G-Invoicing ECC Data Load' text from dual union all select 'Projects Investment Turn ECC Data Load' text from dual union all select 'Quality Command Center Data Load' text from dual union all select 'Receivables Command Center Data Load' text from dual union all select 'Service Command Center Data Load' text from dual union all select 'Service Contracts Command Center Data Load' text from dual ) x ) y, fnd_concurrent_programs_vl fcpv, fnd_executables_vl fev where y.concurrent_program=fcpv.user_concurrent_program_name(+) and fcpv.executable_application_id=fev.application_id(+) and fcpv.executable_id=fev.executable_id(+) order by y.concurrent_program