PeopleSoft Planet

Regarding the Record Level Audit

Hi,

I have created the audit record for the one custom Record and set that audit record in the base record record properties.

1. When the key field is changed in the base record, two rows(Audit_Actn 'K','N') is getting inserted in the audit record with the newly modified value

For Example: When the key field EFFDT is changed from '01/05/2008' to '06/05/2008' in the h_pay_tbl, two rows is getting inserted with changed date '06/05/2008'

2. When the non key field is changed in the base record, one row(Audit_actn 'C') is getting inserted in the audit record with the newly modified value

For Example: when the non key field Eff_Status is changed from 'A' to 'I', one row is getting inserted with the newly modified value 'I' in the Audit Table

As per logic, If we change the key value, Audit Actn 'K' with old value and Audit_Actn 'N' with new value should be added in the Audit table But instead of this, two rows is getting added with the newly added value. Same thing is happening when the non key value changes

I want the audit_actn 'K' with old value and 'N' with new values in the audit table.

Please provide the solution for this issue.

Thanks,
Saravanan.P

My maild id: saravanan120480@gmail.com