Order purge agent not purging orders

Resolving The Problem

All the completed orders in the YFS_ORDER_HEADER cannot be purged by the Purge agent. There are various criterias that need to be fulfilled before the order purge agent purges these records. Some of these criterias are as below.

The following statuses are available for configuration to be picked up by Order Purge:

• Draft Created (1000) and all extended Draft Created Statuses.
• Created (1100) and all extended Created statuses. These statuses are available only for document types Sales Order, Purchase Order and Transfer Order.
• Released (3200) and all extended Released statuses.
• Shipped (3700) and all extended Shipped statuses.
• Received (3900) and all extended Received statuses.
• Cancelled (9000) and all extended Cancelled statuses.
• Shorted (9020) and all extended Shorted statuses.

If the following conditions are met, an order is picked up for purge:

• All open child orders (derived, chained, return, exchange, procurement, or refund fulfillment) for the order must already be purged.
• No pending transfer-out charges to another order exceeding the transfer-ins.
• No pending adjustment invoices.

An order is purged immediately if it meets the above three criteria and is
completely cancelled with payment collection complete.

If an order does not meet any of the above criteria, continue checking for  the criteria given below:

• No order release status record that does not meet the retention days.
• It should be in the correct status for purge. For example,
          – All service requests for the order should have Shipped or extended Shipped status.
          – The payment status for the order should be Paid, Cancelled, or Not Applicable.
          – It must not have any unpurged negotiations.
• For all order lines other than service request lines:
          –If the Seller inventory update is required, the Status Inventory Type has the "Update Seller Supply" option turned on, and the Seller Supply Type is "Onhand", or blank. (The Seller Supply Type can also be a custom seller supply type with the "Onhand Supply" checkbox enabled.)
          – If the Seller Demand Type is blank.
          – If the Buyer inventory update is required and the Buyer Supply Type is "Onhand", or blank.
• The order's last modification should fall before the lead time setup.
• Any enterprise using the Sterling Multi-Channel Fulfillment Solution Consoles must schedule purge transactions.
• The order must not have a undelivered service line.
• In the case of an exchange order for processing a return order, the exchange order should be purged from history before the return order can be purged.

Please refer to Distributed Order Management Configuration Guide ----> Appendix A. Time-Triggered Transaction Reference ---> A.3.3 Available Purges ---> Order Purge, for detailed explanation/logic regarding when orders can be consider in a purgable status.