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
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