Extend Support to Additional Tables for Purge Handling

The purge process enhances performance by optimizing data retention and improving storage efficiency. You can schedule the records deletion (purge) according to predefined timelines.

The following tables are included in the existing Purge Script:

Table

Time Frame to be Purged

FROM_MANUFACTURING_TRANSACTION_HDR Purging data older than 5 years.
FROM_MANUFACTURING_TRANSACTION_DTL Purging data older than 5 years.
FROM_MANUFACTURING_TRANSACTION_DTL_SERIAL_NBR Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_DTL Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_HDR Purging data older than 5 years.
FROM_MHE_CYCLE_COUNT_INFO_SERIAL_NBR Purging data older than 5 years.

Steps to Enable

You don't need to do anything to enable this feature.