• SUNETRA DEY
  • NEWBIE
  • 5 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 4
    Replies
I am stuck in the second chllenge on Automate Accounts in Process Automation Specialist Superbadge.I'm getting this error-
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.
*
I have used the following Validation Rules on Accounts object-

(1)Billing_Country_Validation_Rule-------------------------------------------
Validation Formula: --------------------------------------------------------------------------------------------------- NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry))) ------------------------------------------------------------------------------------------------------
(2).Billing_State_Validation_Rules -----------------------------------------------Validation Formula-------------------------------------------------------
OR( LEN(BillingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", BillingState)) ) ------------------------------------------------------------------------------------------------------- (3).For_Customer_Channel ----------------------------------------------------------Validation Formula--------------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel') -------------------------------------------------------------------------------------------------(4).For_Customer_Direct -------------------------------------------------------------Validation Formula-----------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' ) ----------------------------------------------------------------------------------------------------- (5).Shipping_Country_Validation_Rule ----------------------------------------Validation Formula----------------------------------------------------------- NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry))) ---------------------------------------------------------------------------------------------- (6).Shipping_State_Validation_Rule----------------------------------
Validation Formula---------------------------------------------- OR(LEN(ShippingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", ShippingState)) )

Please help me to complete this challenge..
I am unable to complete the second chllenge on Automate Accounts in Process Automation Specialist Superbadge.I'm getting this error-
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.

*
I have used the following Validation Rules on Accounts object-

(1)Billing_Country_Validation_Rule-------------------------------------------
Validation Formula: --------------------------------------------------------------------------------------------------- NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry))) ------------------------------------------------------------------------------------------------------
(2).Billing_State_Validation_Rules -----------------------------------------------Validation Formula-------------------------------------------------------
OR( LEN(BillingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", BillingState)) ) ------------------------------------------------------------------------------------------------------- (3).For_Customer_Channel ----------------------------------------------------------Validation Formula--------------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel') -------------------------------------------------------------------------------------------------(4).For_Customer_Direct -------------------------------------------------------------Validation Formula-----------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' ) ----------------------------------------------------------------------------------------------------- (5).Shipping_Country_Validation_Rule ----------------------------------------Validation Formula----------------------------------------------------------- NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry))) ---------------------------------------------------------------------------------------------- (6).Shipping_State_Validation_Rule----------------------------------
Validation Formula---------------------------------------------- OR(LEN(ShippingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", ShippingState)) )

Please help me to complete this challenge... 
I am stuck in the second chllenge on Automate Accounts in Process Automation Specialist Superbadge.I'm getting this error-
*
Challenge Not yet complete... here's what's wrong:
A validation rule did not prevent a new Account from being saved when Shipping Country is blank and Shipping State has three characters.
*
I have used the following Validation Rules on Accounts object-

(1)Billing_Country_Validation_Rule-------------------------------------------
Validation Formula: --------------------------------------------------------------------------------------------------- NOT(OR(BillingCountry = "US", BillingCountry = "USA", BillingCountry = "United States", ISBLANK(BillingCountry))) ------------------------------------------------------------------------------------------------------
(2).Billing_State_Validation_Rules -----------------------------------------------Validation Formula-------------------------------------------------------
OR( LEN(BillingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", BillingState)) ) ------------------------------------------------------------------------------------------------------- (3).For_Customer_Channel ----------------------------------------------------------Validation Formula--------------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Channel') -------------------------------------------------------------------------------------------------(4).For_Customer_Direct -------------------------------------------------------------Validation Formula-----------------------------------------
ISCHANGED( Name ) && ISPICKVAL(Type, 'Customer - Direct' ) ----------------------------------------------------------------------------------------------------- (5).Shipping_Country_Validation_Rule ----------------------------------------Validation Formula----------------------------------------------------------- NOT(OR(ShippingCountry = "US", ShippingCountry = "USA", ShippingCountry = "United States", ISBLANK(ShippingCountry))) ---------------------------------------------------------------------------------------------- (6).Shipping_State_Validation_Rule----------------------------------
Validation Formula---------------------------------------------- OR(LEN(ShippingState) != 2, NOT(CONTAINS("AL:AK:AZ:AR:CA:CO:CT:DE:DC:FL:GA:HI:ID:" & "IL:IN:IA:KS:KY:LA:ME:MD:MA:MI:MN:MS:MO:MT:NE:NV:NH:" & "NJ:NM:NY:NC:ND:OH:OK:OR:PA:RI:SC:SD:TN:TX:UT:VT:VA:" & "WA:WV:WI:WY:PR", ShippingState)) )

Please help me to complete this challenge..
I'm unable to check step 2: Automate Accounts because I'm receiving this error: Challenge Not yet complete... here's what's wrong: 
There was an unexpected error while verifying this challenge. Usually this is due to some pre-existing configuration or code in the challenge Org. We recommend using a new Developer Edition (DE) to check this challenge. If you're using a new DE and seeing this error, please post to the developer forums and reference error id: ZKCVFIZH