Remember in JDE auditing, the following is used:
The base table (say F0911) is converted to a view of the same name.
The data from the base table is copied to a table called F0911_ADT. (insert into select * from)
Triggers are installed on the F9011_ADT to write audit records to the A0911.
All of the existing indexes are built against the ADT table - but they are all rebuilt!!! This takes a long time for a big table.
Subscribe to:
Post Comments (Atom)
-
I’ve enabled auditing many times before. Everytime has been a nightmare. You need lots of space for big tables, this could be done MUCH bet...
-
I’m running windows 7 virtual on OVM with office 2010. Have E1 fat boy and oracle 11G client. I’m using this machine for some BIP prototyp...
-
This is a really handy tool for working out what DD items and tables are in use in JDE. This is a complete cross reference of JDE DD items,...
No comments:
Post a Comment