Hi @smanikonda,
I think I found the issue, but I can’t test since I don’t have Oracle. Essentially, I have been setting tempOracleSchema to scratchDatabaseSchema in every SqlRender translate call, which is making the temp tables become named “#.tablename”, which is invalid.
Can you uninstall Achilles completely and try installing the oraclefixes branch by using this command:
devtools::install_github("OHDSI/Achilles", ref = "oraclefixes")