Thanks @johanandren !
Once I ran the oracle-create-schemal.sql script, I kept getting the same error. Weird. So I decided to turn on DEBUG level log in logback.xml which made me realize this is the prepared statement which is causing the error:
[2021-04-07 09:49:16,897] [DEBUG] [slick.jdbc.JdbcBackend.statement] [slick.db-1]  - Preparing statement: select s94.s68, s94.s64, s94.s67, s94.s65, s94.s69, s94.s66, s94.s62, s94.s63, s94.s70 from (select “meta_ser_id” as s62, “meta_ser_manifest” as s63, “sequence_number” as s64, “snapshot_ser_id” as s65, “snapshot_payload” as s66, “created” as s67, “persistence_id” as s68, “snapshot_ser_manifest” as s69, “meta_payload” as s70 from “snapshot” where “persistence_id” = ? order by “sequence_number” desc) s94 where rownum <= 1
If you compare the oracle-create-schema.sql file to the prepared statement above, it seems the create schema script is using SNAPSHOT as the name of the table/view where as the Akka app is referencing snapshot. I am wondering if the difference in case has something to do with this error?