nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Table to retrieve records of Work definitions from Audit reports in Oracle Cloud Fusion ERP 24D

Shashavali

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

Find more posts tagged with

Accepted answers

gclampitt

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_

Shashavali

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,
Shashavali

All comments

gclampitt

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_

Shashavali

Hi gclampitt,

Good day!
Thank you for taking the time to respond to my post. To clarify, the work definition table in this context is WIS_WORK_DEFINITIONS, and the associated audit table is WIS_WORK_DEFINITIONS_. However, I noticed that these tables do not seem to store the specific data that is displayed in the UI.

Thanks,
Shashavali

gclampitt

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

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61122#Comment_61122

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.

Shashavali

Hi MandeepGupta,

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,
Shashavali

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61253#Comment_61253

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.