Table ET_LOCMAT: Referential integrity violated

[Former Member]

Hi ,

I got an Error Message in SNP optimisation run as "Table ET_LOCMAT: Referential integrity violated". and the run got terminated. in step 2.

Can anyone explain some details for understanding the error.

regards

Kumar

[Former Member · Accepted solution]

Kumar,

Of course this is the data consistency issue.

if you are on SCM 4.0 SP 12 or less, refer OSS Note:

741376. That explains in detail.

Regards, SB.

[Former Member · Accepted solution]

Hi,

I know that it is consistency issue. but i want to know the link with table ET_LOCMAT ..how the consistency is checked by system?. However thanks for reply.

[Former Member · Accepted solution]

Hi

One example may be that you have more than one scheduling agreement valid for the same product from the same supplier at the same time, I had that issue once and the Optimiser cannot cope with it!

Regards

Ian