The customer is in the middle of a migration from Apps9 to Apps10 and has asked whether there is a way to remove old records from CUSTOMER_ORDER_DELIV_NOTE_REP.
Is this a possibility?
Userlevel 7
+20
Hi John,
I hope your question is about how to remove data from the view CUSTOMER_ORDER_DELIV_NOTE_REP?
this data is stored in the report table (_RPT) and automatically cleared with the heavy cleanup.
Check if the Heavy cleanup scheduled task is running properly or expire date in the report is set to a long time ahead.
If the expire date is set to a long time from now and you still want to clean the records, have a look at the database procedure Archive_API.Cleanup__ and make your own script to clean the data properly.
Hope it helps!
Damith
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.