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

[ianlo]

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]

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

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]

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

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]

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

Dear Ian / Chris,

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

Regards,
Lakshma

[arunk]

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

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 : [email protected]

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]

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

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

[arunk]

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

No need...

Regds--
Arun

[medhas]

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

Hi,

I have two specific questions.

1) From all that the admin guide says , the purged data should reach the archive_object table .How do we access this table.

2) While the shipments are purged , order releases do not get purged and still exist. Is there some way out to purge the OR s simultaneously..

Thanks !

[ianlo]

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

Hi,

2) While the shipments are purged , order releases do not get purged and still exist. Is there some way out to purge the OR s simultaneously..

Thanks !

Hi Medhas,

You don't purge OR's simultaneously but only after you purge the shipments. Under Configuration and administration > Process management > DataPurge you can specify Order Release and Order Bases as separate purging jobs.

You then specify the retention period and then schedule them after purging shipments.

You need to purge shipments first, then order release and the order bases.

Hope this helps!