Script

[smilingjohn]

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 ?

[jagan · Accepted solution]

Hi,

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

Regards,

Jagan.

[tamilarasu]

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

[avinashelite]

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