Update Rule Error ( Invalid Data) while load 0VENDOR

[#1]

Hello All,

I have attributes like 0POSTAL_CD of 10 Char (Postal Code) and 0SORTL 0f 10 Char (Sort Field) of Vendor. From yesterday onwards the Production master data loads for 0VENDOR started failing saying:

Record 211 :0POSTALCODE : Data record 211 ('03 2VEN4000040 '): Version 'HK HONG KONG ' is not valid

Record 136 :0SORTL : Data record 136 ('0002000175 '): Version 'SATTLER, I ' is not valid

Solutions tried:

Interstingly what we found is: when u edit the PSA data for the above records and again input the same values, the load runs fine.

I found this thread some what relating to my problem, but I could'nt get the solution.

Please help to solve this issue which I am facing alone....... Thanks for your support

[Former Member · Accepted solution]

Hi Ram,

Really add more valid char is a possible option, but in your case I dont believe that was a good idea...

I believe that this msg is an automatic master data validation.

Ex:

0SORT: is not valid use comma ( , ) or sapce in this field

0POSTALCODE: the value 'HK HONG KONG ' dont seems to be a correct value for a zip code

I belive that this validation is not about allowed extra-char

Check both InoObject and see wich datatype support.

Hope this Help!

[Former Member]

Hi

Please check your transfer rules whether you mapped to correct fields.

It seems you mapped to PO box location to PO box code field.

Regards,

Chandu.

[Former Member]

Hello All,

The Problem got solved......... There was some invisible characters along with these fields......... Once you copy those characteristic and paste them in MS WORD and click TOOLS->OPTION-> click space

you will see some weird character available......... Included that char in RSKC and the loas ran properly