Database error: ORA-00936: missing expression

[Former Member]

Hi Experts,

I have created one Sales Object in IDT by using below condition.

CASE WHEN((tab.source='india' AND tab.acontno LIKE '502%') OR

(tab.source='india' AND tab.acontno LIKE '501%')OR

(tab.source='india' AND tab.acontno= 'UNKNOWN')OR

(tab.source='india' AND tab.acontno = 'OTHERS')OR

(tab.source='india' AND tab.acontno is NULL))

THEN 'Y'

ELSE 'N'

END,

when i drag this sales object at query level its throwing error like Database error: ORA-00936: missing expression. (IES 10901) (WIS 10901).

But when i create filter condition in IDT with same condition its working fine and i can see the data  i created condition like

CASE WHEN((tab.source='india' AND tab.acontno LIKE '502%') OR  

(tab.source='india' AND tab.acontno LIKE '501%')OR

(tab.source='india' AND tab.acontno= 'UNKNOWN')OR

(tab.source='india' AND tab.acontno = 'OTHERS')OR

(tab.source='india' AND tab.acontno is NULL))

but now my requirement is user wants to see one object at report level based on that they will filter the data at report level.

Please help me on this.

Reagards,

DSP

[former_member188911]

Hi Durgasaiprasad,

have you tried to debug the query in SQL+ or Toad?

Thanks

SC