Running Audits of OneWorld Tables

I have been asked by my manager what running audits are available through
OneWorld. I am aware of the few application audit trails (like order
history), or security, etc. I am also aware that on most of the tables there
are fields of the last user/workstation that updated the table is recorded,
but that is not a running audit (ie, historical updates). Other than having
every user log into the database individually and turning on transaction
logging (nightmare!), is anyone aware of anyway to selectively create
running audit trails in OneWorld? I can't see how it would be possible
without having the users gain entry into the DB through an individual
account rather than the OneWorld system account..any ideas on this?

John

----------------------------------------------------------
OneWorld Xe (B733.3)
Update 6, SP 19.1_B1
Running on: WIN2K/SP2, SQL2k/SP2
Metaframe 1.8a
----------------------------------------------------------

John,

We saw the need for creating running audits for our Item Master, Item Branch, Work Order Master and WO Parts List. I created custom (system 55) tables and then created database triggers that populate the custom tables with the field values. I also included a field to indicate the type of transaction (Add, Change, or Delete), as well as the actual date and time from our database. The latter was added in case a program was updating a table but not updating the standard audit information. Note that you can get the OneWorld user ID from the standard audit information on most tables. Also, I excluded updates from certain programs (such as R3482, R30822A, R43990 and R42995 for the Item Branch table) so they don't generate tons of audit records.

JDEdwards plans to deliver Audit Trial capability in SP21. From what I am
told, a standard setup will be delivered and from their you can select
tables, fields, etc that you also want to include. This is being pushed
by the LifeScience SIG.
Sue Pranes
[email protected]
Phone: 650-631-5012
Fax: 650-631-3150
Pager: 650-760-1166