Skip to main content
Question

Removing old records from CUSTOMER_ORDER_DELIV_NOTE_REP

  • December 15, 2022
  • 1 reply
  • 102 views

Forum|alt.badge.img+18

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?

 

1 reply

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 866 replies
  • December 23, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings