How do we investigate about the missing records in a table?

[jchellap]

Hi All,

I found a huge amount of records are missing in the table isb_mstr nearly 50,000 records.

I am not sure what could happen. Can anyone of you please suggest me an idea about how to start an investigation regarding this?

 

[rzr]

Check if you have audit enabled ?
Do you have a DELETE trigger on this table? Check if there trigger when on delete - deletes the record from isb_mstr and copies it to some archive isb_mstr table...

I have no knowledge of how QAD works - so do not know if they have any utility that can check this.....