[Goods Receipt - Revenue Account] , 'Field cannot be updated (ODBC -1029)' [Message 131-183]

[former_member209954]

     Hello,

     I'm facing a weird problem and I was wondering if someone could share some light about this. In a nutshell, the system just got migrated from SAP v 8.82 to v 9.1 (to be exact, to 9.10.210 PL: 11). When I try to update a User Defined field in an existing "Receipt from Production" Form, I get the following error: "Field cannot be updated (ODBC - 1029)".

* If I use a custom tool to update the field, I get the following error: [OIGN.CardCode] , 'Field cannot be updated (ODBC -1029)'

* However, if I use the SAP Client (32 bits) to update that very same field in the very same form, I get the following error: [Goods Receipt - Revenue Account] , 'Field cannot be updated (ODBC -1029)'  [Message 131-183].

* I queried OIGN, and I see that the CardCode has a valid value already. CardName, though, is NULL in all records.

* However, neither the custom app nor the SAP Client are trying to modify the value of this field, or any other field within the form (In fact, I cannot find this "CardCode" anywhere within a Receipt from Production form).

* I have no idea what is the Revenue Account, or what it has to do with a Receipt from Production Form. Either way, I'm not modifying that field either.

     Any help is greatly appreciated!!!

     Manuel

[former_member209954 · Accepted solution]

Ok, I just found more information about this problem.

* Forms created BEFORE the upgrade to SAP 9.1 are having this issue.

* However, forms created AFTER the upgrade work well.

     These are grounds to declare that the database upgrade scripts failed.

     Any help is greatly appreciated.

     Best Regards,

     Manuel

[frank_wang6 · Accepted solution]

This is a known issue. Just closed all the old Production order and re-create them in 9.1. It should be fine.

I saw the same issue when we upgraded from 9.0 to 9.1. Old productions can not be completed any more.

Frank

[former_member209954 · Accepted solution]

    Hi Frank,

    Thank you very much for your suggestion. I was able to replicate both symptoms with new Production Orders. Most likely, there is a SAP configuration that I just cannot find.

    No big deal, though. I modified my custom application by adding code so, if the version of SAP is 9.1 or later then the CardCode field (the customer code) is not populated in the "Receipt from Production" form.

    Best Regards,

    Manuel