topic Re: Script in QlikView

Script

smilingjohn — Wed, 14 Oct 2015 09:05:44 GMT

Hi All Iam getting this below mentioned error

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Inventory_Ledger:

"SQL

SELECT

(select description from apps.FND_FLEX_VALUES_VL WHERE FLEX_VALUE_SET_ID=1014850 and summary_flag = 'N' and FLEX_VALUE_MEANING =gcc.segment2) SBU,

(select description from apps.FND_FLEX_VALUES_VL WHERE flex_value_set_id = 1014851 and summary_flag = 'N' and FLEX_VALUE_MEANING = gcc.SEGMENT3) loc,

ood.organization_code ORG,"

Can some one sugget me where iam wrong ?

Re: Script

jagan — Wed, 14 Oct 2015 09:15:22 GMT

Hi,

I think the query is wrong, you will get error near gcc. to which table you have given this alias?

Regards,

Jagan.

Re: Script

tamilarasu — Wed, 14 Oct 2015 09:30:09 GMT

Hi John,

Just a question. Do you have any date field in your script.? I have checked similar kind of thread and do a little google search. Check the below thread.

Use Date to query oracle db error

Re: Script

avinashelite — Wed, 14 Oct 2015 09:36:57 GMT

I think you have not posted the complete SQL query, try to execute the state in SQL developer or other SQL query tool and check the syntax once