To delete both processed and staged orders, use staged for order_type:   1 SQL> incent delete orders staged (BatchNames=(select distinct batch_name from xactly.xc_user_batch bat join xactly.xc...