My Oracle Support Banner

After Enabling Auditing, PAUDIT AUDIT_OLD and AUDIT_NEW columns Do Not Display Changes And Execution Of 'Publish Audit Data' Does Not Move Records To PAUDITX (Doc ID 2460067.1)

Last updated on MAY 09, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.7.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------
P6 EPPM Database Auditing has been enabled but the AUDIT_OLD and AUDIT_NEW column is not being populated in the PAUDIT table after updates are made. Null values observed in these columns.

This will create an issue with the global scheduled service 'Publish Audit Data' because it will not insert any records into PAUDITX during the global publication job since the old and new fields are used to filter the records being published.


EXPECTED BEHAVIOR
--------------------
After enabling auditing, changes should be tracked in AUDIT_OLD and AUDIT_NEW column.

This will also ensure the global scheduled service 'Publish Audit Data' properly writes to PAUDITX for reporting against published data.  


STEPS TO REPRODUCE
--------------------
The following steps can be used to reproduce the issue (using PROJWBS as example):

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.