Blitz Report Application Categories

Description
Categories: Enginatics
Repository: Github
Oracle application -> Blitz Report assignment via lookup XXEN_REPORT_APPS_CATEGORIES.

This setup controls how automatically imported BI publisher reports and concurrent programs are assigned to Blitz Report categories.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
trim(regexp_substr(flv.description,'[^,]+',1,rowgen.column_value)) category,
fav.application_name,
flv.lookup_code application_short_name
from
fnd_lookup_values flv,
table(xxen_util.rowgen(regexp_count(flv.description,',')+1)) rowgen,
fnd_application_vl fav
where
flv.language=userenv('lang') and
flv.description is not null and
flv.lookup_code not like 'ALL%' and
flv.lookup_type='XXEN_REPORT_APPS_CATEGORIES' and
flv.view_application_id=0 and
flv.security_group_id=0 and
flv.lookup_code=fav.application_short_name(+)
order by
category,
fav.application_name