Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Soumya Parhi
    ESS Job Definition Table Name
    Topic posted February 8, 2018 by Soumya ParhiGold Trophy: 10,000+ Points, tagged Fusion Financial reporting, Reports 
    751 Views, 2 Comments
    Title:
    ESS Job Definition Table Name
    Summary:
    Which Table Stores the ESS Job Definition Table Name
    Content:

    Good People,

    I am just asking the Table Name / View Name that stored the ESS Job Definition Details , so that I can query the table to find it. 
     

    Thanks,

    Soumya

    Comment

     

    • Ashish Vishwakarma

      ESS jobs are not stored in any Table, if you want to export them then here is the solution.

      1.)  Go to Setup and Maintenance

      2.) Global Task Search : Manage Enterprise Scheduler Job%

      3.) Export the list of all the ESS Jobs under respective offerings

    • Sudhakara Rao Kovuru

      Try this query...

      SELECT rp.*, 
             rh.* 
      FROM   ess_request_property RP, 
             ess_request_history RH 
      WHERE  RP.requestid = RH.requestid 
             AND value LIKE '%Program - Import Journals%'