Error JDE por vistas Transparent GW . Separador Decimal

 

seteado con este el ciente

SPANISH_SPAIN.WE8MSWIN1252

genera el error OCI0000179 - Error - ORA-28534: Heterogeneous Services preprocessing error

si lo cambiamos

american_america.WE8ISO8859P1

funciona OK

 

SELECT count(*) FROM PPJDFDTX.F5954009 WHERE ( WSDCT >= ’SH’ AND ( WSDOC >= 1376.000000 OR WSDCT <> ’SH’ )

AND ( WSKCO >= ’00035’ OR WSDCT <> ’SH’ OR WSDOC <> 1376.000000 )

AND ( WSDGJ >= 109293 OR WSDCT <> ’SH’ OR WSDOC <> 1376.000000 OR WSKCO <> ’00035’ )

AND ( WSJELN > 2.000000 OR WSDCT <> ’SH’ OR WSDOC <> 1376.000000 OR WSKCO <> ’00035’ OR WSDGJ <> 109293 )

AND ( WSLT >= ’AA’ OR WSDCT <> ’SH’ OR WSDOC <> 1376.000000 OR WSKCO <> ’00035’ OR WSDGJ <> 109293 OR WSJELN <> 2.000000 )

AND ( WSDCT >= ’SH’ OR WSDCT <> ’SH’ OR WSDOC <> 1376.000000 OR WSKCO <> ’00035’ OR WSDGJ <> 109293 OR WSJELN <> 2.000000 OR WSLT <> ’AA’ )

AND WSCO = ’00001’ AND WSDCT <> ’XX’ AND WSDOC <> 1074990.000000 ) AND ( WSMCU BETWEEN ’ ’ AND ’999999999999’ )

ORDER BY WSCO ASC,WSDOC ASC,WSICU ASC,WSDGJ ASC,WSLT ASC ;