For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
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
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.
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
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
Below is the Bug : 25775318 for this ER request.
Thanks!
Karthik
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:
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.
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.
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.
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"
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.
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.