My Oracle Support Banner

How To Retrieve PAUDIT Audit Data From Audit-Enabled Tables With A Blob Field Column Type (Doc ID 2980177.1)

Last updated on OCTOBER 13, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 22.12 and later
Primavera P6 Standard Project and Portfolio Management Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

The goal of this document is to provide instruction for obtaining audit data for any audit-enabled table which include blob fields.  

Per design, audit data is written to the PAUDIT table, and blob field changes are written to the following two PAUDIT table columns:
  • audit_ext_old (to represent the old value within the blob field)
  • audit_ext_new (to represent the new value within the blob field)

The two PAUDIT columns are blob fields themselves and require a way to convert the blob field to a readable format when executing a select statement to read the audit data.

For Cloud Customers, PAUDIT audit data is made available by executing the "Publish Audit Data" Global Scheduled Service (which denormalizes data from PAUDIT to PAUDITX) and running a report within BI Publisher or the Reports tab of P6 (which reads from the denormalized PAUDITX table), but the global scheduled service does not account for movement of blob data from PAUDIT to PAUDITX and will not be available from audit reports. 

This document will include direction for Cloud Customers to obtain audit data for tables with blob fields (in addition to instruction for on-premise customers who need to access the blob field data from PAUDIT).

Solution

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

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

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