Reports2017-11-18T12:27:27+00:00

Blitz Report Application Categories

Description
Categories: Application, Enginatics, Setup
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.

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


By continuing to use the site, you agree to the use of cookies. Accept