Plans for a major retail development on the outskirts of Cork City are in doubt after planning for an access road was shot down.