We've finally got to the bottom of this - the service account linked to the server did not have the correct permissions.
In addition, the networked path \QlikView\ was actually in the my Documents section of the service account on the server - lazy work from the IT team.
Due to the size it has been given its own drive E:\QlikView\ and the correct permissions are now in place and it is working perfectly, I just wish I hadn't spent two days trying to fix the code, thank you to @Krishna 20, awhitfield maxgro and @Kuczynska for your helpful suggestions
Does your server/publisher have access to this DB? Are your QV services setup under the user that can actually access this location? There also might be some other issue (I'm assuming less possible), that maybe there is another query trying to read/write from this table. If your services are setup correctly I would double check with your DBA
Edit: I just noticed that now, apologies - it fails on the store itself, you are able to read from this location. Can you try to rename the csv in your STORE command to something that doesn't have dots? Like CCY_2015_08_10
I am wondering if it is anything to do with the Oracle connectors on the server - the desktops had to have ODAC installed to connect to the DB - and having spoken to one of the server support team , this hasn't been installed on the server.