ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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. 2B3C8C96F3531FF9E0630100007F25F0 select xrr.upload_request_id, xrr.request_id report_request_id, xrr.creation_date, xxen_util.user_name(xrr.created_by) user_name, frt.responsibility_name responsibility, xrv.report_name upload_name, nullif(x.c_v,0) create_valid, nullif(x.c_e,0) create_error, nullif(x.c_s,0) create_success, nullif(x.u_v,0) update_valid, nullif(x.u_e,0) update_error, nullif(x.u_s,0) update_success, nullif(x.other,0) other, xrr.row_count total, xrr.upload_file_name file_name, dbms_lob.getlength(fl.file_data) file_size, nvl2(x.run_id,'begin xxen_upload.g_run_id:='||x.run_id||'; end;',null) init_sql, nvl2(x.run_id,'select'||chr(10)||'xu.*'||chr(10)||'from'||chr(10)||xrv.upload_view||' xu'||chr(10)||'order by'||chr(10)||'xu.upload_row',null) data_sql, xrr.run_id, xrr.report_id from ( select run_id, case when xud.column1='C' and xud.column2='V' then 'C_V' when xud.column1='C' and xud.column2='E' then 'C_E' when xud.column1='C' and xud.column2='S' then 'C_S' when xud.column1='U' and xud.column2='V' then 'U_V' when xud.column1='U' and xud.column2='E' then 'U_E' when xud.column1='U' and xud.column2='S' then 'U_S' else 'other' end action_status from xxen_upload_data xud ) pivot ( count(*) for action_status in ( 'C_V' as c_v, 'C_E' as c_e, 'C_S' as c_s, 'U_V' as u_v, 'U_E' as u_e, 'U_S' as u_s, 'other' as other ) ) x, xxen_report_runs xrr, xxen_reports_v xrv, fnd_responsibility_tl frt, fnd_concurrent_requests fcr, fnd_lobs fl where 1=1 and xrr.type='U' and xrr.run_id=x.run_id(+) and xrr.report_id=xrv.report_id and xrr.responsibility_application_id=frt.application_id(+) and xrr.responsibility_id=frt.responsibility_id(+) and frt.language(+)=userenv('lang') and xrr.upload_request_id=fcr.request_id(+) and nvl2(translate(fcr.argument3,'x1234567890','x'),null,fcr.argument3)=fl.file_id(+) order by xrr.run_id desc New logic to derive the uploaded valid row count from the xrr.row_count column Y US Blitz Upload History History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days. Enginatics 1=1 1 10 1=1 xrv.report_name=:report_name LOV custom Y select xrv.report_name value, xrv.description from xxen_reports_v xrv where xrv.report_id in (select xrr.report_id from xxen_report_runs xrr where xrr.type='U' and (:$flex$.Started_within_Days is null or xrr.start_date>=sysdate-:$flex$.Started_within_Days)) order by xrv.report_name US Upload Name 2 20 1=1 xrr.creation_date>sysdate-:days Number select 10 from dual where :$flex$.upload_name is null and :$flex$.uploaded_by is null US Started within Days 3 30 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 US Uploaded By :$flex$.Started_within_Days Started within Days Upload Name :$flex$.upload_name Upload Name Started within Days :$flex$.uploaded_by Uploaded By Started within Days