Symptom
- An error occurs when creating a determination for any service when the target value contains inch notation.
- Error message: "Invalid expression. Operator missing in the expression."
Environment
SAP Sales Cloud and SAP Service Cloud Version 2
Reproducing the Issue
- Go to Extensibility Administration.
- Open any service.
- Navigate to Determination.
- In the assignment block, enter the expression: {extensions/ZABC} = ( ' X'' ' ); Where ZABC is a custom field which needs to be denoted in Inches and X is the number of inch
- Observe the error: "Invalid expression. Operator missing in the expression."
Cause
- The value includes two single quotes (X'') to denote inches inside the string. Single quotes are used as string delimiters in expressions, so embedded single quotes break parsing.
- The expression parser expects the assigned value to be enclosed by a single pair of single quotes and does not support using single quotes as literal characters within the value.
Resolution
- This is the standard system design.
- Replace the two single quotes used to represent inches with a double quote (X") character.
Keywords
determination, opportunity item, invalid expression, operator missing, custom logic, code list, single quote delimiter, double quote inches, parsing error, assignment block, expression syntax, ZThickness, inch notation, quotes in values, string delimiter , KBA , CEC-CRM-CZM-CUL , Custom Logic for for SAP Sales/Service Cloud , How To
Product
SAP Sales Cloud and SAP Service Cloud Version 2 all versions
SAP Knowledge Base Article - Public