Skip to Content
author's profile photo Former Member
Former Member

repairing data loaded from 2LIS_11_VAITM

Hi,

Due to an oversight, the fiscal year variant for 2007 was not loaded in before the change of the year and we had data loading problems before this was corrected. After the variant problem was fixed, the delta loads have been OK but we have missing or erroneous data in BW for a few hundred records from that first day. The data flow looks like:

Sales Orders Cube <- Sales Orders ODS <- Sales Order IS <- 2LIS_11_VAITM

What I would like to do is delete out the records that were loaded during the suspect time (a few thousand records at most) and load them in again. I have read note 739863 and believe that the best thing to do is apply a repair request. I have the steps as the following:

1. use the logistics cockpit to delete the setup table and fill it with records from the period in question

2. selectively delete the data from the ODS from that same time period

3. Create an infopackage to as a full data upload into the PSA only and select the full repair request flag.

4. Run the infopackage and examine the results in the PSA.

5. If the PSA data looks OK, update the data targets.

Am I missing any steps? Do I need to do anything to restore the set-up table to allow the delta loads to continue?

Thanks.

Rob

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 10:06 PM

    your steps are correct.. you neednt do anything to restore the set-up table to allow the delta loads to continue?..as the data in set-up tables is for full load and delta intilization only.. the deltas in your case are not disturbed..

    your deltas are taken care by the v3 jobs that are scheduled to collect deltas in extraction queue later RSA7.. so you neednt worry about set-up tables data..to restore for delta.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 09:00 PM

    Thank you for the helpful answer. The process went well (although I did have some duplicate records that needed to be cleaned up). I awarded you points for your trouble.

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.