PeopleSoft Community Network
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.
Tags:
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...
© 2024 Created by Maisam Agha. Powered by