Purge Audit Job Does Not Allow Certain Objects To Be Deleted

Products

• Clarity PPM On Premise
• Clarity PPM SaaS
• ACF2 - VSE

Issue/Introduction

What query can be ran directly on the database to remove particular audit instances?

Environment

Release : 16.1.1

Resolution

If the job needs to be more selective, as it does not have a parameter to choose what object to delete,
the following 3 select queries can be used:

select * from cmn_audits where object_code = 'xxxx' , ex: 'task'

select * from cmn_audits_tsv where object_code= 'task' and created_date <= sysdate - XX

select * from ODF_AUD_MULTI_VAL_LOVS WHERE ID NOT IN (SELECT MAX(ID) MAX_ID FROM ODF_AUD_MULTI_VAL_LOVS GROUP BY OBJECT_INSTANCE_ID, ATTRIBUTE_CODE) AND object_code= 'task' and created_date <= sysdate - XX

 

Additional Information

As the job does not have a parameter to select particular object instances to be deleted from the audit table, it can be presented as an enhancement/idea.