When I ran RKM E-Business Suite in ODI to pull all %INTERFACE% tables it did not pull tables like MTL_SYSTEM_ITEMS_INTERFACE which is own by INV Schema.
If you run below query you can see that Oracle added # at the end in all_synonyms.table_name column for MTL_SYSTEM_ITEMS_INTERFACE#
select * from all_synonyms where table_name LIKE 'MTL%SYS%ITEM%INTERFACE%'
This was creating problem in all the RKM E-Business Suite queries which was using all_synonyms table.
After changing join t.table_name = syn.table_name to t.table_name = rtrim(syn.table_name,'#') in RKM E-Business Suite Knowledge Module-->Task issue got resolved.
If you run below query you can see that Oracle added # at the end in all_synonyms.table_name column for MTL_SYSTEM_ITEMS_INTERFACE#
select * from all_synonyms where table_name LIKE 'MTL%SYS%ITEM%INTERFACE%'
This was creating problem in all the RKM E-Business Suite queries which was using all_synonyms table.
After changing join t.table_name = syn.table_name to t.table_name = rtrim(syn.table_name,'#') in RKM E-Business Suite Knowledge Module-->Task issue got resolved.
