FDMEE - EBS Source System > Non-APPS Schema?
Hi Experts!
For security and compliance reasons, we want to use a non-APPS account for our Oracle EBS Source System as configured in FDMEE 11.1.2.3.
Using the ODI Console, I've created a Data Server with connection info to our production systems, using READAPPS (a read-only version of APPS).
THEN, I linked a Physical Scheme named APPS, thinking ODI/FMDEE would just prefix with the same APPS scheme, knowing of course that any write-back/modify operations would fail.
BUT, whenI initialize the new source, I get a ORA-00942: table or view does not exists at the initial EBS Update Source System Base Language step.