ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
8E2FF36EDEFA79D2E0530100007F1FF2
Blitz Report Category
Y
select
xrcv.category value,
(select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description
from
xxen_report_categories_v xrcv
order by
xrcv.category
US
028C2F5E98A1A51DE0630100007F0DD5
Blitz Report Type
Y
select
xrv.type_dsp value,
count(*) description
from
xxen_reports_v xrv
group by
xrv.type_dsp
order by
count(*) desc
US
8E2FF36EDE8479D2E0530100007F1FF2
FND User Name
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
US
FND user names, excluding iRecruitment candidates.
8E2FF36EDEA679D2E0530100007F1FF2
Yes
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
US
49A8B1A8038D08ACE0530100007FEB91
select
x.request_id,
xxen_util.client_time(x.start_date) start_date,
x.report_name,
x.category,
decode(x.type,'P','Protected','S','System','U','Upload','F','FSG') type,
x.user_name,
x.responsibility_name responsibility,
x.options,
¶meters
x.status,
xxen_util.client_time(x.completion_date) completion_date,
xxen_util.time(x.seconds) time,
x.seconds,
x.row_count,
round(x.row_count/decode(x.seconds,0,0.25,x.seconds),2) rows_second,
x.file_size,
xxen_util.client_time(x.actual_completion_date) request_completion_date,
(x.actual_completion_date-x.completion_date)*86400 file_writing_seconds,
x.upload_request_id,
x.upload_file_name,
x.upload_errors,
x.run_id,
x.report_id
from
(
select
case when xrr.request_id>-1 then xrr.request_id end request_id,
xxen_util.user_name(xrr.created_by) user_name,
frt.responsibility_name,
coalesce(xrv.report_name,
(select distinct min(xrh.report_name||' (deleted)') keep (dense_rank last order by xrh.creation_date) over () report_name from xxen_reports_h xrh where xrr.report_id=xrh.report_id and xrr.creation_date>xrh.creation_date),
(select fcr.argument1||' (deleted)' from fnd_concurrent_requests fcr where xrr.request_id=fcr.request_id)
) report_name,
xrrpv0.options,
coalesce(xrr.completion_message,
nvl2(fcr.request_id,
decode(fcr.phase_code,'P','Pending - ','R','Running - ')||trim(
xxen_util.meaning(case when not (fcr.phase_code='C' and fcr.status_code='C') then
decode(fcr.phase_code,'P',decode(fcr.hold_flag,'Y','H',decode(sign(fcr.requested_start_date-sysdate),1,'P',fcr.status_code)),'R',decode(fcr.hold_flag,'Y','S',decode(fcr.status_code,'Q', 'B','I', 'B',fcr.status_code)),fcr.status_code)
end,'CP_STATUS_CODE',0)
),
nvl2(xrr.completion_date,null,nvl2(gs.run_id,'Running - Online','Error'))),
'Completed') status,
nvl(xrr.start_date,xrr.creation_date) start_date,
xrr.completion_date completion_date,
round((nvl(xrr.completion_date,nvl2(gs.run_id,sysdate,fcr.actual_completion_date))-nvl(xrr.start_date,xrr.creation_date))*86400) seconds,
xrr.row_count,
xrr.file_size,
fcr.actual_completion_date,
xrv.category,
xrr.type,
xrr.upload_request_id,
xrr.upload_file_name,
xrr.upload_errors,
xrr.run_id,
xrr.report_id
from
xxen_report_runs xrr,
xxen_reports_v xrv,
fnd_concurrent_requests fcr,
fnd_responsibility_tl frt,
(select distinct xxen_util.instring(gs.action,'|',1) run_id from gv$session gs where regexp_like(gs.action,'^\d+\|.*') and gs.module like 'XXEN_REPORT - %' and gs.status='ACTIVE') gs,
(
select distinct
x.run_id,
listagg(x.parameter_name||': '||x.value,chr(10)) within group (order by x.parameter_id desc) over (partition by x.run_id) options
from
(
select
xrrpv.run_id,
xrrpv.parameter_id,
(select flv.description from fnd_lookup_values flv where xrrpv.parameter_id=flv.tag and flv.lookup_type like 'XXEN_REPORT_TRANSLATIONS' and flv.meaning like 'RUNTIME_OPTIONS.%' and flv.language=userenv('lang') and flv.view_application_id=0) parameter_name,
xrrpv.value
from
xxen_report_run_param_values xrrpv
where
xrrpv.parameter_id<0
) x
) xrrpv0
where
1=1 and
xrr.report_id=xrv.report_id(+) and
xrr.request_id=fcr.request_id(+) and
xrr.responsibility_application_id=frt.application_id(+) and
xrr.responsibility_id=frt.responsibility_id(+) and
frt.language(+)=userenv('lang') and
xrr.run_id=gs.run_id(+) and
xrr.run_id=xrrpv0.run_id(+)
) x
order by
x.run_id desc
Added the additional upload columns from xxen_report_runs
Y
US
Blitz Report History
History of Blitz Report executions
Enginatics
¶meters
1=1
1
10
1=1
xrr.report_id in (
select xrv0.report_id from xxen_reports_v xrv0 where lower(xrv0.report_name) like lower(:report_name) union
select xrh.report_id from xxen_reports_h xrh where lower(xrh.report_name) like lower(:report_name)
)
LOV custom
Y
select
xrv.report_name value,
xrv.description description
from
xxen_reports_v xrv
where
xrv.report_id in (select xrr.report_id from xxen_report_runs xrr where :$flex$.Started_within_Days is null or xrr.start_date>=sysdate-:$flex$.Started_within_Days)
order by
xrv.report_name
F
Nom du rapport
US
Report Name
2
20
1=1
xrr.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
LOV
Blitz Report Category
8E2FF36EDEFA79D2E0530100007F1FF2
Y
select
xrcv.category value,
(select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description
from
xxen_report_categories_v xrcv
order by
xrcv.category
US
Category
3
30
1=1
xrv.type_dsp=:type
LOV
Blitz Report Type
028C2F5E98A1A51DE0630100007F0DD5
Y
select
xrv.type_dsp value,
count(*) description
from
xxen_reports_v xrv
group by
xrv.type_dsp
order by
count(*) desc
US
Type
4
40
1=1
xrr.report_id in (
select xrv0.report_id from xxen_reports_v xrv0 where lower(xrv0.report_name) like lower(:report_name_starts_with)||'%' union
select xrh.report_id from xxen_reports_h xrh where lower(xrh.report_name) like lower(:report_name_starts_with)||'%'
)
Char
F
Le nom du rapport commence par
US
Report Name starts with
5
50
1=1
xrr.created_by=xxen_util.user_id(:created_by)
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Soumis par l'utilisateur
US
Submitted by User
6
60
1=1
xrr.creation_date>sysdate-:days
Number
select 10 from dual where
:$flex$.report_name is null and
:$flex$.report_name_starts_with is null and
:$flex$.submitted_by_user is null and
:$flex$.start_date_from is null and
:$flex$.request_id is null and
:$flex$.run_id is null and
:$flex$.license_exceeded is null
F
Commencé en quelques jours
US
Started within Days
7
70
1=1
xrr.creation_date>=:start_date_from
Date
F
Date de début de
US
Start Date From
8
80
1=1
xrr.creation_date<:start_date_to+1
Date
:$flex$.start_date_from+86399/86400
F
Date de début au
US
Start Date To
9
90
¶meters
xxen_api.parameters(x.run_id) parameters,
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
Y
US
Show Parameters
10
100
1=1
(xrr.completion_date is null or xrr.completion_message is not null)
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
F
En cours ou erroné
US
Running or Errored
11
110
1=1
xrr.request_id=:request_id
LOV custom
Y
select
xrr.request_id value,
nvl(xrr.start_date,xrr.creation_date)||' '||xrv.report_name description
from
xxen_report_runs xrr,
xxen_reports_v xrv
where
(:$flex$.started_within_days is null or xrr.creation_date>sysdate-:$flex$.started_within_days) and
(:$flex$.start_date_from is null or xrr.creation_date>=:$flex$.start_date_from) and
xrr.request_id is not null and
xrr.report_id=xrv.report_id(+)
order by
xrr.run_id desc
US
Request Id
12
120
1=1
xrr.run_id=:run_id_
LOV custom
Y
select
xrr.run_id value,
nvl(xrr.start_date,xrr.creation_date)||' '||xrv.report_name description
from
xxen_report_runs xrr,
xxen_reports_v xrv
where
(:$flex$.started_within_days is null or xrr.creation_date>sysdate-:$flex$.started_within_days) and
(:$flex$.start_date_from is null or xrr.creation_date>=:$flex$.start_date_from) and
xrr.report_id=xrv.report_id(+)
order by
xrr.run_id desc
US
Run Id
13
130
1=1
nvl(xrr.type,'x')<>'S'
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
select 'Y' from dual where :$flex$.report_name is null and nvl(:$flex$.type,'x')<>'System'
F
Exclure les rapports du système
US
Exclude System Reports
14
140
1=1
xrr.created_by<>xxen_util.user_id(:exclude_user)
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Exclure les soumissions de l'utilisateur
US
Exclude Submissions from User
15
150
1=1
xrr.completion_message like 'maximum%'
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
US
License Exceeded
16
160
1=1
xrr.creation_date>=
(
select
fcr0.actual_start_date
from
fnd_concurrent_requests fcr,
fnd_concurrent_requests fcr0
where
fcr.request_id=fnd_global.conc_request_id and
fcr.parent_request_id=fcr0.request_id
)
LOV
Yes
8E2FF36EDEA679D2E0530100007F1FF2
Y
select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual
US
Incremental Alert Mode
Only show requests since the last scheduled report run
:$flex$.Started_within_Days
Started within Days
Report Name
:$flex$.license_exceeded
License Exceeded
Started within Days
:$flex$.report_name
Report Name
Exclude System Reports
:$flex$.report_name
Report Name
Started within Days
:$flex$.report_name_starts_with
Report Name starts with
Started within Days
:$flex$.request_id
Request Id
Started within Days
:$flex$.run_id
Run Id
Started within Days
:$flex$.start_date_from
Start Date From
Y
Request Id
:$flex$.start_date_from
Start Date From
Y
Run Id
:$flex$.start_date_from
Start Date From
Y
Start Date To
:$flex$.start_date_from
Start Date From
Y
Started within Days
:$flex$.started_within_days
Started within Days
Request Id
:$flex$.started_within_days
Started within Days
Run Id
:$flex$.submitted_by_user
Submitted by User
Started within Days
:$flex$.type
Type
Exclude System Reports