Archiving Of Data Other Than Shipment / Order Release / Order Base / Items

ianlo · #1 (**permalink**) May 15th, 2008, 01:43

Hi

Has anyone implemented their own archiving script to archive business objects other than the standard ones provided in OTM?

Specifically, I would like to housekeep:

1) Invoices
2) Vouchers

Thanks!

chrisplough · #2 (**permalink**) May 22nd, 2008, 13:37

Ian,

I haven't seen this expanded to other business objects yet. If it were, my only concern would be around patch management, since OTM patches can update both the archive scripts and the Archive schema.

--Chris

ianlo · #3 (**permalink**) May 22nd, 2008, 13:49

Hi Chris,

Thanks for the reply. I think I will have to ask my DBA to design some scripts that will archive these business objects to another tableowner like SCH_ARCHIVE and only provide the necessary grants from GLOGOWNER to execute.

Hopefully this will help buffer the impact of any changes to the OTM schema during patches / migration.

Ian

MURTHYKO · #4 (**permalink**) August 21st, 2008, 05:25

Dear Ian / Chris,

Could you pls explain me the process of purjing OTM Shipments?

Regards,
Lakshma

arunk · #5 (**permalink**) August 22nd, 2008, 08:54

Lakshma,

We can purge shipments and Orders from the front end.

Navigate to,

Configuration and administration --> process management --> DataPurge

(for example)

Command : shipment
Age in days: 3 ( you can give any number of days)
Domain name: yourdomain
Email : abc@xyz.com

And check the box purge by application --> now.

If you choose schedule then you can specify the time also when you want the data to be purged.

When you choose the option purge by application, then there is a purge procedure that has come through the product that performs this function.

Hope this helps...

Regds--
Arun.

MURTHYKO · #6 (**permalink**) August 23rd, 2008, 01:15

Thanks Arun, to work do we need to turn on any property in "glog.proprties" file?

arunk · #7 (**permalink**) August 25th, 2008, 05:29

No need...

Regds--
Arun