OBIEE 12C: Issue with Table Owner Prefixed in Query

Question

HI Gurus, We are facing an issue while fetching the SQL query for OBIEE 12c custom report Query. In the query, the physical table is getting prefixed with table schema owner name. (i.e. . on the other hand 11g OOB report’s query , we are not facing such issue, the table name is not getting prefixed with schema name. 11g :- WITH SAWITH0 AS (select T577898.DAY_DT as c1 from W_DAY_D T577898 /* Dim_W_DAY_D_Common */ ) select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001 12c WITH SAWITH0 AS (select distinct T292.ADDR1 as c1 from D_CUST_DETAILS_TBL T292) select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001 12C: WITH SAWITH0 AS (select distinct T157.LEVEL1 as c1 from OFSATOMIC.DIM_COMMON_COA_MASTER T157) select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001 Any pointer to how to eliminate schema owner name(OFSATOMIC) adding in 12c query. Please help us on this issue. Thanks, Srikanth

Gianni Ceresa · Answer

Hi,

Is the "require fully qualified table names" checked in your 12c connection pool?

Because that's the settings making sure to not confuse tables when working with objects from multiple schemas with same names.