Audit

[adeel]

Hello there.
In payroll workbench we had entry for Council which somehow got deleted as per user request is there a way to find how it got deleted or any other application caused this entry to removed. Any Audit i can find in JDE?
Thanks

 

[Tom_Davidson]

Adeel,

The easiest way I know of is to look at your DB logs/Journals. You don't specify what DB you are using. But each Db has a way to inspect the Journals.

Tom

 

[Tom_Davidson]

Hit post too quick.

The down side is if you are using the proxy user, that is the user that will show on the DB side, but you might be able to narrow it down by time. If you aren't using CFR 21, I don't know of any other audits.

Tom

 

[adeel]

Thanks Tom. I did not know that you can find CRUD operation from sql logs.
I believe we need to enable audit in sql as well for jd production database.
And we have proxy and issue still there.
What is cfr 21?

 

[Tom_Davidson]

CFR 21 is auditing, mostly for pharmaceuticals I think. But you can use it to audit any table.

We don't use it, from what I hear it is a real pain to set up. We don't use it here.

Tom