Re: Order changes

We had the silimar problems. For performance and security reason, we cannot
set up the trigger on Oracle, and we did the same things as Terri done. The
worst is we even cannot identify the deleted line based on last maintained
date & time. Terri, could you give me a brief explain on "We have had lines
deleted, and L01 was used, so it was never reduced"? what's the L01 means.
We also consider to analyzer the oracle's LogMiner, just like the Quest's
Sharplex, but it is very time-consuming...

Bobby Chen
----- Original Message -----
From: "Chick Doe" <Cdoe@xxxxxxxxxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>
Sent: Saturday, September 13, 2003 2:10 AM
Subject: Re: Order changes


> you might want to consider using triggers on the ECL. we do it and we
> record any time an order is entered , maintained, or deleted whenever
> the order qty or selling price changes. (ie whenever the backlog value
> is affected) the trigger program logs any such changes to a transaction
> file. each evening we then use this file to produce order input value
> reports.
>
> i think you could use the same technique to capture any changes that
> would cause an order to be reprinted and then use the batch program at
> night to read the file and reprint the orders.
>
> >>> THarteau@xxxxxxxxxxxxxxxxxx 09/12/03 05:52AM >>>
>
> Hi,
>       I am on V6.02. We have a program that prints any new orders taken
> out
> the previous day and also any changes made to existing orders. It is a
> batch program that compares entry date and last maintained date to a
> record
> in a work file. If it is different, there has been a change (in item
> number, quantity, price, salesperson or customer). The programs were
> written when we first got BPCS many, many years ago. It was maintained
> to
> keep working, but has some serious holes.  I need to rewrite it without
> the
> holes.  Some of the problems are: the work file is keyed by order #,
> line #
> (the item number can and does change), but we have had users resequence
> the
> order, We have had lines deleted, and L01 was used, so it was never
> reduced, and several unexplained things where it just did not update
> correctly.
>       Does anyone have any ideas on how to track the changes? I'm not
> looking for any product to purchase, it is home grown and needs to
> stay
> that way. I am just starting to look at different ways to do it, and
> thought I would see if anyone else is already doing something similar.
>
> <===================================================>
>
> Terri Harteau
> ****************
> "There's no point in being grown up if you can't be childish
> sometimes."
> - Dr. Who
> ****************
>
>
>
>
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.