Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Sumanth Kunimakki
    View future scheduled ESS jobs in SaaS
    Topic posted July 18, 2019 by Sumanth KunimakkiGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, Reports 
    137 Views, 4 Comments
    Title:
    View future scheduled ESS jobs in SaaS
    Summary:
    We have a requirement to extract the future scheduled jobs for a user.
    Content:

    Test Case: Admin wants to know what are the future jobs scheduled for a user. In case if an employee leaves the company he wants to cancel the future jobs scheduled by that user. Customer is looking for an extract that will show these details.

    ESS_REQUEST_HISTORY table is not giving me the future scheduled jobs, it is giving me the details of already run jobs

    Comment

     

    • Sudhakara Rao Kovuru

      try this note...

      How to cancel any process which is scheduled for future? (Doc ID 2467597.1)

    • Wendy Ware

      If you don't need a report, you can search for processes in the Schedule Processes UI that were submitted by a specific user and have "Wait" status.  That's where you have to go to cancel them anyway.  Just be careful to have an early enough Submission Time date filter (like 01/01/2000) to capture processes that were scheduled in the past.  Wendy

       

    • Anil Kola

      Hi,

       You need to use below two tables to achieve your requirement. Please try querying these tables. Update if you face any issue in preparing the query.

      FUSION.ESS_REQUEST_HISTORY
       FUSION.ESS_REQUEST_PROPERTY

    • Sudhakara Rao Kovuru

      Hi Anil,

      Can you please share if you have SQL query for it?

      Thanks,

      -Sudha.