Routing creation in SAP ME

[Former Member]

Hello Friends,

I have an issue related to routing creation in SAP ME 6.1.4.

I have transferred a routing from ECC to ME for a material which is not QM managed.

In ME I have created special operation Rework 1. When I try to assign it in the routing in ME and save I get the following error:

"java.lang.RuntimeException: java.lang.Exception: nested exception is: java.sql.SQLSyntaxErrorException: ORA-00904: "ERP_INSPECTION_COMPLETE": invalid identifier"

There are inspection chars assigned to any operation in the routing.

Can some one please let me know the reason for this?

Many thanks in advance

K S Srinivas

[sergiy_katerinich · Accepted solution]

Hi,

This means that you have an old version of WIP database structure. You should execute a database migration CTC task from ME 6.1 to 6.1.4. This will execute the following query that adds the missing field:

ALTER TABLE ROUTER_STEP ADD ERP_INSPECTION_COMPLETE NVARCHAR2(5)

Regards,
Sergiy

[Former Member · Accepted solution]

Hello Sergiy,

Thanks a lot for the input. I will get this checked and revert back.

Regards,

K S Srinivas

[Former Member · Accepted solution]

Hello Sergiy,

Thanks. The issue has been resolved as per your inputs.

Regards,

Srinivas