This content has been marked as final. Show 1 reply
946887 wrote:Did you try to deploy the mapping ? Some time the expression validator gives wrong error messege.
We are using OWB version 10.2.0.1.0. While using the below case statement We are getting the validation message as 'The expression is not properly formed'.
Try to deploy the mapping and see if you are still getting this issue
Case statement used in expression builder:
case when (INGRP1.CHARGETYPE in ('O','F') or INGRP1.TARIFF_GROUP in ('SMSINT','MMSINT')or ( INGRP1.CALL_TYPE = '002' and INGRP1.TARIFF_GROUP = 'MTV'))
(select call_zone_reltn_key from call_zone_reltn where
when substr( INGRP1.B_SUBNO,1,2)='00'
else substr( INGRP1.B_SUBNO,1)
Kindly help me out in fixing this error or suggest any alternate way to use the above query in OWB expression builder.