Reporting and Analytics for SCM

Get Involved. Join the Conversation.

This is a public Forum  public

Topic

    Koteswararao Yenikepalli
    Need a table name for the schedule process ess job names
    Topic posted July 9, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged BI Publisher Reports, Business Intelligence, SQL, White Paper 
    139 Views, 4 Comments
    Title:
    Need a table name for the schedule process ess job names
    Summary:
    Need a table name for the schedule process ess job names
    Content:

    We are not able to get the exact name from the ess job name we are able to get the alternative names but need the excat name in the ESS job schedue page

     

     

    Version:
    19A
    Image:

    Comment

     

    • Senthilrajan Vaithianathan

      Refer below table,

      ESS_REQUEST_HISTORY

      ESS_REQUEST_PROPERTY

      -Senthil

    • Koteswararao Yenikepalli

      But these tables are not storing the required information

       

      for example, job name is import journal its storing the importjournals like this.

       

      in need the detail name like import journals 

    • Senthilrajan Vaithianathan

      You may need to combine these two tables and if you know the value for the process that you looking for, you can get the details.

      Eg. Below query is for the process 'autoInvoices'

      SELECT * FROM  FUSION.ESS_REQUEST_HISTORY RH
      INNER JOIN FUSION.ESS_REQUEST_PROPERTY RP
      ON RP.REQUESTID = RH.REQUESTID
      WHERE RP.VALUE = '/oracle/apps/ess/financials/receivables/transactions/autoInvoices'

      You can check RP.NAME and RP.VALUE

    • Sudhakara Rao Kovuru

      Try this one you... 

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

     

    community forum