E-AD: Database Level Auditing Not Populating AUDIT_OPRID for Updates Done by 3rd Party Tools (Doc ID 1137031.1)

Last updated on AUGUST 01, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.44 to 8.50 [Release 8.4]
Information in this document applies to any platform.
***Checked for Relevance 09-AUG-2013***

Goal

Why isn't the AUDIT_OPRID getting populated on database audit record employing get_ps_oprid when update is done using 3rd party tools such as Toad or SQL*Plus?

Solution

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 hundreds of Community platforms