Oracle Transactional Business Intelligence Idea Lab

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

Need an Report to get the List of ESS Jobs Submitted by Users

41
Views
5
Comments

Organization Name

Arcadis NV

Description

We are facing slow performance issue as of 19D Update on Projects and AP, we were able to see multiple ESS Jobs are Scheduled and running for a long time. Hence lots of users across the globe were submitting multiple process, which we were unable to monitor from Scheduled Process Page.

Hence we are requesting for a BI Report, which can help us to get the list of ESS Jobs that are scheduled by Users. The Parameter Should be set to Process Status or Process Id.

 

Use Case and Business Need

This will reduce the time and manual effort required, we can run the report with parameter *(Status: Running). This will get the list of Jobs that have been scheduled by users and Running.

Original Idea Number: 55050779db

1
1 votes

Submitted · Last Updated

Comments

  • Mihaela M
    Mihaela M Rank 3 - Community Apprentice

    You can do this yourself. Create a BIP report on the ESS table FUSION.ESS_REQUEST_HISTORY  and monitor the processes.

  • User_22CZ6
    User_22CZ6 Rank 1 - Community Starter

    Our Accounting team requires the ability to export all the Allocation processes executed by users and parameters selected while running them into a csv report.

  • KARIM BEDDEK
    KARIM BEDDEK Rank 1 - Community Starter

    Any Information on this request? did someone extracted scheduled processes on BIP Report?

  • Dawn Cawston - CPS
    Dawn Cawston - CPS Rank 3 - Community Apprentice

    I just did but it didnt list the parameters which is what i need as well.

    We have to replicate them in the DEV environments each time they are refreshed however it is difficult to see what parameters are against each process and a report would really help.

    Thanks

    Dawn

  • Sampath Kota-Oracle
    Sampath Kota-Oracle Rank 3 - Community Apprentice

    Moving to OTBI idealab