EIS Reports

Description

Categories
EIS
One row per EIS eXpress report with its definition, usage, schedules and access grants, and the Blitz Report it was migrated to.

Source Type follows the EIS runtime: the SQL pasted into the report, else the SQL of an EIS view of type SQL, else the database object named by the report's view, looked up in the registered owner, then APPS, then XXEIS. Missing means that none exists, so the report cannot run in EIS either. View Owner and View Status describe that database object.

Runs count eXpress and XL Connect executions that started within Executed within Days. A run counts as scheduled when it starts more than a day after the logon of its EIS session, as scheduled runs keep the session in which the schedule was created. Deliveries count EIS distribution jobs of any method, Email and FTP Deliveries the runs with an email recipient or an FTP target.

EIS purges its run history, so a report without runs may still have been used before the earliest retained run. Distribution jobs are kept longer and show older usage when Executed within Days reaches back further.

Active Schedules counts the requests EIS Schedules lists for the report: pending requests of the EIS report submission programs and the running request of a recurring schedule. Grants count active grants, with report set grants expanded to their reports. Blitz Report is the report whose description carries the EIS Report ID line written by the EIS import, whatever its name, or else a Blitz Report of the same name.

SQL 213 lines

Parameters 11

ParameterTypeList of values SQL
ApplicationLOV
era.application_name=:application
CategoryLOV
errc.category_name=:category
Report NameLOV
err.report_name=:report_name
OwnerLOV
err.report_owner=xxen_util.user_id(:owner)
SeededLOV Oracle
err.seeded_flag='Y'
EnabledLOV Oracle
err.enable_report=:enabled
Source TypeLOV
y.source_type=:source_type
Executed within DaysNumber
erp.start_time>=sysdate-:executed_within_days
ExecutedLOV Oracle
x.runs>0
Show Migration AnalysisLOV
xxen_eis.sql_shape(err.report_id) "SQL Shape",
xxen_eis.migration_tier(err.report_id) migration_tier,
xxen_eis.xxeis_objects(err.report_id) "XXEIS Objects",
Show SQLLOV
case y.source_type
when 'Paste SQL' then err.paste_view_sql
when 'Database View' then
(
select
xxen_util.long_to_clob('SYS.VIEW$','TEXT',v.rowid)
from
all_users au,
sys."_CURRENT_EDITION_OBJ" ceo,
sys.view$ v
where
y.view_owner=au.username and
au.user_id=ceo.owner# and
err.view_name=ceo.name and
ceo.obj#=v.obj#
)
else y.view_sql
end "Source SQL",