Audit Records in Peoplesoft
Hello, If you use Oracle Peoplesoft SIS and want to controlling changes in tables you can use audit records. It's really useful. You can also use trigger but I don't suggest it because when trigger faced some problem, process'll stop obligatorily and you can not continue without overcome with trigger issue. What I have done to create audit record in PS? Login App Designer as three tier mode Open a record which you want to add audit record in this record. Save as this record without associated Peoplecodes in its fields. Add four field end of the record's field as following fields. AUDIT_OPRID --> use this field to make sure who did changes AUDIT_STAMP --> use this field when changes happended AUDIT_ACTN --> use this field as C for changes, A for added, D for deleted AUDIT_RECNAME --> this is optional, if you use this field you can see which audit record used for this record Save your record as a table and give name as AUDIT_(your_record_name)