ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 51E3BF0C73BA1799E0630100007FF20F select null action_, null status_, null message_, cast(null as varchar2(240)) gather_status, null modified_columns_, cast(null as varchar2(10)) convert_program, x.application, x.program, x.short_name, x.program_type, x.executable, x.method, x.execution_file_name, x.output_format, x.run_count, x.distinct_users, x.last_run_date, x.first_run_date, x.created_by, x.creation_date, x.concurrent_program_id, x.application_id, upper(:customer_abbreviation) customer_abbreviation, upper(:custom_prefix) custom_prefix, cast(null as number) request_id_, rownum upload_row from ( select fav.application_name application, fcpv.user_concurrent_program_name program, fcpv.concurrent_program_name short_name, case when xddb.data_source_code is not null then 'BI Publisher' when fev.execution_method_code='P' then 'RDF' else 'Data Extract' end program_type, fev.executable_name executable, xxen_util.meaning(fev.execution_method_code,'CP_EXECUTION_METHOD_CODE',0) method, fev.execution_file_name, xxen_util.meaning(fcpv.output_file_type,'CP_OUTPUT_FILE_TYPE',0) output_format, nvl(stats.run_count,0) run_count, nvl(stats.distinct_users,0) distinct_users, xxen_util.client_time(stats.last_run_date) last_run_date, xxen_util.client_time(stats.first_run_date) first_run_date, xxen_util.user_name(fcpv.created_by) created_by, xxen_util.client_time(fcpv.creation_date) creation_date, fcpv.concurrent_program_id, fcpv.application_id from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv, fnd_executables_vl fev, xdo_ds_definitions_b xddb, ( select fcr.concurrent_program_id, fcr.program_application_id, count(*) run_count, count(distinct fcr.requested_by) distinct_users, max(fcr.actual_start_date) last_run_date, min(fcr.actual_start_date) first_run_date from fnd_concurrent_requests fcr group by fcr.concurrent_program_id, fcr.program_application_id ) stats where fav.application_id=fcpv.application_id and fcpv.executable_application_id=fev.application_id and fcpv.executable_id=fev.executable_id and fcpv.concurrent_program_name=xddb.data_source_code(+) and fav.application_short_name=xddb.application_short_name(+) and fcpv.concurrent_program_id=stats.concurrent_program_id(+) and fcpv.application_id=stats.program_application_id(+) and nvl(fcpv.enabled_flag,'Y')='Y' ) x where 1=1 Y U A xxen_report_converter.process_row xxen_report_converter.submit_converter US Blitz Report Custom Reports Converter Lists Oracle EBS concurrent programs that are candidates for conversion to Blitz Report - RDF reports, BI Publisher reports, and other data-extract concurrent programs - with usage statistics. Select the programs to convert with the Convert Program column, then upload the file. The upload submits a host concurrent program that gathers each selected program's source artifacts (.rdf, .ldt, data definition, template, related packages and custom dependencies) into a single zip file for analysis by Enginatics. Enginatics Upload 1=1 :custom_prefix :customer_abbreviation 1 10 :customer_abbreviation Char Y US Customer Abbreviation 2 20 :custom_prefix Char XX Y US Custom Object Prefix 3 30 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 4 40 1=1 x.program_type=:program_type LOV custom Y select 'RDF' value, 'Oracle Reports (.rdf) report' description from dual union all select 'BI Publisher' value, 'XML Publisher / BI Publisher report' description from dual union all select 'Data Extract' value, 'Other concurrent program producing a data file' description from dual US Program Type 5 50 1=1 x.application=:application LOV custom Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 6 60 1=1 x.run_count>=:minimum_run_count Number 1 US Minimum Run Count 7 70 1=1 x.last_run_date>=:last_run_date_from Date US Last Run Date From 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 GATHER_STATUS Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 CONVERT_PROGRAM LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes for each program you want to convert to Blitz Report. Leave blank to exclude the program. 7 APPLICATION Char varchar2 Y 8 PROGRAM Char varchar2 Y 9 SHORT_NAME Char varchar2 Y 10 PROGRAM_TYPE Char varchar2 Y 11 EXECUTABLE Char varchar2 Y 12 METHOD Char varchar2 Y 13 EXECUTION_FILE_NAME Char varchar2 Y 14 OUTPUT_FORMAT Char varchar2 Y 15 RUN_COUNT Number number Y 16 DISTINCT_USERS Number number Y 17 LAST_RUN_DATE Date date Y 18 FIRST_RUN_DATE Date date Y 19 CREATED_BY Char varchar2 Y 20 CREATION_DATE Date date Y 21 CONCURRENT_PROGRAM_ID Number number Y Y 22 APPLICATION_ID Number number Y Y 23 CUSTOMER_ABBREVIATION Char varchar2 Y Y 24 CUSTOM_PREFIX Char varchar2 Y Y 25 REQUEST_ID_ Number number Y Y 26 UPLOAD_ROW Number number Y U 1 status_ out Char STATUS_CODE_ U 2 message_ out Char MESSAGE_ U 3 p_convert in Char CONVERT_PROGRAM U 4 p_concurrent_program_id in Number CONCURRENT_PROGRAM_ID U 5 p_application_id in Number APPLICATION_ID U 6 p_program_type in Char PROGRAM_TYPE U 7 p_program in Char PROGRAM P 1 p_convert in Char CONVERT_PROGRAM P 2 request_id_ out Number REQUEST_ID_ P 3 status_ out Char STATUS_CODE_ P 4 message_ out Char MESSAGE_ Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.gather_status, xu.modified_columns_, xu.convert_program, xu.application, xu.program, xu.short_name, xu.program_type, xu.executable, xu.method, xu.execution_file_name, xu.output_format, xu.run_count, xu.distinct_users, xu.last_run_date, xu.first_run_date, xu.created_by, xu.creation_date, xu.concurrent_program_id, xu.application_id, xu.customer_abbreviation, xu.custom_prefix, xu.request_id_, xu.upload_row from xxen_blitz_report_custo_8552_u xu where xu.status_code_=xxen_upload.status_success