Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Sudhakara Rao Kovuru
    ESS Schedule Process Job Name not availableAnswered
    Topic posted September 4, 2019 by Sudhakara Rao KovuruBronze Trophy: 5,000+ Points, tagged BI Publisher 
    85 Views, 10 Comments
    Title:
    ESS Schedule Process Job Name not available
    Summary:
    ESS Schedule Process Job/Program Name not able find any table
    Content:
    Hi All,
     
    We need to build a BIP Report for audit purpose with all ESS job details but unfortunately not able to find the ESS Schedule Process Job/Program Name in any of table or view object. So could you please share if you have any details about it?
     
    Please find attached file which marked as yellow color field which I am looking for...
     
    I tried all below tables to get but none of them have. 
     
    ess_request_history
    ess_request_property
     
    ase_privilege_b
    ase_permission_b
    ase_privilege_tl
     
     
    Thanks,
    -Sudha
    Version:
    19C
    Image:

    Best Comment

    Sudhakara Rao Kovuru

    Hi All,

    Would like to have this feature and help increase its priority, vote for this Idea. This will result in making it more likely that oracle product strategy team will consider adding it to a future release.

    1) Go to https://cloudcustomerconnect.oracle.com to access Cloud Customer Connect and sign in with your Oracle Account.

    2) Click on the "Ideas" drop-down in the header and select the appropriate category. -- In this case: Financials

    3) Under Find Ideas, search on Idea number 7c1784016d. 

    4) Click on the "Thumbs Up" icon to Vote Yes.

    https://cloudcustomerconnect.oracle.com/posts/7c1784016d

     

    Thanks,

    -Sudha.

    Comment

     

    • Karthikeyan Sukumar

      The Job & Job defintions are not stored any of the DB tables.Those are stored in Meta data which cannot be queried using SQL.

      The closest value will be Name field in ess history table.

       

      Thanks!

      Karthik

    • Sudhakara Rao Kovuru

      Hi Karthik,

      Thanks for update and trying to help me.

      Unfortunately this will not work for my auditor since Metadata name showing in the Name column in HISTORY Table.

      Let me create SR with Oracle Support and will share you if I get something from them so that others can get to know.

      Thanks,

      -Sudha.

      • Karthikeyan Sukumar

        Sure you can raise the SR.I don't think you will have the answer for getting the name.Since it is intended 

        Let us know.

         

        Thanks!

        Karthik

        • Sudhakara Rao Kovuru

          Created SR as well. SR 3-20894602491 : ESS Schedule Process Job/Program Name not able find any table

          Based on my SR they have created Bug also ... Bug 30264691 : ESS Job Name - Not Available in Table ESS_REQUEST_HISTORY

    • Karthikeyan Sukumar

      Below is the Bug : 25775318 for this ER request.

      Thanks!

      Karthik

    • Sudhir Kolli

      Please explore the BI Publisher Audit functionality. I recommend to review the below doc:
      Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1)

      Review the below link for the steps to enable:

      https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19A/19A-common-wn.htm#F6326

      Review the below link for the documentation of available Audit Reports:

      https://www.oracle.com/technetwork/middleware/bi-publisher/wp-fusionbipaudit-5459609.pdf

      The seeded ESS job points to a specific report. So the report level auditing can be done with the above.

    • Sudhakara Rao Kovuru

      Hi Sudhir,

      Thanks for sharing info....

      These detail already been shared with them but they are not happy with data hence requested us to create custom BIP report with requested columns.

       

      Thanks,

      -Sudha.

    • Sudhakara Rao Kovuru

      Hi All,

      Would like to have this feature and help increase its priority, vote for this Idea. This will result in making it more likely that oracle product strategy team will consider adding it to a future release.

      1) Go to https://cloudcustomerconnect.oracle.com to access Cloud Customer Connect and sign in with your Oracle Account.

      2) Click on the "Ideas" drop-down in the header and select the appropriate category. -- In this case: Financials

      3) Under Find Ideas, search on Idea number 7c1784016d. 

      4) Click on the "Thumbs Up" icon to Vote Yes.

      https://cloudcustomerconnect.oracle.com/posts/7c1784016d

       

      Thanks,

      -Sudha.

      • Julien Dubouis

        Oracle has created a screen for you. There are all the properties of the program there, you can search by program name. The task is "Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Management, and Related Applications"

        • Sudhakara Rao Kovuru

          Hi Julien,

          Thanks for the update and information provided too...

          We are looking for ESS schedules job tables from where we can prepare a custom report to show it...not the definition of the program.

          Could you please help me, which table these information stored?

          Appreciate for your help.

          Thanks,

          -Sudha.