Blitz Upload Data
Description
- Categories
- Enginatics
- Repository
- GitHub
History of uploaded data, which is kept for profile option Blitz Upload Data Retention Days number of days.
SQL 25 lines
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, xrr.upload_file_name file_name, 'begin xxen_upload.g_run_id:='||xud.run_id||'; end;'||chr(10)||chr(10)||'select xu.* from '||xrv.upload_view||' xu' sql, &upload_columns from xxen_upload_data xud, xxen_report_runs xrr, xxen_reports_v xrv, fnd_responsibility_tl frt where 1=1 and xud.run_id=xrr.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') order by xud.run_id desc, xud.upload_row |
Parameters 7
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Upload Name | LOV |
| |
| User Name | LOV |
| |
| Started within Days | Number |
| |
| Upload Request Id | LOV |
| |
| Report Request Id | LOV |
| |
| Run Id | LOV |
| |
| Maximum rows per upload | Number |
|