Is it possible to audit changes to a tree? I tried adding audit field change (ADD, UPDATE, DELETE) to PSTREELEAF and PSTREENODE with no luck.

Views: 626

Reply to This

Replies to This Discussion

Hello, excuse me, were you able to perform the Tree Changes Audit this way? I have been asked today to identify all the tree tables and to Enable field or record auditing. I would really appreciate any help regarding this.

Thank you.

Can be achieved by creating three different database triggers for ADD, UPDATE & DELETE if you are interested to Audit only a particular Tree i.e. DEPARTMENT.

I agree with Waneta, you can create database level trigger to record the audit entries.

Step 1: Navigate to PeopleTools > Utilities > Audit > Update Database Level Auditing and create the trigger setup.

Step 2: Run the process to created the trigger body. Navigate to PeopleTools > Utilities > Audit > Perform Database Level Audit

Step 3: Copy the trigger body and create the trigger in database.

For more information, refer to the following PeopleBook: http://docs.oracle.com/cd/E26239_01/pt851h3/eng/psbooks/tadm/chapte...

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service