3222209 - Error:"The following database error occurred: [Data Federator Driver] [Server] Table [TableName] is not found" appears when running a multi source universe in Web Intelligence

• Below error appears when refreshing a web Intelligence document based on a multi source universe:
  
  "The following database error occurred: [Data Federator Driver] [Server] Table [TableName] is not found.For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)"
  
  
• There is no problem with single source universe.
• At universe level, in Information Design Tool (IDT), when clicking 'Show table values' option at the data foundation layer, the same error is seen.
• When opening the connection in IDT and browsing the problematic table, the table is showing but expanding it to show the columns, it doesn't display the columns.

• SAP BusinessObjects Business Intelligence platform 4.x
• Web Intelligence
• Information Design Tool
• Multi source universe
• Oracle database

KBA , BI-BIP-IDT-CX , Connection Layer , Problem