Distinct not applied in the generarted Query after upgrade to 11.1.1.9.3

1354837

After upgrade 11.1.1.9.3, the query generated by BI is not adding the distinct clause.

The same criteria when used in the 11.1.1.7 has the distinct clause,.

Example: 11.1.1.7.x

WITH SAWITH0 AS (select T1445758.SUPPLIER_MKT as c1, T1445758.SUPPLIER_FLG as c2, T1445758.SUPPLIER_NAME as c3, T1445758.SUPPLIER_NUM as c4, T1445758.PRODLINE_DESC as c5 from WC_SUPPLIER_MATRIX_D T1445758 /* Dim_WC_SUPPLIER_MATRIX_D */ )

select distinct 0 as c1, D1.c1 as c2, D1.c2 as c3, D1.c3 as c4, D1.c4 as c5, D1.c5 as c6 from SAWITH0 D1;

Same criteria from 11.1.1.9.3

WITH SAWITH0 AS (select T1445758.SUPPLIER_MKT as c1, T1445758.SUPPLIER_FLG as c2, T1445758.SUPPLIER_NAME as c3, T1445758.SUPPLIER_NUM as c4, T1445758.PRODLINE_DESC as c5 from WC_SUPPLIER_MATRIX_D T1445758 /* Dim_WC_SUPPLIER_MATRIX_D */ )

select 0 as c1, D1.c1 as c2, D1.c2 as c3, D1.c3 as c4, D1.c4 as c5, D1.c5 as c6 from SAWITH0 D1

I checked the DB features and the DISTINCT_SUPPORTED feature is checked.

Can somebody help solve this .