But lo' and behold, the ODI tables (SNP* etc) are missing within the FDMEE repository. What's going on here?
On your FDMEE server, inspect this file. If FDMEE is clustered across multiple servers, you need to do this on just one server only. Let's assume your 1st FDMEE server is hosted on Windows and resides on the D drive:
Fix the .bat file, re-run FDMEE's "Configure Database" task from the EPM Configurator on just one server. No need to redeploy to WebLogic. Restart FDMEE and you're good.