PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Audit on PSOPRDEFN

edited Sep 24, 2017 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

Hello,

We turned on the Database level auditing on PSOPRDEFN. Used peoplesoft delivered functionality to create the trigger. It does captures the changes ,delete and adds. Two issues we found is audit oprid is tracked is a very random and LASTPSWDCHANGE  getting updated erroneously while there was no password change done. It captured the audit oprid as XXXX when XXXX has no security to the user profile page. From app server logs found that XXXX was logged in at the time of the changes. I believe the function GET_PS_OPRID is not working as expected.   Did any one has similar issues?.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center