I have upgraded the OWB repos from 10.2.0.3 to 11.2. After that I deployed the mappings. Some of the mappings which is pointing to a remote database is missing there db links.
This is the warning:
ORA-06550: PACKAGE BODY, line 53, column 4:
PL/SQL: ORA-00942: table or view does not exist
This error is due to that the pl//sql script generated by the mapping dont include a dblink in the SELECT statement:
It should read:
It does not help to drop the mapping and redeploy it. It seems that in the mapping, the table have lost its reference to the repository object:OWB_OWNER/NGDALA/NGBOOT/FORETAG
One workaround is to manually use "syncronize" on every table, then genereate and deploy. But this will take for ever! Its many hundreds of mappings.