My Oracle Support Banner

With Auditing on What Query Can Be Used to Find What User Deleted a UDF or Removed a Value From a UDF (Doc ID 2391125.1)

Last updated on MAY 04, 2018

Applies to:

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

Goal

Query To Find Deleted UDFs

We have enabled auditing on the UDFTYPE and UDFVALUE tables. We would like to know what query we can run against the PAUDIT table to find out what UDFs were deleted by users.
 

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.