ECC Admin - Concurrent Programs

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note 2495053.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2495053.1 ...  List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note 2495053.1 https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2495053.1

The report includes all currently scheduled request_ids and responsibilities for incremental and full loads, to check which ones are already scheduled.
The short code can be used as multiple parameter value entry in other reports, e.g. https://www.enginatics.com/reports/fnd-access-control/ to see which responsibilities or users have access to schedule them, or https://www.enginatics.com/reports/fnd-concurrent-requests/ to look at past execution and schedule times.

ECC data is defined by dataset codes, which have a related DB package procedure containing the SQL for each dataset, see:
https://www.enginatics.com/reports/ecc-data-sets/

The individual load progams are all calling child program 'ECC Run Data Load' either for specific datasets or by application, and the program's java executable ECCRUNDL then executes the dataset SQL and transfers the data to the Weblogic server where it is stored in a file structure using Apache Lucene technology https://en.wikipedia.org/wiki/Apache_Lucene   more 
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
Download
Related Blitz Reports
FND Concurrent Requests 11i FND Concurrent Requests FND Concurrent Requests Summary FND Responsibility Access XDO Publisher Data Definitions FND Attachment Functions FND Concurrent Programs and Executables 11i FND Concurrent Programs and Executables Blitz Report RDF Import Validation
Blitz Report™