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 B04763D730F050D7E0530100007F06B3 Blitz Report Name (wildcard) select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv order by xrv.report_name US BE1153BECBFF108BE0530100007F06D1 select y.* from ( select x.*, nvl2(x.error_message,'Error','Valid') validation_result from ( select xrv.report_name, xxen_report.validate_sql(&sql_text_full,'parse') error_message, xrv.type_dsp type, xrv.category, xrv.sql_text, regexp_substr(xrv.description,'Report ID: (\d+)',1,1,null,1) orig_report_id from xxen_reports_v xrv where 1=1 ) x ) y where 2=2 order by y.report_name Y :Report_Name_like is not null or :Category is not null US Blitz Report SQL Validation Validates Blitz Reports for valid SQL syntax. This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or Polaris Reporting Workbench into Blitz Report. Please enter a restriction criteria, as validating (parsing) all report SQLs could take a long time Enginatics RWB &sql_text_full 1=1 2=2 1 10 1=1 lower(xrv.report_name) like lower(:report_name_like) LOV Blitz Report Name (wildcard) B04763D730F050D7E0530100007F06B3 select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv order by xrv.report_name F Nom du rapport comme US Report Name like 2 20 1=1 xrv.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 Discoverer F Catégorie US Category 3 30 2=2 y.validation_result=:validation_result LOV custom Y select 'Valid' value, 'SQLs passing the validation' description from dual union all select 'Error' value, 'SQLs with error' description from dual F Résultat de la validation US Validation Result 4 40 &sql_text_full xrv.sql_text_full LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y Y US Remove &lexicals 5 &sql_text_full regexp_replace(xrv.sql_text_full,'&\w+') Y US Remove &lexicals Default ENGINATICS 3 CATEGORY 2 ERROR_MESSAGE 5 ORIG_REPORT_ID 1 REPORT_NAME 4 SQL_TEXT 6 VALIDATION_RESULT 1 Y R Application Developer FND R System Administrator SYSADMIN S Site U SYSADMIN Default ENGINATICS 3 CATEGORY 2 ERROR_MESSAGE 5 ORIG_REPORT_ID 1 REPORT_NAME 4 SQL_TEXT 6 VALIDATION_RESULT 1 Y R Application Developer FND R System Administrator SYSADMIN S Site U SYSADMIN Default Default