My Oracle Support Banner

P6 Primavera Data Service (PDS) Sample Code to Read P6 Audit Data (Doc ID 3056134.1)

Last updated on FEBRUARY 12, 2025

Applies to:

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

Goal

Sample code demonstrating how to query the audit tables for P6.

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!

In this Document
Goal
Solution
 Example 1: The example below shows how to get a list of deleted projects.
 Example 2: The example below shows how to read a list of logins for P6 Web. USESSAUD is used to track logins. The DB_ENGINE_TYPE field indicates the application for which the login occurred. In this example, the application is P6 Web which has a DB_ENGINE_TYPE=WEB_PM.
References


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