MUX Audit Trail: Parent ID null for some records

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The MUX Audit Trail shows a null parent ID for some of the audited records.

There are some Projects with a Cost Plan where the plan End Period was updated. 

The audit trail shows correctly the change made to the Cost Plan End Period, but the related Parent ID field is blank.   

Cause

When looking to the following DB output, there are missing records:

SELECT * FROM ODF_AUD_OBJ_INST_CONTEXT WHERE OBJECT_CODE = 'costplan'

Entries showing the parent-child object relationship are missing 

Resolution

In order to repopulate the ODF_AUD_OBJ_INST_CONTEXT table proceed as follows:

• Classic PPM > Administration > Studio> Objects > Cost Plan object
• Audit Tab > Ensure the End Period is present
• Click on Save and Return

The trigger gets recreated and the table repopulated

The Audit trail afterwards shows the Parent ID correctly