2656423 - Multiple Download/Upload of Territory Rules Results in Failure of Territory Derivation

SAP Knowledge Base Article - Public

2656423 - Multiple Download/Upload of Territory Rules Results in Failure of Territory Derivation

Symptom

You created an Excel spreadsheet for territory rules and uploaded it to Cloud for Customer, but after downloading and uploading the rules again/multiple times, the rules stop working and territories are not derived as defined in the rules.

Environment

SAP Cloud for Customer

Reproducing the Issue

Pre-requisite: You created an Excel spreadsheet for territories rules including exclusion conditions.

  1. Go to the work center Administrator.
  2. Go to the view Sales and Campaign Settings.
  3. Open Define Rules for Territory Realignment.
  4. Go to Upload.
  5. Select your previously created spreadsheet.
  6. Activate the rules.
  7. Go to Download.
  8. Save the spreadsheet locally.
  9. Go to Upload.
  10. Select the previously downloaded version of your spreadsheet.
  11. Activate the rules.

Result: The territory rules do not work anymore and territories are no longer derived.

Cause

You created an Excel spreadsheet with exclusion conditions as follows:

Exclude [ZABC ; ZDEF ; ZGHI ; ZJKL ; ZMNO]

After download and re-upload, the entries change to

" "; exclude [ZABC ; ZDEF ; ZGHI ; ZJKL ; ZMNO]

This is the reason why the territory rules are not executed any longer.

Resolution

In the Excel spreadsheet, an exclusion list has to be defined as follows:
Exclude ZABC ; ZDEF ; ZGHI ; ZJKL ; ZMNO
(= without brackets).

Keywords

territory rules, rule download, rule upload, exclusion condition, rule condition , KBA , LOD-CRM-TM , Territory Management , Problem

Product

SAP Hybris Cloud for Customer all versions