Retail and Consumer Goods - No valid Delivery Recipients when creating Advanced Orders

It's possible that the error is caused when the following query returns 0 rows:
1. SELECT cgcloud__Account__c FROM Account_Extension__c WHERE (Delivery_Role_Valid_From__c <= :tmpVar1 AND Delivery_Role_Valid_Thru__c >= :tmpVar2 AND Account__c = :tmpVar3) ORDER BY Account__r.Name ASC NULLS FIRST
2. The above runs in the fetchDeliveryRecipientAndWholesaler() and it normally fetches the Delivery recipients of the customer
3. So, if the values for the Delivery_Role_Valid_From__c & Delivery_Role_Valid_Thru__c fields of the account are missing then fill in those values to unblock the creation of the Advance Order for this account.