4 Replies Latest reply: Jan 18, 2013 12:16 PM by AlexAnd RSS

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

      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 ....