Oracle Transactional Business Intelligence Idea Lab

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

Ability to extract all ESS job and job set name via Manage Enterprise Scheduler Job for HCM/Fin/CRM

348
Views
4
Comments

Organization Name

Department of Treasury and Finance

Description

Hi Team,

Per Oracle Fusion product limitation, The Jobset and Job Definitions are not stored in any DB tables to query. They are xml documents stored in MDS DB which cannot be queried using SQL. Hence at least Oracle should allow end user to extract all the ESS job and job set name from Export to Excel functionality.

 

Currently it only export part of the list which comes by default on the screen, which results in false information.

 

Thanks

Use Case and Business Need

It is required for any business to produce report which can tell what ESS job is running or scheduled in the system.

Original Idea Number: 295dcbd3bd

12
12 votes

Submitted · Last Updated

Comments

  • KARIM BEDDEK
    KARIM BEDDEK Rank 1 - Community Starter

    Good idea

  • Glen Ryen
    Glen Ryen Rank 4 - Community Specialist

    Agreed, this would be very useful for validating/documenting current configuration.

  • SHAILESH123
    SHAILESH123 Rank 1 - Community Starter

    Hi Team,

    We also have same requirement for our business to produce report which can tell what ESS job is running or scheduled along with parameters in the system.

    Regards,

    Shailesh

  • Emiliano R
    Emiliano R Rank 1 - Community Starter

    The visibility to scheduled jobs and their parameters would greatly help our business process from a critical support perspective. When scheduling requests for multiple BUs it is necessary to see which Business Units are scheduled to run and their scheduled run times.  This information helps us confirm what scheduled processes may be duplicated for a business unit or missing for another business unit.