Was Adam supposed to sin in God's great plan?

Thanks.

Regards
DL