Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Table to retrieve records of Work definitions from Audit reports in Oracle Cloud Fusion ERP 24D
Hi Team,
I am seeking a database table or an SQL query that can retrieve detailed 'Audit Report' information specifically related to Work Definitions. This includes tracking any changes, updates, or modifications made to the Work Definitions and the corresponding timestamps and user details.
I am including a screenshot of the user interface (UI) from which I need to extract specific data for further processing. Your assistance in this matter would be immensely valued and deeply appreciated. Thank you in advance for your support.
Thanks,
Shashavali
Best Answers
-
Hi Audit tables have an underscore suffix.
Eg if turned audit on for Salary changes, then the salary table is CMP_SALARY therefore the audit changes are in CMP_SALARY_0 -
Hi MandeepGupta,
I sincerely appreciate your prompt response to my query. To provide more context, the user interface I referred to retrieves data from multiple tables, such as
WIS_WD_VERSIONS_,WIS_WD_OPERATIONS_B_,WIS_WD_OPERATIONS_TL_,WIS_WORK_DEFINITIONS_, and several others. My current requirement is to combine the data fetched from these tables into a unified dataset.I want to take a moment to thank each one of you for your guidance and support. Your assistance has been a significant help, and I genuinely appreciate the effort and time you have given.
Thanks,
Shashavali0
Answers
-
Hi gclampitt,
Good day!
Thank you for taking the time to respond to my post. To clarify, the work definition table in this context isWIS_WORK_DEFINITIONS, and the associated audit table isWIS_WORK_DEFINITIONS_. However, I noticed that these tables do not seem to store the specific data that is displayed in the UI.Thanks,
Shashavali0 -
hi sorry i can't comment on Work definitions as don't use that but the audits tables return same info as UI for what we've enabled
0 -
You will need to compare data with main table and write your logic to extract what you are looking for using AUDIT_ACTION_TYPE_. The audit table doesn't capture what is shown directly on UI.
Thanks.
0 -
Thanks for the details. As far as I know, there is no direct way of getting the query used in Audit screen. You need to built custom logic to get the matching data using the tables you mentioned.
Thanks.
0
