Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Sumanth Kunimakki sathyamurthy
    View future scheduled ESS jobs in SaaS
    Topic posted July 18, 2019 by Sumanth Kunimakki sathyamurthy, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, Reports 
    112 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.