jde321
Member
hi all,
We faced a problem in Accounts Payable module - all of a sudden 180 batches of one unit were changed to pending status, which were actully in posted status... This is second time the problem has occured. We don't know what are the exact set of actions which cause this problem.... whether a single application or multiple concurrent applications.... I am still on the back of it.
I wanted to ask you... Is there any utility (either in oracle or in JD) to monitor activities that update a table. Just like JD logs. But only for a single table. That utility will be kept active for the problematic table all the time. In case the problem repeats, i will get some clue.... as what was going on at database level when the problem occured. Periodically this log or table will be checked and will be deleted.
thanks in advance,
Rahul N.
OneWorld B73.3.2 (SP 10.1), NT 4.0, Oracle 8.1.6
We faced a problem in Accounts Payable module - all of a sudden 180 batches of one unit were changed to pending status, which were actully in posted status... This is second time the problem has occured. We don't know what are the exact set of actions which cause this problem.... whether a single application or multiple concurrent applications.... I am still on the back of it.
I wanted to ask you... Is there any utility (either in oracle or in JD) to monitor activities that update a table. Just like JD logs. But only for a single table. That utility will be kept active for the problematic table all the time. In case the problem repeats, i will get some clue.... as what was going on at database level when the problem occured. Periodically this log or table will be checked and will be deleted.
thanks in advance,
Rahul N.
OneWorld B73.3.2 (SP 10.1), NT 4.0, Oracle 8.1.6