SSDT - Unresolved Reference to temporary table in linked server
I know this is an old question, but I want to throw this out there in case anyone else happens upon this post.  Create a "scripts" folder in your SQL Database Project, and add a Pre-Deploy script that will create the temporary table in Oracle; right click on the script and set the Build Action to PreDeploy.  I know it's not the most elegant solution, but it's quick and dirty, and will get the job done. 

You'll have to "Build" the project before you publish it, which may still generate the unresolved object error; in that case you'll have to create the table before you build, and then drop it after, but it should work.