Jul 19, 2019 12:20 PM
Ok, I think I resolved this issue....with 10.2.2, synonyms can be used as a regular reference. With 11, you need to explicitly indicate the schema it comes from. For example, in 10.2.2, the Schema value in FM is "EDW", which in the EDW schema in Oracle, our table is really a synonym to "EDWB". With ...