We are facing a strange issue in Oracle APEX. We are finding that the data in a table keeps getting deleted after certain period. 2 Days back we had 20 records, now we have only 6 records. 2 new rows were added today. Any clue/help?
Sounds like someone has forgotten about a 'process' that is running against your tables!
You could do a quick dependency check to see what PL/SQL packages refer to the table and then check them... or switch on auditing for the table to track the source of the changes... or add triggers to 'journal' the changes e.g. record the call stack/backtrace whenever an insert/delete occurs.