PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Audit logs for data Extracts through PS Query

edited Dec 18, 2018 7:45AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered

We have a requirement to audit all the PS Query users. who ,when and what data the users are trying to extract through PS Query ?

This is one of Our Key Audit compliance and looking for report to extract this information , if this information is stored in any of the records ? If not in PS tables any where in Standard Oracle tables ?

We have tried by enabling ‘Query Statistics’ option. But this option is given only for analysis purpose and will have an adverse effect on performance if enabled for longer time.

‘’ PeopleSoft recommends that you use the query statistics feature only for analysis, and that you do not leave it enabled on an ongoing basis. Enabling this feature may compromise the performance and the system may have an increased possibility of query time-outs or may return query results with zero values. This recommendation also applies to users of queries in reports”

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