Announcement

Collapse
No announcement yet.

How to purge shipments based on a Saved Query in OTM

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to purge shipments based on a Saved Query in OTM

    Hi ,

    I want to purge shipments older than 3 yrs based on a Saved Query in OTM(6.3.3). I've directly written SQL in Saved query but it's returning complete set of orders and updating "MARKED_FOR_PURGE" to 'Y'. Also Configuration and Administration-->Mark for purge and then Business Process Automation-->Recurring Processes-->Schedule Purge but parameters are not there how to proceed here? Please suggest.

    =================
    SELECT SHIPMENT_GID
    FROM SHIPMENT
    WHERE INSERT_DATE BETWEEN TO_DATE('01-JAN-2013 00:00:00','DD-MON-YYYY HH24:MI:SS') AND TO_DATE('31-DEC-2015 23:59:00','DD-MON-YYYY HH24:MI:SS')
    =================

    Thanks,
Working...
X