Announcement

Collapse
No announcement yet.

OTM 5.5 Data Purge not working properly

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

  • OTM 5.5 Data Purge not working properly

    Hello

    I am trying to purge 2 years older data of SHIPPMENT and ORDER RELEASE from OTM 5.5 using Data Purge UI (Process Management > Data Purge). The purge process completed without error. I can see that shipment data has reduced significantly. However order release data was not properly purged. I tried to run the purge process again but this time it is not populating any data in job_queue table. Can anyone help me to troubleshoot the issue.

    This is the data after purge is complete:
    -----------------------------------------------------------
    select min(insert_date) from GLOGOWNER.ORDER_RELEASE;
    MIN(INSER
    ---------
    16-SEP-09

    select count(order_release_gid) from order_release where insert_date < (select sysdate-760 from dual);
    COUNT(ORDER_RELEASE_GID)
    ------------------------
    2300275

    Thanks
    Amit
Working...
X