Infor has an OLM purge "under development" but I have not heard when it will be available so any purge/cleanup is on the customer to do.
If there are any audit concerns you may want to create history files to store purged records to or do a soft delete(update record ID). I just delete them since we have archival backups available.
Primary key for OLM files are warehouse + load number. Be sure to include the ZPD table in your OLM purge routine.
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, April 17, 2019 7:17 AM
To: BPCS ERP System <bpcs-l@xxxxxxxxxxxxxxxxxx>
Subject: [External] Re: [BPCS-L] OLM file clean up.
I think what Bob is looking for is: "Why are the old load records still there?" Basically asking if there is some purge program he should be running at month end or some such thing. And I believe he is hoping for a user oriented option to do so and not a "use SQL or write a program to purge these records" type of solution.
If I'm wrong Bob can correct me.
I'm more of a sysadmin guy and others here handle our LX stuff.
-----Original Message-----
From: BPCS-L <bpcs-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Doc Waikato
Sent: Wednesday, April 17, 2019 2:43 AM
To: BPCS ERP System <bpcs-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [BPCS-L] OLM file clean up.
Bob,
Depends on how far back you wish to havehistory of Loads.
Any load records older than your order entry orders have no value and can be removed.
Regards
Doc
On Thu, Apr 11, 2019 at 9:24 AM Bob Kohlndorfer <bkohlndorfer@xxxxxxxxxx>
wrote:
Can anyone tell me if there is a native way to clean up the OLM files?
LLH/ LLM/LLL etc. files are getting pretty large and would like to
clean them up a bit.
Thanks,
Bob Kohlndorfer
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message
email: BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&reserved=0
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please
take a moment to review the archives at
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&reserved=0.
--
This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&reserved=0
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&reserved=0.
--
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=j8%2F%2BOhnaNRnxfpiyGz0RObPO%2F5Tof1DQeBRzsVDeSzE%3D&reserved=0
or email: BPCS-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fbpcs-l&data=02%7C01%7Cchris.wynn%40abmauri.com%7Cfcc661ef64fb486d29d308d6c32e9a49%7C39c5be5d25104eee9ca0197a6e89e482%7C0%7C0%7C636911002255255401&sdata=G8zVdwdQP3O%2F%2BPvje1IgjFiwFM67j0lR1CzP%2Fha3cZA%3D&reserved=0.
________________________________
The views expressed in this e-mail are the views of the individual and may not reflect the views of the organisation. Associated British Foods accepts no liability for any losses or damages arising from reliance on the information contained in this e-mail. The information contained in this e-mail is confidential, may be legally privileged and is intended solely for use by the individual or organisation to whom it is addressed. E-mail information is subject to copyright and must not be used, disseminated, copied or disclosed to third parties without the written consent of Associated British Foods. If you are not the intended recipient you should delete this e-mail, destroy all copies and inform the administrator: admin@xxxxxxxxxxx. Copyright Associated British Foods plc. All Rights Reserved.
Registered Office: Weston Centre, 10 Grosvenor Street, London, W1K 4QY. A limited company registered in England 293262
midrange.com
