SAP Knowledge Base Article - Public

2648304 - Workflow Rule with Condition as Date type Field Equal to Empty Does Not Work

Symptom

You created an extension field XYZ (XYZ represents the extension field name) with type Date on a business object ABC (ABC represents the business object name).

You defined a workflow rule on ABC with a condition as XYZ Equal to Empty.

The workflow rule does not work.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidentance to real data is purely coincidental.

Environment

SAP Hybris Cloud for Customer.

Reproducing the Issue

Check the field type of the extension field.

  1. Go Adapt mode and click Edit Master Layout.
  2. Open the business object ABC.
  3. Find the extionson field XYZ and open Field Difinition link for XYZ.
  4. Check the type of XYZ is Date.

Check the workflow rule.

  1. Go to Administrator work center.
  2. Go to Workflow Rules work center view.
  3. Edit the workflow rule.
  4. Go to step 2. Define Conditions.
  5. You defined a condition as XYZ Equal to Empty.

Check for the business object.

  1. Open the business object ABC.
  2. Check the value of XYZ is empty without any value maintained.

However, the workflow rule cannot be triggered.

Cause

For Date type fields, if there is no value maintained, empty value will always be stored as 00.00.0000 in backend intead of empty.

The condition cannot be fulfilled, therefore the workflow rule cannot be triggered.

Resolution

When edit the workflow rule, change the condition as XYZ Less than 01.01.0001.

workflow rule.PNG

Keywords

workflow rule, Date , KBA , LOD-CRM-WKF , Workflow , Problem

Product

SAP Cloud for Customer add-ins all versions