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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1A20B4187F6C9C3AE0630100007FC618Y select x.* from ( select xrpv.report_name, xrpv.category, xrpv.display_sequence, xrpv.parameter_name, xxen_report.is_function(xrpv.default_value,xrpv.parameter_type) is_function, xxen_report.is_select_(xrpv.default_value) is_select, xrpv.parameter_type_dsp, xrpv.lov_name, count(*) over (partition by xrpv.default_value) dupl_count, xrpv.default_value, xrpv.lov_query_dsp, xxen_util.user_name(xrpv.last_updated_by) last_updated_by, xxen_util.client_time(xrpv.last_update_date) last_update_date, xxen_report.value_to_id(xrpv.parameter_id,xrpv.default_value) default_value_correct from xxen_report_parameters_v xrpv where 1=1 and xrpv.display_sequence is not null and xxen_api.lov_value_equal_to_id(xrpv.parameter_id) is null and xrpv.default_value is not null ) x where 2=2 order by 1,2,3 US Blitz Report Parameter Default Value Validation Lists report parameters whose LOV returns an id that differs from the displayed value, and shows whether the parameter's default value is stored as that id or as the display text. Default Value Correct is the id the LOV resolves the stored default to. Where it differs from Default Value, the default was entered as the display value instead of the id. Use the 'Show non matching defaults only' parameter to list those cases. The framework binds the id for such LOVs, so a report level default given as display text only works through a fallback validation, which costs an additional LOV execution every time the run screen opens and is ambiguous if the same text also exists as an id. Template and user level defaults are matched against the id only, so there the display text does not resolve at all. Is Function and Is Select show whether the default is expressed as a function, e.g. fnd_profile.value, or as a select statement, and Dupl Count how many of the listed parameters share the identical default expression. Use the Category and Report Name parameters to limit the scope. Enginatics 1=1 2=2 1 10 1=1 xrpv.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 US Category 2 20 1=1 xrpv.report_name=:report_name LOV custom Y 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 where xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where xrp.parameter_id in (select xrpdv.parameter_id from xxen_report_param_default_vals xrpdv)) order by xrv.report_name US Report Name 3 30 2=2 x.default_value<>x.default_value_correct LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show non matching defaults only 4 40 2=2 x.is_function='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show functions ony 5 50 2=2 x.is_select='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show selects only