What query can be ran directly on the database to remove particular audit instances?
Release : 16.1.1
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
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.