Include Enterprise Scheduler Job Display Name in REQUEST_HISTORY table — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Include Enterprise Scheduler Job Display Name in REQUEST_HISTORY table

1
Views
0
Comments
User_WIZL4
User_WIZL4 Rank 2 - Community Beginner

Organization Name

Northumbria Healthcare NHS Foundation Trust

Description

We have a requirement to build a report to replicate the 'Schedules Processes' UI page in fusion to allow clients to view all ESS jobs ran by users in thier organisation. The REQUEST_HISTORY looks to be the only table that contains this data, however it does not include the ESS job display name which is the only meaningful name to an end user. 

The REQUEST_HISTORY only includes the name, whereas the display name is required. I have attached files showing a process in 'Scheduled Process' with the name required to be included in the report, a file showing this job in 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications' showing the display name and a file showing the query for the process ID using both the REQUEST_HISTORY and REQUEST_PROPERTY tables. Neither of these tables include the display name required.

It is not even possible to export the full list of jobs in 'Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications' so we cannot use a custom CASE/DECODE statement.

Use Case and Business Need

Current set up means that users can only see processes ran by themselves in 'Scheduled Processes' due to security issues as we deploy a shared system with multiple legal entities. A report is required so that users from one legal entity can see a list of ESS jobs ran by all users in their legal entity.

Original Idea Number: bbdabcb144

Manage EES Job Definitions.JPG

1
1 votes

Submitted · Last Updated