SAP Knowledge Base Article - Public

2259719 - Email received: "metric-lookup-table Metric Lookup table has wrong entry." when importing Metric Lookup Tables - Goal Management

Symptom

Customer tries to import a goal with MLT (Metric Lookup Table) but the MLT is not updated and receives the following email: "Field Name: metric-lookup-table Metric Lookup table has wrong entry".

  • Goal Plan with no MLT

 Goal Plan - no MLT.PNG

  • Email received

Email - no MLT.png

Environment

SuccessFactors Business Execution Suite - Goal Management

Cause

MLT must have at least 2 rows per goal. If you import only 1 row of MLT for a goal, then you it will not update correctly and you will receive the email as shown above.

Goal Import file - 1 row MLT.PNG

Resolution

Update the Goal Import file and add at least 2 rows of MLT for a goal.

Goal Import file - 3 row MLT.PNG

Import it back to the system and the MLT will update correctly and a confirmation via email.

  • Goal Plan with MLT

Goal Plan - with MLT.PNG

  •  Email received

Email - with MLT.PNG

See Also

2072202 / Manage Templates - Metric Lookup Tables - Goal Management: https://i7p.wdf.sap.corp/sap/support/notes/2072202

2183735 / Manage Templates - Metric Lookup Tables (MLT) Not Auto-Populating - Goal Management: https://i7p.wdf.sap.corp/sap/support/notes/2183735

Keywords

Metric Lookup Table, Goal Plan, Goal Import, email. , KBA , LOD-SF-PM-GM , Goals in PM Form , Problem

Product

SAP SuccessFactors HCM Suite 1511