This discussion is archived
4 Replies Latest reply: Jan 18, 2013 10:16 AM by AlexAnd RSS

Got ORA-00933: SQL command not properly ended while submitting BIP Report

kalidoss Newbie
Currently Being Moderated
Hi All,

I have got the subjected error while submitting the XML report concurrent Program in R12.

I have used lexical parameters in my data template and build the where clause in before report trigger.

If i commented this lexical parameter thing in Data template and ran the report it was working fine...

I have enabled the "debug_mode" property in Data template and i could see the query in log but the lexical parameter is coming as '&P_WHERE'. So I couldn't find that from where the error is coming...

Please help me on this ....



  • Correct Answers - 10 points
  • Helpful Answers - 5 points