Hi Friends,
I am encountering a unique problem.
I had run a setup for 2LIS_13_VDKON in R3 on 16-July-10 and loaded it in DSO through INIT.
Yes, I did delete the setup table first before running it.
Now, I loaded data in ODS and couple of deltas and got the UAT sign off. There have been deltas running everday since then.
Suddenly, user came up reporting double amounts for some invoices. When I tracked back I found that the INIT came up with duplicate records for same bill/invoice number (two records for same invoice with no change in any field). By far, I have tracked like 100 invoices getting duplicate values. I am not sure if all the invoices came up with duplicates. I am not able to check that as there were millions of records that came in this INIT. Since, I didn't had a check on 'Duplicate Records' in ODS properties it got loaded in ODS doubling the amounts (yes, a keyfigure!).
I found that in PSA first 36 Data packets came up. Then Data packet number 37 have many invoices and from certain point duplicates started flowing in Data packet number 37 itself and went on from 37 to 73.
Now, I have to resolve this issue. The solutions, I can think of:
Sol 1) Delete all loads from ODS. Change settings of ODS to have unique records only. Reload data from PSA starting from INIT.
This will in itself be a horrenduous task as daily deltas have been flowing form 5 months!
BUT then I guess, I will get a duplication error and the load will fail?
Sol 2) Rerun the setup again!!! I am trying to avoid this because this SETUP, I got it correct after multiple runs of setup tables.
And getting downtime is another problem!
There's one more solution I thought but gave up on it:
Sol 3) Can this be solved by writing a ABAP program and diving the amounts by 2. But then I don't know if all invoices have double amounts and how to make sure that division should happen only for data loaded throuhg INIT?
Btw, I am using BW 3.5.
Would appreciate any help. Looking forward for your solutions.
Thanks a lot!