Symptoms

Trying to export, add notification then import result in error:
"Notification Template 'Office 365 Expiration' was neither provided in Excel configuration nor found in the system for account 1"
But Subscription Expiration exists.
Ho do I set Plan "Notification Schedule"?
Ho do I set Plan Periods "Notification Schedule"?
What is ExpirationNotificationTemplate? 



Cause

When a PPR is uploaded and has ExpirationNotificationTemplate value specified in it. For example ExpirationNotificationTemplate="XXX". The system will create a subscription expiration schedule with name "XXX". The schedule will be configured in a way that "XXX" notification template will be sent on the subscription expiration day. Yes, notification template and subscription expiration schedule will have the same name - "XXX". 


The error is telling us that the "XXX" notification template does not exist neither in the excel file, nor in the system.

There is a tab in the PPR excel file called "NotificationTemplates", where this notification called "Office 365 Expiration" is searched in the first place (This tab is optional). If this template is not located in the excel file, the system search for it in your notification templates on the CloudBlue platform. If you go to "Billing" => "System" => "Settings" => "Notifications" => "Notification templates" you will see all your notification templates.


Resolution


There are 3 options to fix the issue;

- Change the name of "ExpirationNotificationTemplate" in the excel file to one of your existing templates in "Billing" => "System" => "Settings" => "Notifications" => "Notification templates"
- Create the notification template in the excel tab "NotificationTemplates" (You can refer to this in the PLM documentation File Requirements )
- Create a new notification template called "XXX" under "Billing" => "System" => "Settings" => "Notifications" => "Notification templates".


Note: In case default parameters/settings of the created subscription expiration schedule are not good enough, they can can be modified directly in classic CP. 


> Ho do I set Plan Periods "Notification Schedule"?

PLM cannot set notification schedule for plan periods.