Enabling CDC on a Synonym
Is it possible to enable CDC on a synonym ?
We are using Oracle Applications R12. As the design goes, we have the tables present int their respective functional schemas. All these tables have their synonyms defined in Apps. We have only one data model defined which connects to APPS schema.
What is the way to journalized tables which are lying in other schemas ? I tried to enable CDC on the table synonyms lying in APPS, but "Start Journal" fails with "ORA-00942: table or view does not exist".
Is there any way we can do this without defining numerous data models each mapping to a particular functional schema and starting journal on each one of them.