9 Replies Latest reply on Mar 7, 2018 9:28 PM by Rohit Kumar

    Unable to Install SmartIT 2.0 "User Experience patch"- ARERR 552 because of ORA-00937

    Uwe Ryczek

      Hi,

       

      i try to install the User Experience patch for SmartIT 2.0.

       

      The installation failed because the installer is unable to import the "FND:SmartIT Layout Metadata Master" form (which is a view form).

       

      If i try to import the form with the BMC Remedy Developer Studio the following error is shown:

      Invalid object name 'VW_LAYOUT_METADATA_MASTER'

       

      the sql log file contains the following entry:

      PreparedStatementCallback; bad SQL grammar []; nested execption is java.sql.SQLSyntaxErrorException : ORA-00937 not a single-group group function.

       

      After a look at the 'VW_LAYOUT_METADATA_MASTER' view i got headaches.....

       

      Does someone know a solution for this Problem?

       

      Regards,

       

        Uwe

       

      EDIT: by the way the exception is raised after a "select count(*) from VW_LAYOUT_METADATA_MASTER where rownum =1;"