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