ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Other Work Instance Name Change

book

Article ID: 238869

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Audit was not enabled on the Other Work.

There was a change in the Other Work Task. 

How can we find out when it was changed?

Environment

Release : 16.0.1

 

Resolution

Run SQL:

select a.id, b.code, b.name,
b.last_updated_by, b.last_updated_date,
c.first_name, c.last_name, c.user_name
from INV_OTHERS a,
inv_investments b,
cmn_sec_users c
where a.id = b.id and b.last_updated_by = c.id
AND b.code = '<code_here>'
order by a.last_updated_date desc

If this is refreshed environment, obtain the id and compare it to the source environment to determine the prior name.

Please contact the Support team to ask for a review of the App Access logs.




Additional Information

To view audits for the Other Work object, use the query:

SELECT * FROM cmn_audits
WHERE object_code = 'other'