ECC Admin - Concurrent Programs – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

List of all concurrent programs required to synchronize Oracle EBS data to the Enterprise Command Centers (ECC) Weblogic server, based on Oracle note KA980 https://support.oracle.com/support/?kmContentId=11154162

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

Report Parameters

Oracle EBS Tables Used

fnd_concurrent_requests, fnd_responsibility_vl, dual, fnd_concurrent_programs_vl, fnd_executables_vl

Report Categories

Enginatics, R12 only

FND Concurrent Requests 11i, FND Concurrent Requests, FND Concurrent Requests Summary, FND Responsibility Access, XDO Publisher Data Definitions, FND Concurrent Programs and Executables 11i, FND Concurrent Programs and Executables, Blitz Report RDF Import Validation, FND Concurrent Request Conflicts

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource	Link
Excel Example Output	ECC Admin - Concurrent Programs 15-Jun-2020 192701.xlsx
Blitz Report™ XML Import	ECC_Admin_Concurrent_Programs.xml
Full SQL on Enginatics	www.enginatics.com/reports/ecc-admin-concurrent-programs/